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: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Value Prompts
2 types of Fact Expressions
Attribute Forms
Homogeneous Fact
2. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Characteristics of Nested Metrics
2-Tier Architecture
Lookup Tables
3. AND - OR - OR NOT - AND NOT
4 factors to consider when designing a data-warehouse schema
Report Filter operators
3 Schema types
Components of Compound Metrics
4. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
ID form
MSTR Connectivity Wizard
Desktop Administrative Functions
5. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Project-level options/settings
Report Definitions
Drilling
6. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Report Editor
Outline Mode
Project
2 methods to creating Facts
7. OLAP data storage measure
Metrics
Terabytes (TB)
Application Objects
Table Keys
8. The logical associations between attributes that exist based on a business rule
Warehouse Catalog
Attribute Relationships
Desktop Architec
File types are allowed for exporting a Report
9. Filter definition prompts - Object prompts - Value prompts - Level prompts
2 methods to creating Facts
Physical Schema
Logical Data Model
4 types of Prompts
10. A development environment to create BI applications - allowing users to edit the Metadata database
Report Filter operators
Desktop Architec
3 Sections of the MSTR Desktop interface
Derived Metrics
11. Facts - Attributes - Hierarchies
Characteristics of Nested Metrics
To create the Project connectivity
Subtotals
Components of the Logical Data Model
12. The System Hierarchy is automatically updated whenever you make a change to an __________________.
2 types of Attribute Expression
5 Report display views
Attribute or its relationship(s)
MSTR Desktop
13. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
Schema Objects
Advantage of a completely denormalized schema
Rollback your changes
14. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Value Prompts
To create a Report Prompt
4 basic Schema objects
Report Objects
15. Enables you to select and display subsets of a report as separate pages.
Default Project folder structure
Nested Metrics
Process for creating the Project Metadata
Page-by
16. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
To edit the appearance of a Graph in a report
Aggregate a Metric
2 options for Sorting
2 types of Attribute Relationships
17. A feature that enables users to delivers reports to the history list - cache or mobile
Different methods for creating Page-by fields
Report Subscription
Components of the Logical Data Model
Lookup Table structure of a completely normalized schema
18. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
2 types of Facts
To "drill down" on a report
4 properties you must know in order to create attributes using the Attribute Editor
19. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
MSTR Desktop Architect
3 Types of Objects in MSTR Desktop
Advantage of a completely denormalized schema
20. 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
4 types of Report Filters
To "drill down" on a report
Terabytes (TB)
3 Methods of MSTR Desktop navigation
21. What tool do you use to create the Metadata DSN connection?
3 Sections of the MSTR Desktop interface
Components of a MSTR architecture
Heterogeneous Attribute
MSTR Connectivity Wizard
22. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Aggregate a Metric
Schema
Attribute Elements
Locking and Resizing
23. 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
Aggregate a Metric
Different methods for creating Page-by fields
Characteristics of Nested Metrics
Schema Objects
24. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Homogeneous Attribute
Facts
Attribute or its relationship(s)
25. View Filters are saved with the _____________.
Report Definitions
The System
Components of Compound Metrics
To edit the appearance of a Graph in a report
26. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Attribute Forms
Nested Metrics
To save a Report Format
Project
27. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Minimal or none
Fact Tables
Reports
Shortcut Bar
28. Prompts to select a single value on which to qualify a date - number or text string.
Gigabytes (GB)
Value Prompts
Lookup Table structure of a completely denormalized schema
4 types of Report Filters
29. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
5 steps to creating a logical data model
Desktop Analyst
Relationship Tables
Cannot create project objects
30. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Relationship Tables
Characteristics of a Compound Table Key
Default Project folder structure
31. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Terabytes (TB)
Limitations of the Attribute Creation Wizard
4 tasks of the Attribute Creation Wizard
Long-term (2 - 5 years)
32. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
3 Methods of MSTR Desktop navigation
View Filters
3 Sections of the MSTR Desktop interface
33. Must have a one-to-one relationship with all other forms.
Display views you can Print by
To save a Report Format
Attribute Forms
2 methods to creating Facts
34. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Different methods for creating Page-by fields
Data warehouse characteristics
Components of a Derived Metric
Source system characteristics
35. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Rollback your changes
Configuration Wizard
To drill through User Hierarchies
Using a Search Object
36. OLTP retains data ________
Minimal or none
Short-term (2 - 6 months)
Data warehouse characteristics
File types are allowed for exporting a Report
37. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
File types are allowed for exporting a Report
Object Prompts
Level Prompts
38. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
3 components of a Report
Facts
To drill through User Hierarchies
39. You can e-mail reports by going to _____
5 Report display views
File > Email Reports As
2 options for Sorting
Attribute Forms
40. Subtotals reflect accumulations at selected attribute levels
Attributes
Project Creation Wizard
5 Report display views
Subtotals
41. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
4 properties you must know in order to create attributes using the Attribute Editor
To edit the appearance of a Graph in a report
Sorting
Schema Object Editor
42. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
To create the Project connectivity
Report Objects
Notes
43. Simple - Compound - Nested - Derived
Compound Metric
4 types of Metrics
Lookup Table structure of a completely normalized schema
The 3 MSTR Tools
44. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 column types of a Physical Schema
Objects you are allowed to Page-by
To "drill down" on a report
3 project creation interfaces
45. Descriptive data that provides context for Facts.
To save a Report Format
Attribute Forms
Filter Definition Prompts
3 column types of a Physical Schema
46. 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.
To qualify a Metric in a Set Qualification
4 types of Metrics
Report Prompts
Level Prompts
47. Enables you to select which tables from the data-warehouse to store in the Metadata database
Level Prompts
Warehouse Catalog
Heterogeneous Attribute
Report Editor
48. Compound - Homogeneous - Heterogeneous
Value Prompts
Report Filter
Application Objects
3 types of Attributes
49. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Lookup Table structure of a moderately denormalized schema
Value Prompts
Attribute or its relationship(s)
50. The Attribute Form maps to different column names in multiple tables
Filter Definition Prompts
Nested Metrics
Heterogeneous Attribute
3 functions of Attribute Forms