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 shortcut to an existing Object in a Project
MSTR Connectivity Wizard
3-Tier Architecture
To "drill down" on a report
Shortcut in MSTR Desktop
2. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Compound Metric
View Filter
Search Object
Unlimited
3. 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
2 options for Sorting
Tasks when defining a User Hierarchy
2 types of Fact Expressions
By default
4. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Components of the Logical Data Model
4 properties you must know in order to create attributes using the Attribute Editor
Physical Schema
Report Subscription
5. 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
Report Filter
3 Schema types
Attributes
Report Template
6. Used for - Initially populating the Metadata - Creating schema objects
Warehouse Catalog
MSTR Desktop Architect
Desktop Designer
Lookup Tables
7. OLAP retains data ________
Long-term (2 - 5 years)
MSTR applications
5 steps to creating a logical data model
Data warehouse characteristics
8. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
To edit the appearance of a Graph in a report
To qualify a Metric in a Set Qualification
2 options for Sorting
9. OLAP data storage measure
5 Report display views
Terabytes (TB)
3-Tier Architecture
5 steps to creating a logical data model
10. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Lookup Table structure of a moderately denormalized schema
Level Prompts
User Hierarchies
Relationship Tables
11. It contains links to specific folders in the Folder List
Source system characteristics
Sample Metrics commonly performed on Facts
Short-term (2 - 6 months)
Shortcut Bar
12. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
Architect Graphical Interface
Banding
3 functions of Attribute Forms
Lookup Table structure of a moderately denormalized schema
13. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Cannot create project objects
Data warehouse characteristics
Report Editor
14. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Thresholding
5 Report display views
Metrics
Notes
15. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Value Prompts
Attribute Relationships
Simple Metrics
3-Tier Architecture
16. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Factors to consider when designing a logical data model
2 types of Facts
To qualify a Metric in a Set Qualification
Project Creation Wizard
17. All report-level options overwrite ___________.
Project Creation Wizard
Configuration Wizard
Project-level options/settings
Locking and Resizing
18. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Column Aliases
To edit the appearance of a Graph in a report
2 ways you can configure the Project Source to connect to the Metadata database
Facts
19. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
MSTR OLAP Services
Metrics
View Filter
20. Schema Objects - Application Objects - Configuration Objects
Warehouse Catalog
Project Source
Fact Tables
3 Types of Objects in MSTR Desktop
21. Tables - Facts - Attributes - Hierarchies
Lookup Tables
4 basic Schema objects
To save a Report Format
Tasks when defining a User Hierarchy
22. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Filter Definition Prompts
Desktop Architec
Gigabytes (GB)
23. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
To save a Report Format
To create a Report Prompt
ETL process
Attributes
24. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Report Editor
Table Keys
Notes
25. Metrics you create within a report using only those objects in the report.
Long-term (2 - 5 years)
Desktop Analyst
Derived Metrics
Table Keys
26. How users can share comments for reports to other users
Column Aliases
Attribute Creation Wizard good for
Notes
To drill through User Hierarchies
27. Metrics aggregate on the lowest-level attribute __________.
Drilling
Schema Object Editor
Thresholding
By default
28. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Desktop Architec
2 types of Facts
To create a Report Prompt
29. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
4 factors to consider when designing a data-warehouse schema
The 3 MSTR Tools
Project Source
30. The actual column name for a fact. Every fact must have at least 1 expression.
OLAP
Advantage of a completely denormalized schema
Fact Expression
Outline Mode
31. 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.
Heterogeneous Fact
Lookup Table structure of a moderately denormalized schema
View Filters
Highest-level attributes
32. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Components of a Derived Metric
Components of a MSTR architecture
To create a Report Prompt
MSTR OLAP Services
33. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Simple Metrics
Report Editor
2 components of a Physical Schema
34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
View Filters
Sorting
To create a Report Prompt
Report Template
35. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Value Prompts
Reports
Characteristics of Nested Metrics
Project Creation Wizard
36. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
To drill through User Hierarchies
Components of a Derived Metric
Report Filter
To qualify a Metric in a Set Qualification
37. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Rollback your changes
Components of Compound Metrics
By default
Display views you can Print by
38. Descriptive data that provides context for Facts.
4 basic Schema objects
To drill through User Hierarchies
Attribute Forms
Unlimited
39. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
Compound Metric
To edit the appearance of a Graph in a report
Facts
40. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Components of a Derived Metric
Outline Mode
5 Report display views
Homogeneous Fact
41. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Different methods for creating Page-by fields
Banding
Schema
2 types of Attribute Relationships
42. To see data at completely different levels - other than that of the original Grid or Graph
3 Methods of MSTR Desktop navigation
Drilling
Derived Metrics
Search-based prompts
43. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
3-Tier Architecture
Project Source
4 basic Schema objects
44. Used to "fine-tune" your Project
OLTP
Characteristics of a Simple Table Key
File > Email Reports As
Architect Graphical Interface
45. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Components of a Metric
Metrics
Data warehouse characteristics
Physical Schema
46. Used to modify a Report
Report Editor
By default
3 Methods of MSTR Desktop navigation
Hierarchies
47. Simple - Derived
Unlimited
5 steps to creating a logical data model
Limitations of the Attribute Creation Wizard
2 types of Attribute Expression
48. 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
Desktop Designer
4 basic Schema objects
Logical Data Model
Simple Metrics
49. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
The System
3 types of Attributes
Cannot create project objects
50. What tool do you use to create the Metadata shell?
Components of a Derived Metric
Hierarchies
Configuration Wizard
File > Email Reports As