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. Metrics aggregate on the lowest-level attribute __________.
Notes
By default
Limitations of the Attribute Creation Wizard
Relationship Tables
2. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Attribute Relationships
User Hierarchies
Physical Schema
3. The actual column name for a fact. Every fact must have at least 1 expression.
4 properties you must know in order to create attributes using the Attribute Editor
Lookup Table structure of a completely denormalized schema
Fact Expression
Report Filter
4. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Cannot create project objects
Attributes
To save a Report Format
Components of a Derived Metric
5. Compound - Homogeneous - Heterogeneous
Homogeneous Attribute
3 types of Attributes
Page-by
Configuration Wizard
6. Used to "fine-tune" your Project
Architect Graphical Interface
Components of a MSTR architecture
Search-based prompts
The 3 MSTR Tools
7. To define the level of aggregation for a specific metric - Used for qualifications
Schema Objects
Attributes
To create a Report Prompt
To edit the appearance of a Graph in a report
8. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Data warehouse characteristics
3 column types of a Physical Schema
Simple Attribute Expression
2 options for Sorting
9. Level of OLAP integration
Aggregate a Metric
Very high; part of ETL process
Advantage of a completely denormalized schema
Components of a Metric
10. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Attribute Elements
Terabytes (TB)
Required on the report for Outline Model to work
Fact Expression
11. User requirements - Existing source data - Technical and performance considerations
Attribute Elements
Hierarchies
To create the Project connectivity
Factors to consider when designing a logical data model
12. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
4 types of Metrics
Report Filter
Homogeneous Fact
13. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
OLAP
Components of Compound Metrics
Components of a MSTR architecture
Desktop Analyst
14. A new tool for project design tasks - used for fine-tuning a project after initial creation
Required on the report for Outline Model to work
Short-term (2 - 6 months)
Architect Graphical Interface
Gigabytes (GB)
15. It contains links to specific folders in the Folder List
MSTR applications
Shortcut Bar
Tasks when defining a User Hierarchy
MSTR OLAP Services
16. Simple - Derived
Different methods for creating Page-by fields
2 types of Attribute Relationships
2 types of Attribute Expression
2 types of Table Keys
17. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Configuration Wizard
Project
2 types of Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
18. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
2-Tier Architecture
Terabytes (TB)
OLTP
By default
19. An environment in which the MSTR Desktop connects directly to the Metadata database.
Schema
Using a Search Object
2-Tier Architecture
View Filter
20. You can _____________ in the Architect Graphical Interface.
5 Report display views
Terabytes (TB)
3 project creation interfaces
Rollback your changes
21. Groupings of directly related attributes. Also commonly known as "dimensions".
ETL process
Hierarchies
Facts
2 types of Facts
22. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Components of a Derived Metric
Lookup Table structure of a moderately denormalized schema
4 types of Report Filters
Search Object
23. View Filters can only ___________.
Lookup Table structure of a completely denormalized schema
Outline Mode
Reference Report Objects
Types of drilling
24. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
New SQL
Logical Data Model
Limitations of the Attribute Creation Wizard
Attribute Relationships
25. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
ETL
Project Source
To create the Project connectivity
Level Prompts
26. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
4 types of Prompts
OLAP
Reports
27. Facts associated to different column names in 2 or more tables
Characteristics of a Compound Table Key
Search Object
Components of a Derived Metric
Heterogeneous Fact
28. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
5 steps to creating a logical data model
Report Prompts
MSTR Connectivity Wizard
Compound Metric
29. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
4 basic Schema objects
Derived Metrics
OLTP
30. Simple - Compound - Nested - Derived
ETL
Report Prompts
Hierarchies
4 types of Metrics
31. Prompts to select a single value on which to qualify a date - number or text string.
Types of drilling
ETL
Value Prompts
Attribute Forms
32. OLAP retains data ________
View Filter
Long-term (2 - 5 years)
Objects you are allowed to Page-by
Minimal or none
33. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Types of analysis you can perform with OLAP Services
Level Prompts
Attribute Forms
Stored
34. Create the Project Source - Create the Database Instance
To create the Project connectivity
3 project creation interfaces
5 Report display views
Shortcut Bar
35. Formula - Level (Dimensionality) - Conditionality - Transformation
2 components of a Physical Schema
MSTR Desktop
Components of a Metric
3 types of Attributes
36. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Very high; part of ETL process
3 column types of a Physical Schema
Types of analysis you can perform with OLAP Services
37. A condition data must meet in order to be included in a report. Does affect the SQL.
Types of analysis you can perform with OLAP Services
'View of a Report'
Report Definitions
Report Filter
38. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Report Filter operators
File > Email Reports As
Derived Attribute Expression
39. Facts - Attributes - Hierarchies
Lookup Table structure of a moderately denormalized schema
Report Template
Components of the Logical Data Model
Limitations of the Attribute Creation Wizard
40. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Components of Compound Metrics
Filter Definition Prompts
Characteristics of a Compound Table Key
41. AND - OR - OR NOT - AND NOT
2 types of Fact Expressions
Subtotals
File types are allowed for exporting a Report
Report Filter operators
42. Extraction - transformation - loading
Facts
Source system characteristics
ETL
Logical Data Model
43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Components of Compound Metrics
To "drill down" on a report
Architect Graphical Interface
Components of a MSTR architecture
44. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Schema Object Editor
4 tasks of the Attribute Creation Wizard
Components of a MSTR architecture
Report Formatting
45. OLAP data storage measure
Terabytes (TB)
Advantage of a completely denormalized schema
3 types of Attributes
Report Definitions
46. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
Value Prompts
Project Source
OLAP
47. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3 column types of a Physical Schema
ETL process
Highest-level attributes
Thresholding
48. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Terabytes (TB)
Project
Report Formatting
Subtotals
49. All Attributes must have an _______.
Reference Report Objects
ID form
4 properties you must know in order to create attributes using the Attribute Editor
Components of a Derived Metric
50. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Report Prompts
Limitations of the Attribute Creation Wizard
Derived Attribute Expression