SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Certified Project Designer Cpd
Start Test
Study First
Subjects
:
certifications
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Components of the Logical Data Model
3 project creation interfaces
Object Prompts
Schema
2. You can _____________ in the Architect Graphical Interface.
Column Aliases
Notes
4 parts of the Project Design Process
Rollback your changes
3. Metrics you create within a report using only those objects in the report.
ETL
MSTR OLAP Services
Report Subscription
Derived Metrics
4. It contains the ID and DESC columns of all higher-level attributes
Report Formatting
Project Source
Lookup Table structure of a completely denormalized schema
Configuration Wizard
5. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Default Project folder structure
Derived Attribute Expression
Physical Schema
6. All report-level options overwrite ___________.
4 factors to consider when designing a data-warehouse schema
Project
Homogeneous Attribute
Project-level options/settings
7. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Process for creating the Project Metadata
Desktop Designer
Homogeneous Attribute
To create the Project connectivity
8. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Page-by
3 types of Attributes
Object Prompts
2 types of Table Keys
9. The Attribute Form Expression that maps to a single column - no matter the number of tables
MSTR Connectivity Wizard
Simple Attribute Expression
Desktop Designer
Report Editor
10. An environment in which the MSTR Desktop connects directly to the Metadata database.
Components of Compound Metrics
2-Tier Architecture
Report Objects
Banding
11. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
3 project creation interfaces
2 ways you can configure the Project Source to connect to the Metadata database
Project Source
Tasks when defining a User Hierarchy
12. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
User Hierarchies
Homogeneous Fact
Advantage of a completely denormalized schema
Source system characteristics
13. The unique values of an attribute obtained from the data-warehouse
Desktop Designer
Metrics
Attribute Elements
Highest-level attributes
14. Columns - Tables
View Filter
Lookup Tables
2 components of a Physical Schema
Sorting
15. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Shortcut Bar
Simple Metrics
Reports
Attribute Elements
16. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Schema Objects
Filter Definition Prompts
2 types of Attribute Relationships
Required on the report for Outline Model to work
17. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
2 types of Fact Expressions
Cannot create project objects
User Hierarchies
Lookup Table structure of a moderately denormalized schema
18. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
3 Sections of the MSTR Desktop interface
3 column types of a Physical Schema
By default
Process for creating the Project Metadata
19. OLAP Services does not add any ______ to the report query.
3 types of Attributes
The 3 MSTR Tools
New SQL
Report Filter operators
20. Used to limit a possibly overwhelming set of potential prompt answers
Report Template
Rollback your changes
3 functions of Attribute Forms
Search-based prompts
21. A method of organizing the appearance of report results in a Grid report based on a criteria
5 steps to creating a logical data model
Page-by
Subtotals
Banding
22. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Report Filter
Data Pivoting
Methods are there to creating Attributes
23. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Required on the report for Outline Model to work
4 factors to consider when designing a data-warehouse schema
Report Filter
24. Descriptive data that provides context for Facts.
Outline Mode
Attribute Forms
Data Pivoting
Homogeneous Attribute
25. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Application Objects
Simple Attribute Expression
Fact Tables
Highest-level attributes
26. How users can share comments for reports to other users
Level Prompts
File > Email Reports As
Notes
Application Objects
27. AND - OR - OR NOT - AND NOT
Report Filter operators
Column Aliases
2 ways you can configure the Project Source to connect to the Metadata database
Report Objects
28. OLTP retains data ________
Banding
Short-term (2 - 6 months)
Desktop Administrative Functions
Heterogeneous Attribute
29. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Outline Mode
MSTR applications
Physical Schema
4 types of Metrics
30. Less storage - Simple SQL - Complex ETL
Homogeneous Attribute
Characteristics of a Simple Table Key
Simple Attribute Expression
To create a Report Prompt
31. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
MSTR Desktop
Cannot create project objects
Methods are there to creating Attributes
2 types of Attribute Relationships
32. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
3 Types of Objects in MSTR Desktop
Components of a MSTR architecture
Desktop Administrative Functions
Schema
33. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Search-based prompts
Project-level options/settings
Warehouse Catalog
34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Components of a Derived Metric
Components of the Logical Data Model
ETL
35. A user interface for creating and maintaining a BI environment
Schema Objects
Lookup Table structure of a completely normalized schema
MSTR Desktop
Compound Attribute
36. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Compound Metric
Report Subscription
Outline Mode
Thresholding
37. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
4 tasks of the Attribute Creation Wizard
Report Filter
Stored
Value Prompts
38. It contains the ID column of the parent attribute
2 methods to creating Facts
Project-level options/settings
Lookup Table structure of a completely normalized schema
Long-term (2 - 5 years)
39. Enables you to select and display subsets of a report as separate pages.
Report Filter
Advantage of a completely denormalized schema
Page-by
Schema Objects
40. To define the level of aggregation for a specific metric - Used for qualifications
MSTR Connectivity Wizard
Heterogeneous Attribute
3 components of a Report
Attributes
41. The Attribute Form maps to the same column name in multiple tables
Very high; part of ETL process
Shortcut in MSTR Desktop
Homogeneous Attribute
Project-level options/settings
42. A new tool for project design tasks - used for fine-tuning a project after initial creation
Fact Expression
Architect Graphical Interface
Sorting
Default Project folder structure
43. OLAP retains data ________
4 tasks of the Attribute Creation Wizard
To save a Report Format
Long-term (2 - 5 years)
Relationship Tables
44. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
3 components of a Report
Project
4 properties you must know in order to create attributes using the Attribute Editor
Subtotals
45. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Methods are there to creating Attributes
Page-by
Drilling
46. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Report Filter operators
Relationship Tables
Reports
47. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Rollback your changes
Report Subscription
4 tasks of the Attribute Creation Wizard
3 column types of a Physical Schema
48. The actual column name for a fact. Every fact must have at least 1 expression.
Components of a MSTR architecture
Fact Expression
Subtotals
Derived Metrics
49. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
Short-term (2 - 6 months)
Attribute Creation Wizard good for
2 types of Facts
50. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
File > Email Reports As
Outline Mode
Schema Object Editor
4 properties you must know in order to create attributes using the Attribute Editor
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests