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. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Terabytes (TB)
Report Filter
Components of the Logical Data Model
2. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
To create a Report Prompt
2 types of Attribute Relationships
Lookup Table structure of a moderately denormalized schema
MSTR OLAP Services
3. Simple - Derived
File > Email Reports As
File types are allowed for exporting a Report
2 types of Attribute Expression
Compound Metric
4. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Components of a Derived Metric
2 options for Sorting
Different methods for creating Page-by fields
Reference Report Objects
5. Specifies a condition data must meet in order to be included in a report
Table Keys
2 ways you can configure the Project Source to connect to the Metadata database
View Filter
Report Filter
6. View Filters are saved with the _____________.
2 types of Facts
OLAP
Report Definitions
2 types of Table Keys
7. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Object Prompts
Sample Metrics commonly performed on Facts
Facts
3 functions of Attribute Forms
8. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Column Aliases
The System
Fact Tables
The 3 MSTR Tools
9. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Advantage of a completely denormalized schema
2 types of Facts
Relationship Tables
4 properties you must know in order to create attributes using the Attribute Editor
10. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
4 factors to consider when designing a data-warehouse schema
View Filter
Project
2 ways you can configure the Project Source to connect to the Metadata database
11. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
4 tasks of the Attribute Creation Wizard
The System
3 functions of Attribute Forms
Facts
12. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Banding
Data warehouse characteristics
Characteristics of a Compound Table Key
3 functions of Attribute Forms
13. Used to modify a Report
Report Editor
Report Filter operators
Locking and Resizing
Search-based prompts
14. What tool do you use to create the Metadata DSN connection?
Lookup Table structure of a completely denormalized schema
MSTR Connectivity Wizard
Highest-level attributes
Gigabytes (GB)
15. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
3 column types of a Physical Schema
Schema Object Editor
Advantage of a completely denormalized schema
Metrics
16. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Methods are there to creating Attributes
3 Sections of the MSTR Desktop interface
Column Aliases
The System
17. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Fact Expression
Desktop Analyst
New SQL
18. Enables you to select and display subsets of a report as separate pages.
2 types of Attribute Relationships
Page-by
Desktop Designer
2-Tier Architecture
19. The default entry-points.
The System
Compound Metric
Object Prompts
Highest-level attributes
20. A new tool for project design tasks - used for fine-tuning a project after initial creation
OLAP
Architect Graphical Interface
2 types of Facts
4 basic Schema objects
21. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
To drill through User Hierarchies
Tasks when defining a User Hierarchy
Objects you are allowed to Page-by
Desktop Analyst
22. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Display views you can Print by
Report Formatting
Value Prompts
Attribute or its relationship(s)
23. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 options for Sorting
4 tasks of the Attribute Creation Wizard
Required on the report for Outline Model to work
2 types of Table Keys
24. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
3 components of a Report
Long-term (2 - 5 years)
Homogeneous Fact
25. AND - OR - OR NOT - AND NOT
2 ways you can configure the Project Source to connect to the Metadata database
Reference Report Objects
Highest-level attributes
Report Filter operators
26. User reporting requirements - Query performance - Data volume - DB Maintenance
Lookup Tables
4 factors to consider when designing a data-warehouse schema
Table Keys
Components of a Derived Metric
27. More storage - Complex SQL - Simple ETL
Facts
Lookup Table structure of a moderately denormalized schema
Aggregate a Metric
Characteristics of a Compound Table Key
28. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Schema
Attribute Creation Wizard good for
Display views you can Print by
29. OLTP data storage measure
Filter Definition Prompts
3 Methods of MSTR Desktop navigation
Gigabytes (GB)
Different methods for creating Page-by fields
30. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Attribute Forms
3 project creation interfaces
Warehouse Catalog
Lookup Table structure of a completely normalized schema
31. The Attribute Form maps to different column names in multiple tables
Level Prompts
Heterogeneous Attribute
4 basic Schema objects
Reports
32. Columns - Tables
Different methods for creating Page-by fields
Search-based prompts
2 types of Table Keys
2 components of a Physical Schema
33. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
'View of a Report'
Sorting
Compound Metric
34. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
4 basic Schema objects
2 components of a Physical Schema
3-Tier Architecture
Components of a Derived Metric
35. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
5 steps to creating a logical data model
Compound Metric
Desktop Architec
36. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Report Filter
Sample Metrics commonly performed on Facts
3 components of a Report
37. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
2 components of a Physical Schema
Report Definitions
Desktop Designer
Outline Mode
38. A condition data must meet in order to be included in a report. Does affect the SQL.
Level Prompts
2 methods to creating Facts
Project Creation Wizard
Report Filter
39. Level of OLTP integration
Facts
4 types of Report Filters
3 types of Attributes
Minimal or none
40. Groupings of directly related attributes. Also commonly known as "dimensions".
Report Objects
The 3 MSTR Tools
Cannot create project objects
Hierarchies
41. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
To qualify a Metric in a Set Qualification
Attribute Elements
Shortcut in MSTR Desktop
42. Facts associated to different column names in 2 or more tables
Facts
Heterogeneous Fact
Thresholding
Simple Attribute Expression
43. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Report Filter operators
4 parts of the Project Design Process
Components of a Derived Metric
Search Object
44. Specifies what info to retrieve from a data-warehouse - and how to display it
Required on the report for Outline Model to work
Components of a Derived Metric
MSTR OLAP Services
Report Template
45. 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
Schema Object Editor
Logical Data Model
4 factors to consider when designing a data-warehouse schema
2-Tier Architecture
46. Homogeneous - Heterogeneous
Required on the report for Outline Model to work
2 types of Facts
2 types of Attribute Relationships
Report Filter
47. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
3 column types of a Physical Schema
Characteristics of Nested Metrics
Using a Search Object
Different methods for creating Page-by fields
48. The Attribute Form maps to the same column name in multiple tables
Terabytes (TB)
Configuration Wizard
Homogeneous Attribute
Components of a MSTR architecture
49. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
4 tasks of the Attribute Creation Wizard
Search Object
Report Template
50. An environment in which the MSTR Desktop connects directly to the Metadata database.
Column Aliases
2-Tier Architecture
Facts
3 Types of Objects in MSTR Desktop