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. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
ETL process
File types are allowed for exporting a Report
Facts
Search Object
2. Used to limit a possibly overwhelming set of potential prompt answers
'View of a Report'
Search-based prompts
Desktop Designer
Level Prompts
3. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
3 components of a Report
Physical Schema
OLTP
The 3 MSTR Tools
4. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
ID form
Value Prompts
3-Tier Architecture
Sample Metrics commonly performed on Facts
5. 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.
Components of a MSTR architecture
Report Prompts
Components of a Metric
Page-by
6. Primary keys
Table Keys
Thresholding
Short-term (2 - 6 months)
Attribute Forms
7. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Advantage of a completely denormalized schema
User Hierarchies
Column Aliases
Report Subscription
8. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Project Creation Wizard
To edit the appearance of a Graph in a report
2 options for Sorting
2 ways you can configure the Project Source to connect to the Metadata database
9. Store info on relationships between 2 or more tables (attributes) - like an Index table.
3 types of Attributes
Outline Mode
Report Formatting
Relationship Tables
10. Metrics that perform multiple aggregations; one calculation inside of another.
Relationship Tables
Nested Metrics
Architect Graphical Interface
Metrics
11. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
4 properties you must know in order to create attributes using the Attribute Editor
2 ways you can configure the Project Source to connect to the Metadata database
Application Objects
Limitations of the Attribute Creation Wizard
12. The logical associations between attributes that exist based on a business rule
To create the Project connectivity
Attribute Relationships
Configuration Wizard
The System
13. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Facts
Project Source
3-Tier Architecture
Compound Attribute
14. You can e-mail reports by going to _____
Project-level options/settings
Logical Data Model
Characteristics of a Compound Table Key
File > Email Reports As
15. Facts associated to different column names in 2 or more tables
Project-level options/settings
Heterogeneous Fact
4 types of Report Filters
Hierarchies
16. 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
Required on the report for Outline Model to work
The 3 MSTR Tools
4 factors to consider when designing a data-warehouse schema
17. OLAP data storage measure
Report Filter
Facts
Terabytes (TB)
3 Methods of MSTR Desktop navigation
18. ID columns - Description columns - Fact columns
Homogeneous Attribute
3 column types of a Physical Schema
Level Prompts
Derived Metrics
19. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
By default
Long-term (2 - 5 years)
Factors to consider when designing a logical data model
To "drill down" on a report
20. 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
Logical Data Model
Report Subscription
3-Tier Architecture
Drilling
21. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Compound Metric
Table Keys
Components of the Logical Data Model
22. Specifies a condition data must meet in order to be included in a report
Report Filter
Application Objects
3 column types of a Physical Schema
Heterogeneous Attribute
23. Grid View - Graph View - Grid/Graph View - SQL View
MSTR applications
Report Prompts
Value Prompts
Display views you can Print by
24. A shortcut to an existing Object in a Project
3 functions of Attribute Forms
By default
Types of analysis you can perform with OLAP Services
Shortcut in MSTR Desktop
25. Facts - Attributes - Hierarchies
Attributes
Page-by
Components of the Logical Data Model
Unlimited
26. Specifies what info to retrieve from a data-warehouse - and how to display it
Hierarchies
Schema Objects
Required on the report for Outline Model to work
Report Template
27. How users can share comments for reports to other users
4 tasks of the Attribute Creation Wizard
Heterogeneous Fact
User Hierarchies
Notes
28. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Attribute Elements
Level Prompts
Derived Attribute Expression
29. Simple - Compound - Nested - Derived
4 types of Metrics
Types of drilling
Drilling
Rollback your changes
30. Must have Subtotals enabled - or you won't see any data for higher-level attributes
MSTR OLAP Services
Schema
Types of analysis you can perform with OLAP Services
Required on the report for Outline Model to work
31. The Attribute Form maps to the same column name in multiple tables
Sorting
Homogeneous Attribute
Warehouse Catalog
Metrics
32. All report-level options overwrite ___________.
Project-level options/settings
OLAP
Outline Mode
Desktop Analyst
33. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Types of drilling
Derived Attribute Expression
Compound Metric
34. OLAP retains data ________
MSTR applications
Long-term (2 - 5 years)
2 types of Table Keys
Terabytes (TB)
35. User reporting requirements - Query performance - Data volume - DB Maintenance
3 Methods of MSTR Desktop navigation
4 factors to consider when designing a data-warehouse schema
Terabytes (TB)
Characteristics of a Compound Table Key
36. Level of OLTP integration
3 types of Attributes
Limitations of the Attribute Creation Wizard
Application Objects
Minimal or none
37. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
2 types of Facts
OLTP
Rollback your changes
Lookup Table structure of a completely denormalized schema
38. The Attribute Form maps to different column names in multiple tables
Hierarchies
Default Project folder structure
Heterogeneous Attribute
MSTR OLAP Services
39. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Report Editor
Report Filter operators
Data Pivoting
OLAP
40. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Reference Report Objects
Components of a MSTR architecture
Outline Mode
To save a Report Format
41. Less storage - Simple SQL - Complex ETL
4 types of Report Filters
Characteristics of a Simple Table Key
Simple Attribute Expression
Report Filter
42. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Compound Metric
Homogeneous Attribute
User Hierarchies
43. 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
Heterogeneous Fact
3 Sections of the MSTR Desktop interface
2 types of Table Keys
44. 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
'View of a Report'
Data Pivoting
Sample Metrics commonly performed on Facts
45. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Stored
Tasks when defining a User Hierarchy
Attribute Relationships
Object Prompts
46. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Value Prompts
Desktop Designer
View Filter
New SQL
47. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Compound Attribute
To save a Report Format
Stored
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
User Hierarchies
4 types of Report Filters
2-Tier Architecture
Gigabytes (GB)
49. Schema Objects - Application Objects - Configuration Objects
Heterogeneous Fact
Homogeneous Attribute
3 Types of Objects in MSTR Desktop
Hierarchies
50. The default entry-points.
ID form
Simple Attribute Expression
Highest-level attributes
By default