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. The unique values of an attribute obtained from the data-warehouse
3 project creation interfaces
Attribute Elements
Project Creation Wizard
Page-by
2. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Project
Report Prompts
Using a Search Object
4 types of Prompts
3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Gigabytes (GB)
Search Object
4 factors to consider when designing a data-warehouse schema
Reference Report Objects
4. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Report Prompts
Reports
Filter Definition Prompts
Report Objects
5. The logical associations between attributes that exist based on a business rule
Required on the report for Outline Model to work
Attribute Relationships
Schema Objects
2 components of a Physical Schema
6. Level of OLTP integration
Report Objects
The System
Stored
Minimal or none
7. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
3 project creation interfaces
Tasks when defining a User Hierarchy
Attribute Forms
8. OLTP retains data ________
Aggregate a Metric
Short-term (2 - 6 months)
Rollback your changes
Attribute Relationships
9. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Report Subscription
Desktop Administrative Functions
4 properties you must know in order to create attributes using the Attribute Editor
10. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
MSTR OLAP Services
Homogeneous Attribute
Sample Metrics commonly performed on Facts
11. One that uses 2 or more columns as its ID
Project
'View of a Report'
Compound Attribute
The 3 MSTR Tools
12. Primary keys
View Filter
Table Keys
3-Tier Architecture
2 components of a Physical Schema
13. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute Forms
Lookup Table structure of a completely normalized schema
Attribute or its relationship(s)
Compound Metric
14. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Short-term (2 - 6 months)
4 tasks of the Attribute Creation Wizard
ETL
Heterogeneous Attribute
15. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Terabytes (TB)
Aggregate a Metric
Report Formatting
16. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Advantage of a completely denormalized schema
Report Prompts
Report Formatting
17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
To save a Report Format
To create the Project connectivity
Rollback your changes
18. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Characteristics of a Simple Table Key
Schema Object Editor
Fact Tables
19. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
ETL process
Search-based prompts
2 options for Sorting
Source system characteristics
20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
2 types of Attribute Relationships
5 Report display views
Report Objects
Components of a MSTR architecture
21. Enables you to lock column headers so that they always appear when scrolling
Short-term (2 - 6 months)
Attributes
Locking and Resizing
The System
22. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Architect Graphical Interface
Attribute or its relationship(s)
Physical Schema
Report Formatting
23. The Attribute Form Expression that maps to a single column - no matter the number of tables
'View of a Report'
OLAP
Simple Attribute Expression
2 types of Attribute Expression
24. 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.
Lookup Table structure of a completely denormalized schema
Report Template
Report Prompts
Desktop Analyst
25. Specifies a condition data must meet in order to be included in a report
Components of Compound Metrics
Report Filter
Notes
'View of a Report'
26. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Data Pivoting
Locking and Resizing
Object Prompts
2 types of Attribute Relationships
27. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Components of a Metric
Long-term (2 - 5 years)
Report Objects
Process for creating the Project Metadata
28. Template - Filter - View of a Report
2 types of Table Keys
Project Creation Wizard
Required on the report for Outline Model to work
3 components of a Report
29. All report-level options overwrite ___________.
Project-level options/settings
Attribute Forms
Cannot create project objects
Types of analysis you can perform with OLAP Services
30. Facts associated to the same column name in 1 or more tables
Types of analysis you can perform with OLAP Services
Homogeneous Fact
Reports
View Filters
31. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Gigabytes (GB)
Project Creation Wizard
Aggregate a Metric
Filter Definition Prompts
32. Enables you to select and display subsets of a report as separate pages.
To create a Report Prompt
Page-by
Tasks when defining a User Hierarchy
Cannot create project objects
33. Grid View - Graph View - Grid/Graph View - SQL View
Homogeneous Fact
2 ways you can configure the Project Source to connect to the Metadata database
Display views you can Print by
Level Prompts
34. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
2 methods to creating Facts
Compound Attribute
Attribute Relationships
35. OLTP data storage measure
To qualify a Metric in a Set Qualification
Gigabytes (GB)
Value Prompts
3 project creation interfaces
36. Specifies what info to retrieve from a data-warehouse - and how to display it
Application Objects
Report Template
To create a Report Prompt
2 methods to creating Facts
37. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Report Editor
Default Project folder structure
Lookup Table structure of a completely denormalized schema
38. Must have Subtotals enabled - or you won't see any data for higher-level attributes
MSTR Desktop
Required on the report for Outline Model to work
To "drill down" on a report
Different methods for creating Page-by fields
39. Using the Prompt Generation Wizard - Inside the Report Editor
Search Object
Minimal or none
3 column types of a Physical Schema
To create a Report Prompt
40. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
2 types of Attribute Expression
Data warehouse characteristics
3 column types of a Physical Schema
Level Prompts
41. User requirements - Existing source data - Technical and performance considerations
Short-term (2 - 6 months)
Schema
Factors to consider when designing a logical data model
4 types of Metrics
42. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Shortcut Bar
4 parts of the Project Design Process
Project-level options/settings
43. OLAP retains data ________
Configuration Wizard
Report Subscription
Long-term (2 - 5 years)
Desktop Designer
44. You must select "Other directions" when drilling attributes while viewing a report
3 Schema types
2 methods to creating Facts
To create the Project connectivity
To drill through User Hierarchies
45. You can e-mail reports by going to _____
3 Sections of the MSTR Desktop interface
Aggregate a Metric
File > Email Reports As
To "drill down" on a report
46. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
4 types of Report Filters
User Hierarchies
2 components of a Physical Schema
Default Project folder structure
47. The Attribute Form maps to different column names in multiple tables
Sample Metrics commonly performed on Facts
Desktop Designer
Heterogeneous Attribute
Highest-level attributes
48. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Reports
Sample Metrics commonly performed on Facts
3-Tier Architecture
Cannot create project objects
49. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Factors to consider when designing a logical data model
2 types of Attribute Relationships
3 Sections of the MSTR Desktop interface
50. OLAP Services does not add any ______ to the report query.
OLAP
Facts
New SQL
Physical Schema