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. 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
ID form
Lookup Table structure of a completely normalized schema
Unlimited
Types of drilling
2. Level of OLAP integration
Desktop Administrative Functions
Derived Attribute Expression
Filter Definition Prompts
Very high; part of ETL process
3. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Types of analysis you can perform with OLAP Services
Schema
Relationship Tables
4 factors to consider when designing a data-warehouse schema
4. Direct: 2-tier - Server: 3-tier
Desktop Administrative Functions
Data warehouse characteristics
2 ways you can configure the Project Source to connect to the Metadata database
Stored
5. User requirements - Existing source data - Technical and performance considerations
MSTR Connectivity Wizard
Factors to consider when designing a logical data model
To create a Report Prompt
ETL process
6. Specifies a condition data must meet in order to be included in a report
Report Filter
Search Object
Attribute Forms
File > Email Reports As
7. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Unlimited
Metrics
Search-based prompts
Types of analysis you can perform with OLAP Services
8. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Sample Metrics commonly performed on Facts
To "drill down" on a report
Warehouse Catalog
9. Create the Project Source - Create the Database Instance
To create the Project connectivity
2 types of Table Keys
Desktop Analyst
OLTP
10. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Very high; part of ETL process
Thresholding
Objects you are allowed to Page-by
11. An environment in which the MSTR Desktop connects directly to the Metadata database.
Lookup Tables
Fact Expression
Table Keys
2-Tier Architecture
12. Compound - Homogeneous - Heterogeneous
The 3 MSTR Tools
2 types of Attribute Expression
3 types of Attributes
5 Report display views
13. What tool do you use to create the Metadata shell?
Configuration Wizard
Attribute Creation Wizard good for
Tasks when defining a User Hierarchy
Simple Metrics
14. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
4 factors to consider when designing a data-warehouse schema
Limitations of the Attribute Creation Wizard
Terabytes (TB)
15. Used to limit a possibly overwhelming set of potential prompt answers
Compound Metric
Search-based prompts
To "drill down" on a report
MSTR OLAP Services
16. AND - OR - OR NOT - AND NOT
Report Filter operators
Subtotals
OLAP
Project Source
17. To define the level of aggregation for a specific metric - Used for qualifications
5 steps to creating a logical data model
3 components of a Report
Attributes
Column Aliases
18. OLTP data storage measure
Shortcut in MSTR Desktop
Gigabytes (GB)
Report Prompts
4 factors to consider when designing a data-warehouse schema
19. Columns - Tables
Cannot create project objects
Architect Graphical Interface
Attribute Creation Wizard good for
2 components of a Physical Schema
20. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Sample Metrics commonly performed on Facts
Report Formatting
Subtotals
Attribute or its relationship(s)
21. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Types of analysis you can perform with OLAP Services
Object Prompts
Filter Definition Prompts
To save a Report Format
22. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Rollback your changes
Architect Graphical Interface
Table Keys
Components of a Derived Metric
23. What tool do you use to create the Metadata DSN connection?
Subtotals
Default Project folder structure
Components of a MSTR architecture
MSTR Connectivity Wizard
24. Folder List - Object Viewer - Shortcut Bar
Fact Tables
3 Sections of the MSTR Desktop interface
Object Prompts
Report Editor
25. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Aggregate a Metric
Outline Mode
Process for creating the Project Metadata
File > Email Reports As
26. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
2 types of Attribute Expression
Heterogeneous Fact
To "drill down" on a report
Logical Data Model
27. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
By default
Outline Mode
Limitations of the Attribute Creation Wizard
28. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Object Prompts
Lookup Table structure of a completely normalized schema
3-Tier Architecture
Drilling
29. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Report Editor
Project-level options/settings
Schema Objects
3 Schema types
30. OLAP Services does not add any ______ to the report query.
Components of Compound Metrics
The 3 MSTR Tools
To save a Report Format
New SQL
31. It contains links to specific folders in the Folder List
3-Tier Architecture
Shortcut Bar
ETL process
3 Types of Objects in MSTR Desktop
32. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
3 Types of Objects in MSTR Desktop
OLAP
Table Keys
33. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Derived Attribute Expression
ID form
MSTR applications
34. Descriptive data that provides context for Facts.
Level Prompts
Attribute Forms
4 properties you must know in order to create attributes using the Attribute Editor
Different methods for creating Page-by fields
35. User reporting requirements - Query performance - Data volume - DB Maintenance
Relationship Tables
Compound Metric
Architect Graphical Interface
4 factors to consider when designing a data-warehouse schema
36. All Attributes must have an _______.
ID form
Attribute Forms
Lookup Table structure of a completely denormalized schema
Subtotals
37. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
Architect Graphical Interface
Factors to consider when designing a logical data model
Object Prompts
38. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Types of drilling
Application Objects
The 3 MSTR Tools
2 ways you can configure the Project Source to connect to the Metadata database
39. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Tasks when defining a User Hierarchy
Different methods for creating Page-by fields
Attribute Relationships
2 types of Attribute Expression
40. 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
Cannot create project objects
3 Schema types
User Hierarchies
Desktop Designer
41. Simple - Compound - Nested - Derived
4 types of Metrics
Table Keys
Report Prompts
Schema
42. Metrics aggregate on the lowest-level attribute __________.
4 tasks of the Attribute Creation Wizard
By default
Shortcut Bar
Lookup Table structure of a moderately denormalized schema
43. You can _____________ in the Architect Graphical Interface.
3 Sections of the MSTR Desktop interface
Rollback your changes
3 column types of a Physical Schema
Source system characteristics
44. Primary keys
Table Keys
Desktop Administrative Functions
MSTR Desktop
Components of Compound Metrics
45. The logical associations between attributes that exist based on a business rule
Fact Expression
MSTR Connectivity Wizard
Attribute Relationships
Table Keys
46. To see data at completely different levels - other than that of the original Grid or Graph
Level Prompts
Drilling
Gigabytes (GB)
Methods are there to creating Attributes
47. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
2-Tier Architecture
Simple Metrics
User Hierarchies
48. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Desktop Administrative Functions
Project
4 types of Report Filters
The 3 MSTR Tools
49. It contains the ID column of the parent attribute
4 tasks of the Attribute Creation Wizard
Tasks when defining a User Hierarchy
Lookup Table structure of a completely normalized schema
Project
50. A new tool for project design tasks - used for fine-tuning a project after initial creation
2 ways you can configure the Project Source to connect to the Metadata database
Components of a MSTR architecture
Components of the Logical Data Model
Architect Graphical Interface