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. To see data at completely different levels - other than that of the original Grid or Graph
3 column types of a Physical Schema
Lookup Table structure of a completely denormalized schema
Drilling
Report Objects
2. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Compound Metric
Desktop Designer
Attribute Forms
Report Objects
3. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Derived Attribute Expression
Report Template
The 3 MSTR Tools
4. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Gigabytes (GB)
Report Formatting
To create the Project connectivity
Default Project folder structure
5. A condition data must meet in order to be included in a report. Does affect the SQL.
Desktop Analyst
Report Filter
Nested Metrics
Components of Compound Metrics
6. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
MSTR OLAP Services
Shortcut Bar
Simple Metrics
Column Aliases
7. A new tool for project design tasks - used for fine-tuning a project after initial creation
ETL process
Architect Graphical Interface
The System
Long-term (2 - 5 years)
8. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
ETL
3 project creation interfaces
Report Editor
Notes
9. OLTP retains data ________
Short-term (2 - 6 months)
Simple Attribute Expression
Project
The System
10. Schema Objects - Application Objects - Configuration Objects
2 options for Sorting
Project
Simple Metrics
3 Types of Objects in MSTR Desktop
11. User reporting requirements - Query performance - Data volume - DB Maintenance
2 types of Attribute Expression
Report Filter operators
Schema
4 factors to consider when designing a data-warehouse schema
12. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Homogeneous Attribute
Architect Graphical Interface
MSTR OLAP Services
Characteristics of Nested Metrics
13. OLAP Services does not add any ______ to the report query.
Notes
New SQL
Unlimited
3-Tier Architecture
14. All Attributes must have an _______.
ID form
4 types of Metrics
Column Aliases
Application Objects
15. Used to "fine-tune" your Project
Architect Graphical Interface
Short-term (2 - 6 months)
MSTR Desktop Architect
The 3 MSTR Tools
16. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Report Filter operators
Filter Definition Prompts
Desktop Administrative Functions
Objects you are allowed to Page-by
17. What tool do you use to create the Metadata DSN connection?
Logical Data Model
Project-level options/settings
MSTR Connectivity Wizard
Lookup Table structure of a completely denormalized schema
18. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
3 functions of Attribute Forms
Configuration Wizard
Components of Compound Metrics
File types are allowed for exporting a Report
19. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Notes
Reports
Report Objects
20. Must have a one-to-one relationship with all other forms.
Warehouse Catalog
Components of Compound Metrics
Schema Object Editor
Attribute Forms
21. Create the Project Source - Create the Database Instance
2 types of Fact Expressions
Desktop Architec
To create the Project connectivity
Objects you are allowed to Page-by
22. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Attribute or its relationship(s)
Compound Metric
Process for creating the Project Metadata
Table Keys
23. Specifies what info to retrieve from a data-warehouse - and how to display it
Schema Object Editor
To qualify a Metric in a Set Qualification
To save a Report Format
Report Template
24. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Project-level options/settings
To edit the appearance of a Graph in a report
4 basic Schema objects
Relationship Tables
25. The Attribute Form maps to the same column name in multiple tables
Components of a Metric
Components of Compound Metrics
2-Tier Architecture
Homogeneous Attribute
26. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Schema Object Editor
Report Formatting
Search Object
Attributes
27. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
4 basic Schema objects
Advantage of a completely denormalized schema
Limitations of the Attribute Creation Wizard
Components of Compound Metrics
28. It contains the ID column of all higher-level attributes
Gigabytes (GB)
Lookup Table structure of a moderately denormalized schema
File > Email Reports As
To qualify a Metric in a Set Qualification
29. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3 column types of a Physical Schema
Process for creating the Project Metadata
3-Tier Architecture
Compound Attribute
30. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
To create a Report Prompt
4 types of Metrics
To drill through User Hierarchies
31. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
Factors to consider when designing a logical data model
Project Source
Subtotals
32. The Attribute Form maps to different column names in multiple tables
5 steps to creating a logical data model
Heterogeneous Attribute
Column Aliases
Shortcut Bar
33. Descriptive data that provides context for Facts.
Attributes
Attribute Forms
Nested Metrics
Methods are there to creating Attributes
34. Creating multiple attributes quickly. Used during the initial project creation.
2 methods to creating Facts
Attribute Creation Wizard good for
Report Subscription
2 types of Fact Expressions
35. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Table Keys
Attribute Relationships
Fact Tables
Reports
36. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Configuration Wizard
Relationship Tables
Architect Graphical Interface
OLAP
37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Characteristics of a Compound Table Key
Report Editor
Physical Schema
38. A shortcut to an existing Object in a Project
Project-level options/settings
Shortcut in MSTR Desktop
Homogeneous Fact
Lookup Table structure of a moderately denormalized schema
39. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Advantage of a completely denormalized schema
MSTR Desktop Architect
Report Definitions
Attribute or its relationship(s)
40. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Report Editor
Level Prompts
2 methods to creating Facts
4 tasks of the Attribute Creation Wizard
41. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Report Filter
Terabytes (TB)
2 types of Fact Expressions
Attribute Relationships
42. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Facts
Factors to consider when designing a logical data model
Fact Tables
4 types of Report Filters
43. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Lookup Tables
Shortcut Bar
Schema Object Editor
44. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Long-term (2 - 5 years)
Desktop Designer
Filter Definition Prompts
ID form
45. The unique values of an attribute obtained from the data-warehouse
Components of a Derived Metric
Report Definitions
Heterogeneous Attribute
Attribute Elements
46. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
3 Types of Objects in MSTR Desktop
Using a Search Object
User Hierarchies
Data warehouse characteristics
47. The Attribute Form Expression that maps to a single column - no matter the number of tables
Very high; part of ETL process
3 components of a Report
4 tasks of the Attribute Creation Wizard
Simple Attribute Expression
48. View Filters are saved with the _____________.
Report Definitions
2 types of Fact Expressions
4 types of Report Filters
2 ways you can configure the Project Source to connect to the Metadata database
49. Metrics that perform multiple aggregations; one calculation inside of another.
To drill through User Hierarchies
Object Prompts
Filter Definition Prompts
Nested Metrics
50. What tool do you use to create the Metadata shell?
Configuration Wizard
MSTR Desktop
'View of a Report'
Facts