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. Facts - Attributes - Hierarchies
By default
Components of the Logical Data Model
Characteristics of a Compound Table Key
2 ways you can configure the Project Source to connect to the Metadata database
2. Homogeneous - Heterogeneous
Stored
MSTR Desktop
Project
2 types of Facts
3. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Tasks when defining a User Hierarchy
Facts
OLTP
3 column types of a Physical Schema
4. Must have a one-to-one relationship with all other forms.
Compound Metric
4 parts of the Project Design Process
Unlimited
Attribute Forms
5. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Logical Data Model
Lookup Table structure of a completely denormalized schema
MSTR OLAP Services
Required on the report for Outline Model to work
6. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
'View of a Report'
Unlimited
Desktop Administrative Functions
4 parts of the Project Design Process
7. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To edit the appearance of a Graph in a report
Schema
Types of analysis you can perform with OLAP Services
Desktop Designer
8. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
OLTP
MSTR Desktop
Tasks when defining a User Hierarchy
Reports
9. The actual column name for a fact. Every fact must have at least 1 expression.
5 Report display views
Fact Expression
3-Tier Architecture
Report Filter
10. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
The 3 MSTR Tools
2-Tier Architecture
Desktop Analyst
Tasks when defining a User Hierarchy
11. Attribute Creation Wizard - Attribute Editor
Outline Mode
Methods are there to creating Attributes
Warehouse Catalog
2 types of Facts
12. Metrics you create within a report using only those objects in the report.
Project Source
To edit the appearance of a Graph in a report
Derived Metrics
Desktop Architec
13. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
MSTR OLAP Services
Search-based prompts
Filter Definition Prompts
Characteristics of Nested Metrics
14. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
4 types of Report Filters
Outline Mode
ETL
15. What tool do you use to create the Metadata shell?
2 options for Sorting
3-Tier Architecture
Configuration Wizard
Project-level options/settings
16. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Project
Search-based prompts
OLAP
17. OLAP Services does not add any ______ to the report query.
To save a Report Format
New SQL
Report Filter
Object Prompts
18. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
4 types of Metrics
3-Tier Architecture
Schema Object Editor
19. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
4 types of Prompts
Desktop Analyst
Notes
20. One that uses 2 or more columns as its ID
Compound Attribute
Architect Graphical Interface
3 Sections of the MSTR Desktop interface
MSTR Desktop
21. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
File > Email Reports As
Process for creating the Project Metadata
User Hierarchies
22. Subtotals reflect accumulations at selected attribute levels
Project Creation Wizard
Subtotals
Attribute Creation Wizard good for
Project
23. Used to modify a Report
2 types of Fact Expressions
Report Editor
Fact Tables
Report Filter
24. Columns - Tables
2 components of a Physical Schema
Long-term (2 - 5 years)
4 basic Schema objects
2 types of Attribute Expression
25. The unique values of an attribute obtained from the data-warehouse
Components of a Derived Metric
Lookup Table structure of a completely normalized schema
Homogeneous Attribute
Attribute Elements
26. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
To create the Project connectivity
Lookup Table structure of a moderately denormalized schema
3 column types of a Physical Schema
27. 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
Objects you are allowed to Page-by
File types are allowed for exporting a Report
3 column types of a Physical Schema
28. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Search-based prompts
Compound Metric
Homogeneous Fact
29. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Terabytes (TB)
Physical Schema
OLAP
2 types of Attribute Relationships
30. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Facts
Fact Tables
ETL
31. User reporting requirements - Query performance - Data volume - DB Maintenance
Tasks when defining a User Hierarchy
2 components of a Physical Schema
4 factors to consider when designing a data-warehouse schema
Advantage of a completely denormalized schema
32. OLTP data storage measure
Gigabytes (GB)
Desktop Architec
Level Prompts
Data Pivoting
33. View Filters are saved with the _____________.
Relationship Tables
Report Definitions
Column Aliases
To create the Project connectivity
34. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Thresholding
2 options for Sorting
3-Tier Architecture
Project-level options/settings
35. 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
Aggregate a Metric
4 types of Report Filters
To create a Report Prompt
Banding
36. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
OLTP
The 3 MSTR Tools
Warehouse Catalog
Lookup Tables
37. Enables you to rearrange the columns and rows in a report.
Report Formatting
Lookup Table structure of a completely normalized schema
Drilling
Data Pivoting
38. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Lookup Table structure of a moderately denormalized schema
MSTR applications
OLAP
File > Email Reports As
39. OLAP data storage measure
Schema Objects
MSTR OLAP Services
Terabytes (TB)
Derived Metrics
40. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
3 project creation interfaces
Outline Mode
Factors to consider when designing a logical data model
Components of a Metric
41. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
2 types of Attribute Relationships
Report Prompts
Lookup Table structure of a completely normalized schema
42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Homogeneous Attribute
3 Methods of MSTR Desktop navigation
MSTR applications
OLTP
43. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
ID form
'View of a Report'
To "drill down" on a report
44. It contains links to specific folders in the Folder List
Schema Objects
Project
Metrics
Shortcut Bar
45. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Fact Expression
Report Objects
Report Filter
46. Specifies what info to retrieve from a data-warehouse - and how to display it
By default
Attribute Elements
Report Template
Components of the Logical Data Model
47. What tool do you use to create the Metadata DSN connection?
Level Prompts
Components of the Logical Data Model
MSTR Connectivity Wizard
Attribute Forms
48. The default entry-points.
2 types of Attribute Relationships
3 Sections of the MSTR Desktop interface
Highest-level attributes
File > Email Reports As
49. You must select "Other directions" when drilling attributes while viewing a report
Simple Attribute Expression
Lookup Table structure of a moderately denormalized schema
To drill through User Hierarchies
Warehouse Catalog
50. Prompts to select a single value on which to qualify a date - number or text string.
Limitations of the Attribute Creation Wizard
Simple Attribute Expression
Fact Tables
Value Prompts