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. OLTP retains data ________
Desktop Architec
Short-term (2 - 6 months)
Report Filter
To save a Report Format
2. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Attribute Forms
To save a Report Format
Shortcut Bar
3. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Desktop Administrative Functions
Facts
Shortcut in MSTR Desktop
4. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
4 factors to consider when designing a data-warehouse schema
Banding
3-Tier Architecture
5. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Configuration Wizard
Lookup Table structure of a completely normalized schema
Report Formatting
Components of Compound Metrics
6. 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
OLAP
Object Prompts
Project Source
7. Enables you to select which tables from the data-warehouse to store in the Metadata database
Methods are there to creating Attributes
OLTP
New SQL
Warehouse Catalog
8. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
The System
2 methods to creating Facts
Report Filter
Different methods for creating Page-by fields
9. 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
MSTR Connectivity Wizard
3 functions of Attribute Forms
Long-term (2 - 5 years)
ETL
10. Level of OLTP integration
Lookup Table structure of a completely denormalized schema
Minimal or none
Attribute Forms
Advantage of a completely denormalized schema
11. Homogeneous - Heterogeneous
Components of Compound Metrics
Long-term (2 - 5 years)
2 types of Facts
2 methods to creating Facts
12. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
ETL process
Aggregate a Metric
Page-by
Facts
13. All Attributes must have an _______.
Physical Schema
2-Tier Architecture
Project
ID form
14. Level of OLAP integration
Characteristics of Nested Metrics
Characteristics of a Simple Table Key
Very high; part of ETL process
File types are allowed for exporting a Report
15. 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.
Hierarchies
2-Tier Architecture
View Filters
Fact Expression
16. A user interface for creating and maintaining a BI environment
Project Source
MSTR Desktop
Facts
Compound Attribute
17. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Limitations of the Attribute Creation Wizard
Different methods for creating Page-by fields
2 types of Facts
Attribute Forms
18. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
ETL process
OLTP
Lookup Table structure of a moderately denormalized schema
View Filter
19. 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
4 parts of the Project Design Process
Simple Attribute Expression
Simple Metrics
Types of drilling
20. Attribute Creation Wizard - Attribute Editor
Lookup Tables
Methods are there to creating Attributes
Default Project folder structure
2 components of a Physical Schema
21. User requirements - Existing source data - Technical and performance considerations
Limitations of the Attribute Creation Wizard
3 Methods of MSTR Desktop navigation
Long-term (2 - 5 years)
Factors to consider when designing a logical data model
22. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Compound Attribute
2 types of Attribute Expression
3 Types of Objects in MSTR Desktop
Sample Metrics commonly performed on Facts
23. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
2 types of Fact Expressions
Components of a MSTR architecture
MSTR applications
Project Source
24. You can e-mail reports by going to _____
File > Email Reports As
Column Aliases
Logical Data Model
Report Filter operators
25. Columns - Tables
Attributes
Reference Report Objects
2 components of a Physical Schema
View Filter
26. Top menu/dropdowns - Toolbar - Right-click popup menus
Attribute Creation Wizard good for
Characteristics of Nested Metrics
3 Methods of MSTR Desktop navigation
File types are allowed for exporting a Report
27. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLAP
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Simple Table Key
Logical Data Model
28. OLTP data storage measure
Architect Graphical Interface
Facts
Long-term (2 - 5 years)
Gigabytes (GB)
29. Descriptive data that provides context for Facts.
Attribute Forms
The System
Characteristics of Nested Metrics
Source system characteristics
30. 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
View Filter
Advantage of a completely denormalized schema
MSTR Connectivity Wizard
To qualify a Metric in a Set Qualification
31. 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
ID form
4 basic Schema objects
MSTR applications
Characteristics of Nested Metrics
32. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Tasks when defining a User Hierarchy
2 types of Table Keys
Desktop Analyst
33. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Architect Graphical Interface
View Filters
Heterogeneous Attribute
34. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Logical Data Model
Hierarchies
4 factors to consider when designing a data-warehouse schema
To "drill down" on a report
35. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Different methods for creating Page-by fields
Types of analysis you can perform with OLAP Services
Report Template
36. Enables you to rearrange the columns and rows in a report.
3 Methods of MSTR Desktop navigation
2 types of Facts
Report Template
Data Pivoting
37. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Homogeneous Fact
3 column types of a Physical Schema
File > Email Reports As
38. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
File > Email Reports As
OLTP
The System
ETL process
39. OLAP Services does not add any ______ to the report query.
Application Objects
Derived Metrics
Schema Objects
New SQL
40. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Types of drilling
To save a Report Format
Report Prompts
Search Object
41. The Attribute Form maps to the same column name in multiple tables
Data warehouse characteristics
MSTR Desktop
Homogeneous Attribute
Desktop Analyst
42. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Compound Metric
5 steps to creating a logical data model
2 options for Sorting
Process for creating the Project Metadata
43. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Report Filter
User Hierarchies
Physical Schema
44. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Terabytes (TB)
To drill through User Hierarchies
Object Prompts
Outline Mode
45. The logical associations between attributes that exist based on a business rule
Shortcut Bar
Components of a Metric
Physical Schema
Attribute Relationships
46. Prompts to select a single value on which to qualify a date - number or text string.
Terabytes (TB)
Value Prompts
Search-based prompts
Default Project folder structure
47. 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
Derived Attribute Expression
Characteristics of Nested Metrics
4 types of Prompts
48. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Objects you are allowed to Page-by
MSTR applications
Object Prompts
3-Tier Architecture
49. A shortcut to an existing Object in a Project
Search-based prompts
Desktop Analyst
Shortcut in MSTR Desktop
3-Tier Architecture
50. Metrics you create within a report using only those objects in the report.
Source system characteristics
Derived Metrics
Sorting
Components of a MSTR architecture