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. Groupings of directly related attributes. Also commonly known as "dimensions".
Reports
2 types of Fact Expressions
MSTR OLAP Services
Hierarchies
2. All Attributes must have an _______.
ID form
Derived Attribute Expression
View Filter
Factors to consider when designing a logical data model
3. Tables - Facts - Attributes - Hierarchies
Report Filter operators
5 steps to creating a logical data model
3 Schema types
4 basic Schema objects
4. Facts - Attributes - Hierarchies
Fact Expression
Components of the Logical Data Model
3 types of Attributes
Lookup Table structure of a moderately denormalized schema
5. A condition data must meet in order to be included in a report. Does affect the SQL.
Source system characteristics
Report Filter
To qualify a Metric in a Set Qualification
Column Aliases
6. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Logical Data Model
4 tasks of the Attribute Creation Wizard
Locking and Resizing
Attribute Forms
7. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
3 types of Attributes
3 components of a Report
Components of a Derived Metric
3 Types of Objects in MSTR Desktop
8. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Desktop Architec
Advantage of a completely denormalized schema
Configuration Wizard
9. OLAP data storage measure
To create the Project connectivity
Terabytes (TB)
Components of a MSTR architecture
ID form
10. Level of OLAP integration
4 parts of the Project Design Process
Report Filter
Very high; part of ETL process
File > Email Reports As
11. Simple - Compound - Nested - Derived
Highest-level attributes
Methods are there to creating Attributes
Using a Search Object
4 types of Metrics
12. Metrics you create within a report using only those objects in the report.
Lookup Table structure of a completely denormalized schema
Derived Metrics
Simple Metrics
File > Email Reports As
13. View Filters are saved with the _____________.
Report Definitions
Project-level options/settings
3 Sections of the MSTR Desktop interface
2 options for Sorting
14. Allow you to interact with the BI system - logically organize data to analyze complex relationships
2 ways you can configure the Project Source to connect to the Metadata database
Search-based prompts
Characteristics of a Simple Table Key
MSTR applications
15. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
The System
Outline Mode
2 methods to creating Facts
Schema
16. Columns - Tables
Methods are there to creating Attributes
2 components of a Physical Schema
MSTR OLAP Services
Tasks when defining a User Hierarchy
17. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
4 types of Prompts
To create the Project connectivity
Gigabytes (GB)
18. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Facts
2 types of Facts
Configuration Wizard
Column Aliases
19. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
2 types of Attribute Relationships
Search Object
Data warehouse characteristics
Aggregate a Metric
20. Grid View - Graph View - Grid/Graph View - SQL View
Report Prompts
Locking and Resizing
3 project creation interfaces
Display views you can Print by
21. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Types of drilling
Attribute Creation Wizard good for
Fact Tables
Schema Object Editor
22. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Thresholding
Report Objects
View Filters
Reference Report Objects
23. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Physical Schema
2 types of Fact Expressions
Short-term (2 - 6 months)
Attribute Creation Wizard good for
24. Enables you to select and display subsets of a report as separate pages.
Rollback your changes
Shortcut in MSTR Desktop
Page-by
Report Filter operators
25. It contains the ID column of the parent attribute
Components of Compound Metrics
Lookup Table structure of a completely normalized schema
Notes
By default
26. Using the Prompt Generation Wizard - Inside the Report Editor
Facts
Report Filter operators
Compound Metric
To create a Report Prompt
27. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Types of drilling
Schema Objects
Derived Attribute Expression
Nested Metrics
28. Create the Project Source - Create the Database Instance
3 functions of Attribute Forms
To create the Project connectivity
Project-level options/settings
Fact Expression
29. Descriptive data that provides context for Facts.
3 types of Attributes
Attribute Forms
Homogeneous Fact
Project Creation Wizard
30. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
3 column types of a Physical Schema
Data warehouse characteristics
Banding
31. Must have a one-to-one relationship with all other forms.
Heterogeneous Attribute
Attribute Forms
View Filter
To qualify a Metric in a Set Qualification
32. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Advantage of a completely denormalized schema
Components of a MSTR architecture
Report Formatting
Report Filter
33. Attribute Creation Wizard - Attribute Editor
Heterogeneous Fact
To "drill down" on a report
Methods are there to creating Attributes
Simple Attribute Expression
34. Top menu/dropdowns - Toolbar - Right-click popup menus
2 types of Fact Expressions
File > Email Reports As
Level Prompts
3 Methods of MSTR Desktop navigation
35. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
3 column types of a Physical Schema
Level Prompts
Report Objects
Report Template
36. Used to limit a possibly overwhelming set of potential prompt answers
Display views you can Print by
Search-based prompts
5 Report display views
Components of a MSTR architecture
37. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Project Source
Schema
Types of analysis you can perform with OLAP Services
Sorting
38. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
MSTR applications
Components of a Derived Metric
Factors to consider when designing a logical data model
39. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
Limitations of the Attribute Creation Wizard
Reports
Highest-level attributes
40. More storage - Complex SQL - Simple ETL
Fact Expression
Column Aliases
Rollback your changes
Characteristics of a Compound Table Key
41. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
Object Prompts
3 column types of a Physical Schema
Characteristics of a Simple Table Key
42. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
4 properties you must know in order to create attributes using the Attribute Editor
Schema
Physical Schema
43. To see data at completely different levels - other than that of the original Grid or Graph
New SQL
Thresholding
Short-term (2 - 6 months)
Drilling
44. To define the level of aggregation for a specific metric - Used for qualifications
5 Report display views
3 functions of Attribute Forms
Column Aliases
Attributes
45. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Value Prompts
Facts
Schema Object Editor
Characteristics of a Simple Table Key
46. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 types of Facts
Search Object
3 project creation interfaces
Shortcut in MSTR Desktop
47. Used for - Initially populating the Metadata - Creating schema objects
5 steps to creating a logical data model
3 functions of Attribute Forms
MSTR Desktop Architect
Derived Attribute Expression
48. The default entry-points.
Unlimited
Sample Metrics commonly performed on Facts
Components of Compound Metrics
Highest-level attributes
49. Used to "fine-tune" your Project
Derived Attribute Expression
Architect Graphical Interface
By default
3 types of Attributes
50. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
The System
Desktop Designer
Report Formatting
Rollback your changes