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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
File types are allowed for exporting a Report
3 functions of Attribute Forms
ETL process
2. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Advantage of a completely denormalized schema
Nested Metrics
Required on the report for Outline Model to work
Schema Object Editor
3. A new tool for project design tasks - used for fine-tuning a project after initial creation
Reports
Report Formatting
Architect Graphical Interface
OLAP
4. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Default Project folder structure
3 types of Attributes
Display views you can Print by
5. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Attribute or its relationship(s)
2 methods to creating Facts
4 parts of the Project Design Process
Outline Mode
6. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Sample Metrics commonly performed on Facts
Objects you are allowed to Page-by
2 types of Attribute Relationships
2 methods to creating Facts
7. OLAP Services does not add any ______ to the report query.
To "drill down" on a report
Desktop Analyst
Reports
New SQL
8. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
2 methods to creating Facts
Attribute Forms
Lookup Table structure of a completely normalized schema
Simple Metrics
9. The actual column name for a fact. Every fact must have at least 1 expression.
Metrics
Application Objects
3 Sections of the MSTR Desktop interface
Fact Expression
10. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Fact Expression
Very high; part of ETL process
Objects you are allowed to Page-by
The System
11. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
4 types of Prompts
2 options for Sorting
Fact Expression
12. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Derived Metrics
To drill through User Hierarchies
Types of drilling
To save a Report Format
13. The Attribute Form maps to the same column name in multiple tables
Using a Search Object
Desktop Analyst
Homogeneous Attribute
3 types of Attributes
14. Template - Filter - View of a Report
4 factors to consider when designing a data-warehouse schema
Lookup Tables
Shortcut in MSTR Desktop
3 components of a Report
15. Homogeneous - Heterogeneous
Attribute Relationships
2 types of Facts
Schema
Hierarchies
16. Simple - Compound - Nested - Derived
2 components of a Physical Schema
2-Tier Architecture
4 types of Metrics
Relationship Tables
17. The logical associations between attributes that exist based on a business rule
Search Object
MSTR OLAP Services
2 types of Attribute Relationships
Attribute Relationships
18. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Simple Metrics
MSTR Connectivity Wizard
Types of drilling
19. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
Characteristics of a Simple Table Key
ETL
Lookup Tables
20. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
Column Aliases
2 options for Sorting
Table Keys
21. Metrics aggregate on the lowest-level attribute __________.
Report Template
Thresholding
Desktop Architec
By default
22. You can e-mail reports by going to _____
File > Email Reports As
Report Template
File types are allowed for exporting a Report
Shortcut Bar
23. 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
File > Email Reports As
3 Schema types
Attribute Elements
Tasks when defining a User Hierarchy
24. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Architect Graphical Interface
Fact Tables
Factors to consider when designing a logical data model
Reports
25. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
'View of a Report'
Process for creating the Project Metadata
Reports
26. The default entry-points.
Project-level options/settings
3 Types of Objects in MSTR Desktop
Gigabytes (GB)
Highest-level attributes
27. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Stored
Column Aliases
Facts
28. 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 Definitions
Table Keys
Tasks when defining a User Hierarchy
29. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
Outline Mode
Warehouse Catalog
3 Schema types
30. Columns - Tables
To drill through User Hierarchies
Long-term (2 - 5 years)
2 components of a Physical Schema
Architect Graphical Interface
31. 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
4 properties you must know in order to create attributes using the Attribute Editor
Simple Metrics
OLTP
To qualify a Metric in a Set Qualification
32. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Application Objects
Heterogeneous Fact
Cannot create project objects
33. The Attribute Form maps to different column names in multiple tables
MSTR Desktop Architect
Heterogeneous Attribute
3 functions of Attribute Forms
Report Editor
34. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Search-based prompts
3 Sections of the MSTR Desktop interface
2 types of Attribute Relationships
35. To see data at completely different levels - other than that of the original Grid or Graph
Advantage of a completely denormalized schema
To edit the appearance of a Graph in a report
OLTP
Drilling
36. How users can share comments for reports to other users
Components of Compound Metrics
Schema Objects
OLAP
Notes
37. Used to "fine-tune" your Project
Architect Graphical Interface
2 types of Attribute Relationships
OLTP
Thresholding
38. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
Value Prompts
Schema Object Editor
Factors to consider when designing a logical data model
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)
Derived Attribute Expression
4 parts of the Project Design Process
Components of Compound Metrics
OLAP
40. You can _____________ in the Architect Graphical Interface.
The 3 MSTR Tools
Rollback your changes
Attribute Elements
Report Definitions
41. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Project Creation Wizard
To create a Report Prompt
MSTR OLAP Services
4 properties you must know in order to create attributes using the Attribute Editor
42. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
MSTR applications
Source system characteristics
2 types of Fact Expressions
Data Pivoting
43. OLTP retains data ________
Components of a Derived Metric
Sample Metrics commonly performed on Facts
Short-term (2 - 6 months)
Project
44. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
File types are allowed for exporting a Report
Column Aliases
Characteristics of a Compound Table Key
Stored
45. A condition data must meet in order to be included in a report. Does affect the SQL.
Lookup Tables
Search Object
Report Filter
Notes
46. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
3 Schema types
Architect Graphical Interface
Desktop Architec
47. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
OLAP
Attribute or its relationship(s)
Value Prompts
5 Report display views
48. 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.
Project Creation Wizard
User Hierarchies
Methods are there to creating Attributes
Thresholding
49. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Schema Object Editor
Unlimited
Project Creation Wizard
View Filters
50. Groupings of directly related attributes. Also commonly known as "dimensions".
Lookup Table structure of a completely denormalized schema
Hierarchies
MSTR OLAP Services
Search-based prompts