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. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Report Prompts
Components of Compound Metrics
Compound Metric
To save a Report Format
2. More storage - Complex SQL - Simple ETL
Characteristics of a Simple Table Key
Fact Tables
Column Aliases
Characteristics of a Compound Table Key
3. Top menu/dropdowns - Toolbar - Right-click popup menus
The 3 MSTR Tools
Object Prompts
3 Methods of MSTR Desktop navigation
Sample Metrics commonly performed on Facts
4. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
To create a Report Prompt
Sample Metrics commonly performed on Facts
Components of Compound Metrics
5. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
3-Tier Architecture
Using a Search Object
Fact Tables
6. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
The System
Object Prompts
2 components of a Physical Schema
To edit the appearance of a Graph in a report
7. Metrics aggregate on the lowest-level attribute __________.
5 steps to creating a logical data model
4 tasks of the Attribute Creation Wizard
4 types of Prompts
By default
8. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Sorting
Components of the Logical Data Model
5 Report display views
To "drill down" on a report
9. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Characteristics of a Simple Table Key
To save a Report Format
Notes
10. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
4 factors to consider when designing a data-warehouse schema
Simple Metrics
Highest-level attributes
The 3 MSTR Tools
11. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
4 tasks of the Attribute Creation Wizard
Terabytes (TB)
Report Filter operators
12. Subtotals reflect accumulations at selected attribute levels
Hierarchies
4 types of Prompts
Subtotals
Search Object
13. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Advantage of a completely denormalized schema
Fact Tables
Schema
Search Object
14. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
3 Sections of the MSTR Desktop interface
The System
Homogeneous Attribute
15. 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
Limitations of the Attribute Creation Wizard
Attribute Relationships
Banding
Types of drilling
16. A shortcut to an existing Object in a Project
Fact Expression
Architect Graphical Interface
Stored
Shortcut in MSTR Desktop
17. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Report Subscription
Components of a MSTR architecture
Reference Report Objects
3 project creation interfaces
18. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
3 Methods of MSTR Desktop navigation
2 types of Attribute Expression
Schema
19. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Logical Data Model
Process for creating the Project Metadata
Search Object
MSTR Desktop
20. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
To save a Report Format
Filter Definition Prompts
Different methods for creating Page-by fields
Unlimited
21. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
MSTR applications
2 components of a Physical Schema
To qualify a Metric in a Set Qualification
22. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Default Project folder structure
Heterogeneous Fact
OLTP
Shortcut Bar
23. 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
Table Keys
Report Filter
Schema
24. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Minimal or none
New SQL
Data warehouse characteristics
Attribute Creation Wizard good for
25. Template - Filter - View of a Report
Relationship Tables
Fact Expression
3 Methods of MSTR Desktop navigation
3 components of a Report
26. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Derived Metrics
Compound Attribute
4 factors to consider when designing a data-warehouse schema
Facts
27. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Characteristics of a Compound Table Key
User Hierarchies
Heterogeneous Fact
2 types of Table Keys
28. What tool do you use to create the Metadata shell?
Logical Data Model
MSTR Desktop Architect
MSTR Desktop
Configuration Wizard
29. 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.
Report Prompts
Components of Compound Metrics
Shortcut Bar
Report Definitions
30. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Report Template
Report Definitions
Compound Metric
Homogeneous Fact
31. View Filters are saved with the _____________.
MSTR applications
2 types of Facts
Report Definitions
ID form
32. Enables you to rearrange the columns and rows in a report.
Banding
3 functions of Attribute Forms
Terabytes (TB)
Data Pivoting
33. An environment in which the MSTR Desktop connects directly to the Metadata database.
To edit the appearance of a Graph in a report
2-Tier Architecture
Components of a MSTR architecture
Desktop Analyst
34. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
File > Email Reports As
Facts
Fact Tables
Fact Expression
35. Specifies what info to retrieve from a data-warehouse - and how to display it
3 Schema types
Required on the report for Outline Model to work
2 types of Facts
Report Template
36. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Facts
MSTR Connectivity Wizard
MSTR applications
37. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
3 functions of Attribute Forms
Attribute Creation Wizard good for
Cannot create project objects
Compound Metric
38. Folder List - Object Viewer - Shortcut Bar
Desktop Analyst
3 Sections of the MSTR Desktop interface
Components of a Derived Metric
To create the Project connectivity
39. You can e-mail reports by going to _____
Report Template
File > Email Reports As
Components of Compound Metrics
Reference Report Objects
40. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3 column types of a Physical Schema
To save a Report Format
3 Types of Objects in MSTR Desktop
ETL process
41. It contains the ID and DESC columns of all higher-level attributes
Architect Graphical Interface
Logical Data Model
3 column types of a Physical Schema
Lookup Table structure of a completely denormalized schema
42. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Simple Metrics
Characteristics of a Compound Table Key
Terabytes (TB)
43. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Characteristics of a Simple Table Key
Schema Object Editor
3 project creation interfaces
Simple Metrics
44. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Facts
Attribute Forms
Characteristics of Nested Metrics
Cannot create project objects
45. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
2-Tier Architecture
Value Prompts
5 steps to creating a logical data model
3 components of a Report
46. Using the Prompt Generation Wizard - Inside the Report Editor
Project-level options/settings
View Filter
To create a Report Prompt
Characteristics of a Simple Table Key
47. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
2 types of Attribute Relationships
3 functions of Attribute Forms
Facts
Desktop Analyst
48. It contains the ID column of all higher-level attributes
Report Filter
Fact Tables
File types are allowed for exporting a Report
Lookup Table structure of a moderately denormalized schema
49. One that uses 2 or more columns as its ID
Column Aliases
4 types of Report Filters
Compound Attribute
MSTR Desktop
50. Extraction - transformation - loading
Thresholding
ETL
By default
2 types of Fact Expressions