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. A development environment to create BI applications - allowing users to edit the Metadata database
Attribute Relationships
Desktop Architec
Components of a Metric
View Filter
2. Reduced number of JOINS in the generated SQL
3 project creation interfaces
Compound Metric
Advantage of a completely denormalized schema
Desktop Designer
3. The Attribute Form maps to different column names in multiple tables
Locking and Resizing
Desktop Architec
2-Tier Architecture
Heterogeneous Attribute
4. AND - OR - OR NOT - AND NOT
2 types of Fact Expressions
Characteristics of Nested Metrics
3 Methods of MSTR Desktop navigation
Report Filter operators
5. Simple - Derived
2 types of Attribute Expression
Report Filter operators
3 Types of Objects in MSTR Desktop
Drilling
6. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
2 types of Table Keys
Physical Schema
The 3 MSTR Tools
Report Definitions
7. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Terabytes (TB)
Desktop Designer
Fact Expression
8. What tool do you use to create the Metadata DSN connection?
View Filter
Attribute Creation Wizard good for
Subtotals
MSTR Connectivity Wizard
9. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Search-based prompts
File > Email Reports As
3 Types of Objects in MSTR Desktop
10. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
View Filters
Filter Definition Prompts
Report Filter
11. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
ETL
Process for creating the Project Metadata
3-Tier Architecture
ETL process
12. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Highest-level attributes
Components of Compound Metrics
Object Prompts
Table Keys
13. How users can share comments for reports to other users
4 basic Schema objects
Cannot create project objects
Minimal or none
Notes
14. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Attribute Creation Wizard good for
4 factors to consider when designing a data-warehouse schema
Report Filter
Schema
15. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Lookup Tables
3 project creation interfaces
4 types of Prompts
MSTR Desktop
16. 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
Schema Object Editor
Long-term (2 - 5 years)
3 Methods of MSTR Desktop navigation
3 Schema types
17. All report-level options overwrite ___________.
Facts
Objects you are allowed to Page-by
Filter Definition Prompts
Project-level options/settings
18. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Simple Metrics
Relationship Tables
Types of analysis you can perform with OLAP Services
3 components of a Report
19. Enables you to select and display subsets of a report as separate pages.
Page-by
Objects you are allowed to Page-by
Factors to consider when designing a logical data model
The System
20. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Limitations of the Attribute Creation Wizard
To qualify a Metric in a Set Qualification
3 components of a Report
Terabytes (TB)
21. OLAP Services does not add any ______ to the report query.
Components of a MSTR architecture
View Filters
2-Tier Architecture
New SQL
22. 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.
Fact Tables
Types of drilling
View Filters
Architect Graphical Interface
23. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Stored
Desktop Designer
Display views you can Print by
24. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
4 properties you must know in order to create attributes using the Attribute Editor
The System
Types of drilling
Process for creating the Project Metadata
25. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Factors to consider when designing a logical data model
Rollback your changes
Derived Attribute Expression
Heterogeneous Fact
26. A shortcut to an existing Object in a Project
Components of Compound Metrics
Project Creation Wizard
5 steps to creating a logical data model
Shortcut in MSTR Desktop
27. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Components of the Logical Data Model
The 3 MSTR Tools
Lookup Tables
28. OLTP data storage measure
Gigabytes (GB)
MSTR OLAP Services
Column Aliases
2 types of Facts
29. One that uses 2 or more columns as its ID
Compound Attribute
Locking and Resizing
5 Report display views
Report Filter operators
30. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
4 basic Schema objects
User Hierarchies
File types are allowed for exporting a Report
Components of a MSTR architecture
31. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Schema
Outline Mode
MSTR OLAP Services
32. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Table Keys
Required on the report for Outline Model to work
Drilling
Architect Graphical Interface
33. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Simple Metrics
Facts
Project Creation Wizard
Tasks when defining a User Hierarchy
34. Descriptive data that provides context for Facts.
Attribute Forms
Report Editor
Search Object
MSTR Desktop
35. Enables you to rearrange the columns and rows in a report.
5 steps to creating a logical data model
2 methods to creating Facts
Data Pivoting
MSTR Connectivity Wizard
36. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
To drill through User Hierarchies
Terabytes (TB)
ETL
37. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3-Tier Architecture
5 steps to creating a logical data model
'View of a Report'
ETL process
38. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
To edit the appearance of a Graph in a report
Compound Metric
Aggregate a Metric
Objects you are allowed to Page-by
39. 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 project creation interfaces
Components of a Derived Metric
Components of a MSTR architecture
Different methods for creating Page-by fields
40. OLTP retains data ________
5 steps to creating a logical data model
Sample Metrics commonly performed on Facts
Short-term (2 - 6 months)
By default
41. The actual column name for a fact. Every fact must have at least 1 expression.
Banding
Fact Expression
Compound Metric
Sorting
42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLAP
OLTP
Project-level options/settings
Objects you are allowed to Page-by
43. Must have a one-to-one relationship with all other forms.
Attribute Forms
Shortcut Bar
Schema Object Editor
Types of drilling
44. 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
Using a Search Object
Architect Graphical Interface
Simple Attribute Expression
Logical Data Model
45. Create the Project Source - Create the Database Instance
Lookup Table structure of a moderately denormalized schema
Schema Object Editor
To create the Project connectivity
2 options for Sorting
46. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Banding
Source system characteristics
Types of analysis you can perform with OLAP Services
Report Prompts
47. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
To qualify a Metric in a Set Qualification
Attribute Forms
Relationship Tables
48. Extraction - transformation - loading
3 column types of a Physical Schema
2 types of Fact Expressions
Schema
ETL
49. Metrics aggregate on the lowest-level attribute __________.
Project Source
Nested Metrics
By default
Cannot create project objects
50. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Facts
Sorting
Tasks when defining a User Hierarchy
4 parts of the Project Design Process