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. Subtotals reflect accumulations at selected attribute levels
2 types of Fact Expressions
Hierarchies
Subtotals
Types of drilling
2. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Physical Schema
Attribute Forms
Source system characteristics
Unlimited
3. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Level Prompts
Facts
4 types of Prompts
4. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Report Objects
Very high; part of ETL process
Desktop Analyst
Components of Compound Metrics
5. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Schema
Physical Schema
Application Objects
6. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Attribute or its relationship(s)
ETL process
Desktop Architec
7. Specifies a condition data must meet in order to be included in a report
Attribute Forms
2 ways you can configure the Project Source to connect to the Metadata database
Report Filter
4 basic Schema objects
8. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Data Pivoting
Terabytes (TB)
3-Tier Architecture
Facts
9. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
Homogeneous Fact
Simple Metrics
Limitations of the Attribute Creation Wizard
10. A user interface for creating and maintaining a BI environment
Stored
MSTR Desktop
Types of drilling
3-Tier Architecture
11. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Schema
Derived Attribute Expression
Methods are there to creating Attributes
12. OLAP data storage measure
2 ways you can configure the Project Source to connect to the Metadata database
Terabytes (TB)
Desktop Architec
Report Formatting
13. The logical associations between attributes that exist based on a business rule
Components of the Logical Data Model
Application Objects
ID form
Attribute Relationships
14. Filter definition prompts - Object prompts - Value prompts - Level prompts
File types are allowed for exporting a Report
4 types of Prompts
Report Definitions
Components of a MSTR architecture
15. User reporting requirements - Query performance - Data volume - DB Maintenance
Components of a Metric
Hierarchies
Homogeneous Attribute
4 factors to consider when designing a data-warehouse schema
16. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Shortcut in MSTR Desktop
Physical Schema
Different methods for creating Page-by fields
Characteristics of a Compound Table Key
17. Extraction - transformation - loading
Rollback your changes
ETL
To create a Report Prompt
Object Prompts
18. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
ETL process
Column Aliases
3 Methods of MSTR Desktop navigation
19. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Highest-level attributes
Lookup Table structure of a completely normalized schema
Report Prompts
Types of drilling
20. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Compound Metric
Simple Metrics
Derived Attribute Expression
Lookup Table structure of a completely denormalized schema
21. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Value Prompts
Gigabytes (GB)
Compound Metric
22. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
The System
Desktop Analyst
Attribute Forms
Attribute Elements
23. Create the Project Source - Create the Database Instance
Components of a Metric
To create the Project connectivity
Report Prompts
Default Project folder structure
24. Facts associated to different column names in 2 or more tables
Search Object
To create the Project connectivity
Metrics
Heterogeneous Fact
25. 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
The System
Fact Tables
Logical Data Model
Types of drilling
26. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Sorting
To create the Project connectivity
Facts
Desktop Analyst
27. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
View Filters
Shortcut in MSTR Desktop
Data warehouse characteristics
28. Creating multiple attributes quickly. Used during the initial project creation.
Using a Search Object
Facts
Desktop Architec
Attribute Creation Wizard good for
29. Facts - Attributes - Hierarchies
Source system characteristics
Types of drilling
Components of the Logical Data Model
Shortcut in MSTR Desktop
30. 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
Shortcut in MSTR Desktop
4 types of Report Filters
Objects you are allowed to Page-by
Drilling
31. Metrics aggregate on the lowest-level attribute __________.
2 types of Attribute Relationships
4 parts of the Project Design Process
Architect Graphical Interface
By default
32. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Hierarchies
Project Source
Schema Objects
4 types of Report Filters
33. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
ETL process
Warehouse Catalog
Lookup Tables
Project Creation Wizard
34. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Schema
Table Keys
Types of analysis you can perform with OLAP Services
Required on the report for Outline Model to work
35. 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
Schema
Tasks when defining a User Hierarchy
2 options for Sorting
MSTR Desktop
36. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Application Objects
To drill through User Hierarchies
MSTR Desktop Architect
37. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Schema Objects
ID form
2 ways you can configure the Project Source to connect to the Metadata database
38. View Filters are saved with the _____________.
Report Definitions
Types of analysis you can perform with OLAP Services
Characteristics of a Compound Table Key
Search Object
39. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
4 basic Schema objects
2 types of Fact Expressions
4 tasks of the Attribute Creation Wizard
Objects you are allowed to Page-by
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
Logical Data Model
File types are allowed for exporting a Report
3 Schema types
Advantage of a completely denormalized schema
41. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
4 types of Report Filters
By default
Schema Object Editor
42. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
View Filters
Table Keys
Report Objects
Search Object
43. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Project-level options/settings
Types of analysis you can perform with OLAP Services
Warehouse Catalog
Data warehouse characteristics
44. Template - Filter - View of a Report
3 column types of a Physical Schema
3 components of a Report
Compound Attribute
Report Definitions
45. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
2 types of Table Keys
Homogeneous Attribute
MSTR OLAP Services
46. To see data at completely different levels - other than that of the original Grid or Graph
Types of drilling
Column Aliases
Drilling
2 types of Attribute Expression
47. View Filters can only ___________.
Reference Report Objects
Simple Metrics
Architect Graphical Interface
Different methods for creating Page-by fields
48. OLTP data storage measure
Gigabytes (GB)
Search Object
5 Report display views
Long-term (2 - 5 years)
49. Homogeneous - Heterogeneous
2 types of Facts
Reports
To qualify a Metric in a Set Qualification
Value Prompts
50. Descriptive data that provides context for Facts.
Relationship Tables
Filter Definition Prompts
Attribute Forms
Lookup Table structure of a completely normalized schema