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. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Project
Report Filter
To edit the appearance of a Graph in a report
Components of Compound Metrics
2. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
File > Email Reports As
Cannot create project objects
Search Object
MSTR Desktop Architect
3. Specifies what info to retrieve from a data-warehouse - and how to display it
By default
Very high; part of ETL process
Schema
Report Template
4. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
View Filters
Notes
Characteristics of Nested Metrics
Reports
5. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
2 options for Sorting
Schema
3 column types of a Physical Schema
6. More storage - Complex SQL - Simple ETL
4 parts of the Project Design Process
Derived Attribute Expression
Characteristics of a Compound Table Key
Locking and Resizing
7. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Hierarchies
Objects you are allowed to Page-by
Types of drilling
3 column types of a Physical Schema
8. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Components of the Logical Data Model
Schema Object Editor
Fact Tables
9. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
Long-term (2 - 5 years)
Attributes
ETL process
10. Prompts to select a single value on which to qualify a date - number or text string.
File > Email Reports As
Value Prompts
4 basic Schema objects
3 column types of a Physical Schema
11. The default entry-points.
Highest-level attributes
Reference Report Objects
Homogeneous Attribute
OLAP
12. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Components of a Metric
Outline Mode
Highest-level attributes
13. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Level Prompts
Project-level options/settings
Sample Metrics commonly performed on Facts
Simple Metrics
14. 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.
Report Prompts
Source system characteristics
Warehouse Catalog
Default Project folder structure
15. Level of OLAP integration
Very high; part of ETL process
Types of drilling
Relationship Tables
Types of analysis you can perform with OLAP Services
16. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
4 factors to consider when designing a data-warehouse schema
Characteristics of Nested Metrics
Source system characteristics
Components of a MSTR architecture
17. Filter definition prompts - Object prompts - Value prompts - Level prompts
Short-term (2 - 6 months)
Architect Graphical Interface
4 types of Prompts
Homogeneous Fact
18. The Attribute Form maps to different column names in multiple tables
Process for creating the Project Metadata
Report Objects
Minimal or none
Heterogeneous Attribute
19. OLTP retains data ________
Types of analysis you can perform with OLAP Services
Unlimited
Short-term (2 - 6 months)
Process for creating the Project Metadata
20. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Stored
Rollback your changes
Reports
21. 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.
5 Report display views
Attribute Relationships
Warehouse Catalog
User Hierarchies
22. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Notes
To qualify a Metric in a Set Qualification
MSTR OLAP Services
Cannot create project objects
23. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
MSTR OLAP Services
Lookup Table structure of a completely normalized schema
Heterogeneous Fact
24. Groupings of directly related attributes. Also commonly known as "dimensions".
Report Prompts
4 parts of the Project Design Process
Banding
Hierarchies
25. 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
3 components of a Report
4 types of Report Filters
Project Source
Components of a Derived Metric
26. To see data at completely different levels - other than that of the original Grid or Graph
5 Report display views
Heterogeneous Attribute
Shortcut in MSTR Desktop
Drilling
27. View Filters are saved with the _____________.
Notes
Report Definitions
Data warehouse characteristics
Fact Expression
28. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Level Prompts
Data Pivoting
Report Template
Lookup Tables
29. An environment in which the MSTR Desktop connects directly to the Metadata database.
3 types of Attributes
Column Aliases
Fact Expression
2-Tier Architecture
30. Using the Prompt Generation Wizard - Inside the Report Editor
Desktop Analyst
2 types of Table Keys
Compound Attribute
To create a Report Prompt
31. Used to "fine-tune" your Project
Architect Graphical Interface
4 types of Prompts
Tasks when defining a User Hierarchy
3 Schema types
32. Creating multiple attributes quickly. Used during the initial project creation.
Report Template
Subtotals
Attribute Creation Wizard good for
Reference Report Objects
33. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Report Objects
3 Methods of MSTR Desktop navigation
Logical Data Model
34. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Fact Tables
Attribute Relationships
Components of Compound Metrics
35. OLAP data storage measure
Reports
Advantage of a completely denormalized schema
Schema
Terabytes (TB)
36. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Project-level options/settings
Desktop Designer
Attribute Elements
Sorting
37. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Lookup Table structure of a moderately denormalized schema
Reference Report Objects
Metrics
Components of a Derived Metric
38. Enables you to rearrange the columns and rows in a report.
Characteristics of a Compound Table Key
Object Prompts
Data Pivoting
Report Definitions
39. To define the level of aggregation for a specific metric - Used for qualifications
2 options for Sorting
To save a Report Format
Attributes
3 Sections of the MSTR Desktop interface
40. Used to limit a possibly overwhelming set of potential prompt answers
Stored
Nested Metrics
Search-based prompts
Hierarchies
41. ID columns - Description columns - Fact columns
Terabytes (TB)
Project Creation Wizard
Page-by
3 column types of a Physical Schema
42. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
MSTR Connectivity Wizard
3-Tier Architecture
Search-based prompts
43. All Attributes must have an _______.
Nested Metrics
To qualify a Metric in a Set Qualification
ID form
Value Prompts
44. 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
Schema Objects
Simple Metrics
Components of the Logical Data Model
To qualify a Metric in a Set Qualification
45. User requirements - Existing source data - Technical and performance considerations
Level Prompts
3 Sections of the MSTR Desktop interface
Data warehouse characteristics
Factors to consider when designing a logical data model
46. Simple - Derived
Column Aliases
Project
2 types of Attribute Expression
Short-term (2 - 6 months)
47. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
2 types of Attribute Relationships
Cannot create project objects
Application Objects
3 Sections of the MSTR Desktop interface
48. Create the Project Source - Create the Database Instance
2 ways you can configure the Project Source to connect to the Metadata database
3 functions of Attribute Forms
To create the Project connectivity
Attribute or its relationship(s)
49. Template - Filter - View of a Report
Heterogeneous Attribute
3 components of a Report
Report Prompts
Report Filter operators
50. Simple - Compound - Nested - Derived
Display views you can Print by
4 types of Metrics
Reports
4 types of Prompts