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. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
2. 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
Default Project folder structure
Short-term (2 - 6 months)
OLAP
'View of a Report'
3. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Compound Attribute
Components of Compound Metrics
Compound Metric
Attribute Forms
4. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Project Source
Report Prompts
Object Prompts
Highest-level attributes
5. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Fact Tables
4 tasks of the Attribute Creation Wizard
Drilling
To edit the appearance of a Graph in a report
6. You must select "Other directions" when drilling attributes while viewing a report
Lookup Tables
Report Objects
To drill through User Hierarchies
The 3 MSTR Tools
7. 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
Attribute Forms
2 methods to creating Facts
Drilling
8. You can e-mail reports by going to _____
File > Email Reports As
Report Filter
Attribute Elements
Search-based prompts
9. Enables you to select and display subsets of a report as separate pages.
Short-term (2 - 6 months)
To qualify a Metric in a Set Qualification
Page-by
To create the Project connectivity
10. Columns - Tables
Notes
2 components of a Physical Schema
Application Objects
2 types of Table Keys
11. Subtotals reflect accumulations at selected attribute levels
3 components of a Report
Subtotals
To edit the appearance of a Graph in a report
Attribute or its relationship(s)
12. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Homogeneous Fact
Types of drilling
2 types of Fact Expressions
Shortcut in MSTR Desktop
13. Primary keys
3 Methods of MSTR Desktop navigation
Attribute Forms
Value Prompts
Table Keys
14. OLAP data storage measure
MSTR applications
5 Report display views
Unlimited
Terabytes (TB)
15. Facts associated to different column names in 2 or more tables
Components of the Logical Data Model
2-Tier Architecture
Heterogeneous Fact
Sample Metrics commonly performed on Facts
16. A feature that enables users to delivers reports to the history list - cache or mobile
Minimal or none
To qualify a Metric in a Set Qualification
4 types of Report Filters
Report Subscription
17. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Characteristics of a Simple Table Key
Relationship Tables
Attribute Forms
Rollback your changes
18. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Unlimited
Types of analysis you can perform with OLAP Services
To edit the appearance of a Graph in a report
User Hierarchies
19. Using the Prompt Generation Wizard - Inside the Report Editor
Object Prompts
To create a Report Prompt
4 parts of the Project Design Process
Very high; part of ETL process
20. Used to limit a possibly overwhelming set of potential prompt answers
Short-term (2 - 6 months)
Characteristics of a Simple Table Key
Search-based prompts
Compound Attribute
21. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Methods are there to creating Attributes
2 methods to creating Facts
Schema
22. Used to "fine-tune" your Project
Configuration Wizard
2 types of Table Keys
Characteristics of a Simple Table Key
Architect Graphical Interface
23. The default entry-points.
Banding
Stored
User Hierarchies
Highest-level attributes
24. A new tool for project design tasks - used for fine-tuning a project after initial creation
Lookup Table structure of a completely normalized schema
Components of the Logical Data Model
Architect Graphical Interface
Highest-level attributes
25. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Attribute Elements
3 project creation interfaces
Warehouse Catalog
Report Filter
26. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Filter
2-Tier Architecture
Attribute or its relationship(s)
Banding
27. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Shortcut in MSTR Desktop
To create the Project connectivity
Lookup Tables
2 types of Fact Expressions
28. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
3 Methods of MSTR Desktop navigation
Hierarchies
Types of analysis you can perform with OLAP Services
29. The Attribute Form maps to the same column name in multiple tables
Process for creating the Project Metadata
Logical Data Model
3 column types of a Physical Schema
Homogeneous Attribute
30. Specifies a condition data must meet in order to be included in a report
Report Filter
3 Sections of the MSTR Desktop interface
Aggregate a Metric
2-Tier Architecture
31. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Data Pivoting
5 Report display views
ETL process
Aggregate a Metric
32. AND - OR - OR NOT - AND NOT
Source system characteristics
3 types of Attributes
Application Objects
Report Filter operators
33. 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.
View Filters
Metrics
Hierarchies
Report Template
34. 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
Outline Mode
Fact Expression
Components of a Derived Metric
35. Metrics you create within a report using only those objects in the report.
Derived Metrics
Project-level options/settings
User Hierarchies
Lookup Table structure of a completely denormalized schema
36. OLTP retains data ________
Objects you are allowed to Page-by
Short-term (2 - 6 months)
The System
Factors to consider when designing a logical data model
37. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Process for creating the Project Metadata
3 functions of Attribute Forms
Attribute or its relationship(s)
2 types of Table Keys
38. 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
To qualify a Metric in a Set Qualification
Nested Metrics
MSTR OLAP Services
Banding
39. It contains links to specific folders in the Folder List
Lookup Table structure of a completely denormalized schema
Table Keys
Attributes
Shortcut Bar
40. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Characteristics of Nested Metrics
Attribute or its relationship(s)
4 basic Schema objects
41. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Characteristics of Nested Metrics
3 types of Attributes
MSTR Desktop
42. Simple - Derived
3 types of Attributes
2 types of Attribute Expression
Nested Metrics
4 tasks of the Attribute Creation Wizard
43. Direct: 2-tier - Server: 3-tier
2 types of Facts
Desktop Administrative Functions
Simple Metrics
2 ways you can configure the Project Source to connect to the Metadata database
44. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Desktop Designer
Report Objects
Fact Tables
Warehouse Catalog
45. A user interface for creating and maintaining a BI environment
MSTR Desktop
Derived Metrics
Objects you are allowed to Page-by
Configuration Wizard
46. ID columns - Description columns - Fact columns
Report Formatting
Schema Object Editor
MSTR OLAP Services
3 column types of a Physical Schema
47. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Value Prompts
Physical Schema
Reports
Metrics
48. 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
Highest-level attributes
Filter Definition Prompts
Long-term (2 - 5 years)
4 types of Report Filters
49. All report-level options overwrite ___________.
Project-level options/settings
Short-term (2 - 6 months)
Different methods for creating Page-by fields
3 Types of Objects in MSTR Desktop
50. The logical associations between attributes that exist based on a business rule
View Filter
Aggregate a Metric
Page-by
Attribute Relationships