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. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
Components of a Metric
Search Object
Application Objects
2. 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
Desktop Designer
2 types of Facts
Tasks when defining a User Hierarchy
Process for creating the Project Metadata
3. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Attribute Relationships
Attribute or its relationship(s)
2 methods to creating Facts
4. Used for - Initially populating the Metadata - Creating schema objects
Highest-level attributes
MSTR Desktop Architect
2 types of Attribute Expression
Derived Metrics
5. Homogeneous - Heterogeneous
2 types of Facts
3 components of a Report
Types of drilling
Heterogeneous Attribute
6. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
MSTR Desktop
Level Prompts
Components of a MSTR architecture
3 functions of Attribute Forms
7. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Process for creating the Project Metadata
To qualify a Metric in a Set Qualification
3 functions of Attribute Forms
Schema Object Editor
8. Groupings of directly related attributes. Also commonly known as "dimensions".
Search-based prompts
Lookup Table structure of a completely denormalized schema
Lookup Tables
Hierarchies
9. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
2 types of Fact Expressions
ETL process
Components of Compound Metrics
Data warehouse characteristics
10. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
3 types of Attributes
New SQL
Components of a MSTR architecture
Column Aliases
11. Metrics that perform multiple aggregations; one calculation inside of another.
Report Template
3 Types of Objects in MSTR Desktop
Nested Metrics
Very high; part of ETL process
12. The Attribute Form maps to the same column name in multiple tables
Aggregate a Metric
Hierarchies
MSTR OLAP Services
Homogeneous Attribute
13. Facts associated to different column names in 2 or more tables
ETL process
The 3 MSTR Tools
Facts
Heterogeneous Fact
14. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
'View of a Report'
Sample Metrics commonly performed on Facts
3 functions of Attribute Forms
15. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
To qualify a Metric in a Set Qualification
Process for creating the Project Metadata
Architect Graphical Interface
16. A development environment to create BI applications - allowing users to edit the Metadata database
4 factors to consider when designing a data-warehouse schema
The 3 MSTR Tools
To qualify a Metric in a Set Qualification
Desktop Architec
17. It contains the ID column of the parent attribute
Very high; part of ETL process
Table Keys
Lookup Table structure of a completely normalized schema
User Hierarchies
18. Compound - Homogeneous - Heterogeneous
2 types of Attribute Expression
To "drill down" on a report
3 types of Attributes
Project
19. OLAP data storage measure
Terabytes (TB)
Tasks when defining a User Hierarchy
Minimal or none
Search-based prompts
20. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Lookup Table structure of a completely denormalized schema
MSTR applications
Characteristics of Nested Metrics
21. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
3 functions of Attribute Forms
Subtotals
Gigabytes (GB)
Components of a Derived Metric
22. Grid View - Graph View - Grid/Graph View - SQL View
Page-by
Display views you can Print by
Shortcut in MSTR Desktop
Object Prompts
23. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Attribute Elements
Physical Schema
Long-term (2 - 5 years)
Heterogeneous Attribute
24. Simple - Compound - Nested - Derived
Data warehouse characteristics
Using a Search Object
4 types of Metrics
To create the Project connectivity
25. Descriptive data that provides context for Facts.
The 3 MSTR Tools
Compound Metric
Short-term (2 - 6 months)
Attribute Forms
26. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Facts
Table Keys
3 project creation interfaces
27. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
ETL
Data warehouse characteristics
3 functions of Attribute Forms
To edit the appearance of a Graph in a report
28. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
MSTR Desktop
Desktop Architec
Simple Attribute Expression
29. An environment in which the MSTR Desktop connects directly to the Metadata database.
Minimal or none
3 Methods of MSTR Desktop navigation
2-Tier Architecture
Cannot create project objects
30. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
3 Methods of MSTR Desktop navigation
New SQL
Level Prompts
31. What tool do you use to create the Metadata DSN connection?
Attribute Forms
MSTR Connectivity Wizard
4 parts of the Project Design Process
Factors to consider when designing a logical data model
32. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Components of a Derived Metric
'View of a Report'
3-Tier Architecture
Facts
33. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Sample Metrics commonly performed on Facts
4 basic Schema objects
Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
34. Reduced number of JOINS in the generated SQL
3 Schema types
Advantage of a completely denormalized schema
Terabytes (TB)
View Filters
35. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Attribute or its relationship(s)
3 column types of a Physical Schema
Object Prompts
Fact Tables
36. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Different methods for creating Page-by fields
Cannot create project objects
Facts
ETL process
37. AND - OR - OR NOT - AND NOT
Long-term (2 - 5 years)
Project
4 types of Prompts
Report Filter operators
38. Formula - Level (Dimensionality) - Conditionality - Transformation
Search Object
3 Methods of MSTR Desktop navigation
Components of the Logical Data Model
Components of a Metric
39. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Characteristics of Nested Metrics
Report Template
4 basic Schema objects
Factors to consider when designing a logical data model
40. How users can share comments for reports to other users
Notes
Characteristics of a Compound Table Key
Short-term (2 - 6 months)
OLTP
41. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Facts
3 column types of a Physical Schema
Search Object
Report Prompts
42. OLAP Services does not add any ______ to the report query.
2 types of Table Keys
New SQL
Methods are there to creating Attributes
Value Prompts
43. 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
Report Objects
Components of a MSTR architecture
To drill through User Hierarchies
44. Facts associated to the same column name in 1 or more tables
To create a Report Prompt
Default Project folder structure
2 components of a Physical Schema
Homogeneous Fact
45. 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
Simple Metrics
New SQL
Characteristics of a Simple Table Key
Banding
46. 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.
Hierarchies
View Filters
The 3 MSTR Tools
To qualify a Metric in a Set Qualification
47. Folder List - Object Viewer - Shortcut Bar
3 functions of Attribute Forms
Display views you can Print by
3 Sections of the MSTR Desktop interface
Report Template
48. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Search-based prompts
Architect Graphical Interface
Report Filter
Default Project folder structure
49. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Locking and Resizing
Project
Report Template
Source system characteristics
50. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
2 types of Fact Expressions
File types are allowed for exporting a Report
Components of the Logical Data Model