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. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Fact Tables
Level Prompts
Value Prompts
2. It contains the ID column of the parent attribute
Sorting
To create the Project connectivity
Lookup Table structure of a completely normalized schema
Table Keys
3. Specifies a condition data must meet in order to be included in a report
Components of the Logical Data Model
Long-term (2 - 5 years)
Report Filter
3 Sections of the MSTR Desktop interface
4. You can e-mail reports by going to _____
Terabytes (TB)
Desktop Administrative Functions
Physical Schema
File > Email Reports As
5. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Process for creating the Project Metadata
Compound Attribute
4 parts of the Project Design Process
Level Prompts
6. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Schema Object Editor
4 tasks of the Attribute Creation Wizard
ETL
2 methods to creating Facts
7. Subtotals reflect accumulations at selected attribute levels
Subtotals
Thresholding
To edit the appearance of a Graph in a report
Factors to consider when designing a logical data model
8. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Shortcut Bar
Project Source
Report Filter operators
Limitations of the Attribute Creation Wizard
9. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Attribute Forms
Reports
View Filter
10. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Components of Compound Metrics
Level Prompts
2 options for Sorting
MSTR applications
11. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Components of Compound Metrics
Objects you are allowed to Page-by
Banding
Components of the Logical Data Model
12. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Attribute or its relationship(s)
Attribute Forms
2 options for Sorting
13. One that uses 2 or more columns as its ID
Compound Attribute
Attribute Forms
File > Email Reports As
Locking and Resizing
14. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Source system characteristics
Different methods for creating Page-by fields
Default Project folder structure
15. Groupings of directly related attributes. Also commonly known as "dimensions".
3 components of a Report
Hierarchies
Metrics
Advantage of a completely denormalized schema
16. Metrics you create within a report using only those objects in the report.
Derived Metrics
Lookup Table structure of a moderately denormalized schema
To edit the appearance of a Graph in a report
Shortcut Bar
17. Homogeneous - Heterogeneous
2 types of Facts
Architect Graphical Interface
Drilling
5 steps to creating a logical data model
18. A shortcut to an existing Object in a Project
Minimal or none
Shortcut in MSTR Desktop
Hierarchies
4 types of Prompts
19. Simple - Derived
Cannot create project objects
Types of analysis you can perform with OLAP Services
To "drill down" on a report
2 types of Attribute Expression
20. A method of organizing the appearance of report results in a Grid report based on a criteria
2 types of Fact Expressions
Banding
Derived Attribute Expression
Reference Report Objects
21. OLAP Services does not add any ______ to the report query.
Components of a MSTR architecture
Application Objects
New SQL
Factors to consider when designing a logical data model
22. Used to modify a Report
Types of analysis you can perform with OLAP Services
3 types of Attributes
Schema Objects
Report Editor
23. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Lookup Table structure of a completely normalized schema
Components of a Metric
The 3 MSTR Tools
24. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
The System
Types of analysis you can perform with OLAP Services
3 column types of a Physical Schema
3 Methods of MSTR Desktop navigation
25. OLTP retains data ________
Short-term (2 - 6 months)
Page-by
5 Report display views
2 types of Table Keys
26. OLAP retains data ________
OLTP
Long-term (2 - 5 years)
Components of a MSTR architecture
Compound Metric
27. Schema Objects - Application Objects - Configuration Objects
Reference Report Objects
Project-level options/settings
Components of Compound Metrics
3 Types of Objects in MSTR Desktop
28. Level of OLAP integration
Reference Report Objects
ETL process
Characteristics of Nested Metrics
Very high; part of ETL process
29. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
3 column types of a Physical Schema
Stored
ETL
Report Objects
30. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
View Filters
Terabytes (TB)
Project Creation Wizard
2 options for Sorting
31. Simple - Compound - Nested - Derived
4 types of Metrics
Metrics
3 functions of Attribute Forms
Very high; part of ETL process
32. Grid View - Graph View - Grid/Graph View - SQL View
File types are allowed for exporting a Report
2 types of Table Keys
Rollback your changes
Display views you can Print by
33. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Heterogeneous Attribute
2 types of Attribute Relationships
Schema
MSTR applications
34. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Search Object
Drilling
Default Project folder structure
35. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Aggregate a Metric
Report Filter operators
Attribute Relationships
36. The Attribute Form Expression that maps to a single column - no matter the number of tables
Report Filter
Attribute Creation Wizard good for
User Hierarchies
Simple Attribute Expression
37. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Lookup Table structure of a moderately denormalized schema
'View of a Report'
Desktop Designer
3 components of a Report
38. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Attributes
3 types of Attributes
Lookup Table structure of a completely normalized schema
39. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Schema
Characteristics of Nested Metrics
2 types of Attribute Relationships
2 methods to creating Facts
40. What tool do you use to create the Metadata shell?
Project
Configuration Wizard
Compound Metric
Factors to consider when designing a logical data model
41. Creating multiple attributes quickly. Used during the initial project creation.
MSTR Connectivity Wizard
Homogeneous Fact
Attribute Creation Wizard good for
Architect Graphical Interface
42. Level of OLTP integration
To qualify a Metric in a Set Qualification
Derived Attribute Expression
Minimal or none
Project
43. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Compound Metric
Project
3 types of Attributes
44. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
4 factors to consider when designing a data-warehouse schema
To create the Project connectivity
Attribute Forms
45. Compound - Homogeneous - Heterogeneous
The System
3 functions of Attribute Forms
3 types of Attributes
4 basic Schema objects
46. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Value Prompts
View Filter
Types of drilling
Short-term (2 - 6 months)
47. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
Aggregate a Metric
Reports
Display views you can Print by
48. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Facts
Shortcut Bar
Methods are there to creating Attributes
Column Aliases
49. How users can share comments for reports to other users
Notes
Data warehouse characteristics
MSTR OLAP Services
Types of analysis you can perform with OLAP Services
50. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Subtotals
Physical Schema
Report Filter operators
Advantage of a completely denormalized schema