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. Level of OLAP integration
Factors to consider when designing a logical data model
Very high; part of ETL process
Attribute Creation Wizard good for
Compound Attribute
2. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
4 types of Metrics
Sample Metrics commonly performed on Facts
2 options for Sorting
ETL
3. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
To qualify a Metric in a Set Qualification
Project
Attribute Forms
Stored
4. Less storage - Simple SQL - Complex ETL
Lookup Tables
Schema Objects
To "drill down" on a report
Characteristics of a Simple Table Key
5. Level of OLTP integration
Project-level options/settings
Project Source
Reference Report Objects
Minimal or none
6. Compound - Homogeneous - Heterogeneous
Attribute Elements
3 types of Attributes
Tasks when defining a User Hierarchy
Shortcut Bar
7. To see data at completely different levels - other than that of the original Grid or Graph
Facts
Search-based prompts
Drilling
2 types of Facts
8. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
To drill through User Hierarchies
Methods are there to creating Attributes
5 steps to creating a logical data model
Hierarchies
9. View Filters can only ___________.
MSTR Desktop
Reference Report Objects
Hierarchies
3 Methods of MSTR Desktop navigation
10. Extraction - transformation - loading
Highest-level attributes
ETL
Facts
Components of a Derived Metric
11. Subtotals reflect accumulations at selected attribute levels
Subtotals
Table Keys
MSTR applications
Gigabytes (GB)
12. 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
Report Formatting
Subtotals
4 types of Report Filters
Characteristics of a Compound Table Key
13. Homogeneous - Heterogeneous
2 types of Facts
Project-level options/settings
Sorting
Short-term (2 - 6 months)
14. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
MSTR OLAP Services
Desktop Analyst
Banding
Characteristics of a Simple Table Key
15. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Methods are there to creating Attributes
File types are allowed for exporting a Report
Metrics
4 types of Metrics
16. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
ETL process
4 types of Metrics
2 types of Attribute Expression
17. Grid View - Graph View - Grid/Graph View - SQL View
Filter Definition Prompts
Display views you can Print by
Value Prompts
Different methods for creating Page-by fields
18. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Report Filters
4 types of Prompts
Required on the report for Outline Model to work
3-Tier Architecture
19. A feature that enables users to delivers reports to the history list - cache or mobile
Report Formatting
Components of Compound Metrics
To drill through User Hierarchies
Report Subscription
20. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Heterogeneous Attribute
2 types of Attribute Relationships
2-Tier Architecture
Outline Mode
21. It contains the ID column of all higher-level attributes
Data Pivoting
2 ways you can configure the Project Source to connect to the Metadata database
Using a Search Object
Lookup Table structure of a moderately denormalized schema
22. The Attribute Form maps to the same column name in multiple tables
Factors to consider when designing a logical data model
4 types of Report Filters
Homogeneous Attribute
Characteristics of a Simple Table Key
23. ID columns - Description columns - Fact columns
2 types of Table Keys
Lookup Table structure of a completely normalized schema
Value Prompts
3 column types of a Physical Schema
24. 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
Attribute Forms
Hierarchies
MSTR OLAP Services
25. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Project
Simple Metrics
Metrics
To drill through User Hierarchies
26. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Simple Metrics
Components of a MSTR architecture
Attribute or its relationship(s)
4 properties you must know in order to create attributes using the Attribute Editor
27. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
'View of a Report'
Derived Attribute Expression
Report Prompts
5 Report display views
28. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Derived Metrics
File > Email Reports As
Physical Schema
29. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Methods are there to creating Attributes
Required on the report for Outline Model to work
OLAP
Sample Metrics commonly performed on Facts
30. 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
Attribute Forms
Characteristics of Nested Metrics
2 types of Attribute Expression
Attribute Forms
31. Used to modify a Report
4 parts of the Project Design Process
Facts
MSTR Connectivity Wizard
Report Editor
32. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Physical Schema
Table Keys
Thresholding
To drill through User Hierarchies
33. 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
MSTR Connectivity Wizard
Shortcut in MSTR Desktop
To qualify a Metric in a Set Qualification
Page-by
34. Using the Prompt Generation Wizard - Inside the Report Editor
Data warehouse characteristics
To create a Report Prompt
2 options for Sorting
Desktop Architec
35. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Column Aliases
Different methods for creating Page-by fields
Data warehouse characteristics
5 steps to creating a logical data model
36. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Characteristics of a Simple Table Key
Report Formatting
MSTR Desktop Architect
The System
37. User requirements - Existing source data - Technical and performance considerations
4 types of Report Filters
Characteristics of Nested Metrics
Factors to consider when designing a logical data model
Report Filter operators
38. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Lookup Tables
3 Sections of the MSTR Desktop interface
To "drill down" on a report
Source system characteristics
39. The Attribute Form maps to different column names in multiple tables
Methods are there to creating Attributes
Lookup Table structure of a completely normalized schema
Lookup Table structure of a completely denormalized schema
Heterogeneous Attribute
40. 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
Types of analysis you can perform with OLAP Services
4 basic Schema objects
To "drill down" on a report
41. Specifies a condition data must meet in order to be included in a report
Report Filter
Lookup Table structure of a moderately denormalized schema
3 functions of Attribute Forms
Attribute Relationships
42. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
4 parts of the Project Design Process
To qualify a Metric in a Set Qualification
Level Prompts
43. 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
Banding
Logical Data Model
Methods are there to creating Attributes
Facts
44. 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.
MSTR OLAP Services
To create the Project connectivity
View Filters
Attribute Elements
45. Enables you to lock column headers so that they always appear when scrolling
Nested Metrics
Locking and Resizing
Highest-level attributes
2 ways you can configure the Project Source to connect to the Metadata database
46. Metrics aggregate on the lowest-level attribute __________.
Factors to consider when designing a logical data model
Shortcut Bar
By default
The 3 MSTR Tools
47. Reduced number of JOINS in the generated SQL
Sorting
ID form
Advantage of a completely denormalized schema
3-Tier Architecture
48. Create the Project Source - Create the Database Instance
OLTP
Report Template
The 3 MSTR Tools
To create the Project connectivity
49. Template - Filter - View of a Report
3 components of a Report
Required on the report for Outline Model to work
Project-level options/settings
Report Objects
50. Columns - Tables
Attributes
Notes
Tasks when defining a User Hierarchy
2 components of a Physical Schema