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 Attribute Form Expression that maps to a single column - no matter the number of tables
3 Types of Objects in MSTR Desktop
3 types of Attributes
Relationship Tables
Simple Attribute Expression
2. Template - Filter - View of a Report
2 methods to creating Facts
Desktop Administrative Functions
Physical Schema
3 components of a Report
3. Specifies what info to retrieve from a data-warehouse - and how to display it
Process for creating the Project Metadata
Report Template
Compound Metric
The System
4. Extraction - transformation - loading
Attribute Creation Wizard good for
4 types of Prompts
Attribute Relationships
ETL
5. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Level Prompts
Facts
Reference Report Objects
6. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
2 components of a Physical Schema
Characteristics of a Simple Table Key
Table Keys
7. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Rollback your changes
Reports
Compound Metric
ETL
8. OLTP retains data ________
Short-term (2 - 6 months)
Level Prompts
Report Subscription
Subtotals
9. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Schema Object Editor
Process for creating the Project Metadata
Configuration Wizard
Relationship Tables
10. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
MSTR Desktop Architect
2 options for Sorting
3 Sections of the MSTR Desktop interface
Thresholding
11. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Level Prompts
Process for creating the Project Metadata
Data Pivoting
12. Enables you to rearrange the columns and rows in a report.
The System
Minimal or none
Data Pivoting
Shortcut Bar
13. It contains the ID column of the parent attribute
3 Methods of MSTR Desktop navigation
3 Types of Objects in MSTR Desktop
ID form
Lookup Table structure of a completely normalized schema
14. Less storage - Simple SQL - Complex ETL
File > Email Reports As
Heterogeneous Fact
4 tasks of the Attribute Creation Wizard
Characteristics of a Simple Table Key
15. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Simple Metrics
Unlimited
OLAP
16. View Filters are saved with the _____________.
Report Definitions
Report Objects
3-Tier Architecture
File types are allowed for exporting a Report
17. How users can share comments for reports to other users
View Filter
To create a Report Prompt
Project Creation Wizard
Notes
18. It contains links to specific folders in the Folder List
Shortcut Bar
Outline Mode
New SQL
Reports
19. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
4 types of Report Filters
Desktop Designer
Facts
20. 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.
4 properties you must know in order to create attributes using the Attribute Editor
View Filters
Terabytes (TB)
File types are allowed for exporting a Report
21. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
File types are allowed for exporting a Report
Characteristics of a Compound Table Key
Components of Compound Metrics
22. You can e-mail reports by going to _____
Required on the report for Outline Model to work
File > Email Reports As
3 Sections of the MSTR Desktop interface
2 methods to creating Facts
23. Enables you to lock column headers so that they always appear when scrolling
Report Filter operators
Locking and Resizing
Tasks when defining a User Hierarchy
ID form
24. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Schema Object Editor
Display views you can Print by
File types are allowed for exporting a Report
2 types of Attribute Relationships
25. All Attributes must have an _______.
Report Definitions
Schema Objects
2 types of Table Keys
ID form
26. Subtotals reflect accumulations at selected attribute levels
4 tasks of the Attribute Creation Wizard
Derived Metrics
Application Objects
Subtotals
27. A user interface for creating and maintaining a BI environment
MSTR Desktop
Aggregate a Metric
Relationship Tables
Types of analysis you can perform with OLAP Services
28. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Simple Metrics
Aggregate a Metric
ID form
Desktop Designer
29. All report-level options overwrite ___________.
Factors to consider when designing a logical data model
Thresholding
ID form
Project-level options/settings
30. User reporting requirements - Query performance - Data volume - DB Maintenance
The 3 MSTR Tools
Process for creating the Project Metadata
4 factors to consider when designing a data-warehouse schema
Warehouse Catalog
31. Must have a one-to-one relationship with all other forms.
Tasks when defining a User Hierarchy
Attribute Forms
ETL
Components of a Metric
32. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Report Definitions
Report Formatting
Search Object
Attributes
33. 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
Factors to consider when designing a logical data model
Configuration Wizard
Report Editor
34. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Hierarchies
3 components of a Report
Rollback your changes
35. The logical associations between attributes that exist based on a business rule
Attribute Relationships
Report Filter operators
Minimal or none
Process for creating the Project Metadata
36. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
3 Schema types
Desktop Architec
Schema Object Editor
2 types of Fact Expressions
37. 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
3 types of Attributes
Characteristics of a Compound Table Key
Shortcut in MSTR Desktop
38. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Compound Metric
View Filters
Facts
39. One that uses 2 or more columns as its ID
Physical Schema
Compound Attribute
Components of a Derived Metric
The System
40. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Page-by
Object Prompts
Components of a Derived Metric
Project Source
41. Simple - Derived
Facts
2 types of Attribute Expression
Heterogeneous Attribute
2-Tier Architecture
42. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Reports
MSTR Desktop
Configuration Wizard
43. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Lookup Table structure of a completely normalized schema
MSTR Desktop
3 Types of Objects in MSTR Desktop
44. OLAP data storage measure
ETL
Terabytes (TB)
Homogeneous Attribute
Aggregate a Metric
45. Facts - Attributes - Hierarchies
Components of the Logical Data Model
'View of a Report'
Metrics
Compound Attribute
46. Primary keys
Homogeneous Attribute
Table Keys
3-Tier Architecture
Thresholding
47. What tool do you use to create the Metadata DSN connection?
Logical Data Model
Schema
To qualify a Metric in a Set Qualification
MSTR Connectivity Wizard
48. Creating multiple attributes quickly. Used during the initial project creation.
To save a Report Format
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Creation Wizard good for
Desktop Administrative Functions
49. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Types of drilling
4 types of Report Filters
Desktop Administrative Functions
Sample Metrics commonly performed on Facts
50. Reduced number of JOINS in the generated SQL
2 options for Sorting
Advantage of a completely denormalized schema
Attributes
Homogeneous Attribute