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. 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
Characteristics of Nested Metrics
To save a Report Format
4 parts of the Project Design Process
Object Prompts
2. Specifies what info to retrieve from a data-warehouse - and how to display it
Notes
Report Template
Lookup Table structure of a completely denormalized schema
Metrics
3. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
OLTP
2 options for Sorting
Heterogeneous Attribute
Column Aliases
4. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
3 project creation interfaces
The 3 MSTR Tools
Display views you can Print by
5. Folder List - Object Viewer - Shortcut Bar
2 types of Fact Expressions
4 parts of the Project Design Process
Characteristics of a Simple Table Key
3 Sections of the MSTR Desktop interface
6. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
Components of a Metric
Sample Metrics commonly performed on Facts
Data warehouse characteristics
7. Enables you to select which tables from the data-warehouse to store in the Metadata database
Factors to consider when designing a logical data model
Source system characteristics
Warehouse Catalog
MSTR Desktop Architect
8. 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
Locking and Resizing
Components of a MSTR architecture
Components of a Derived Metric
9. It contains the ID column of all higher-level attributes
To edit the appearance of a Graph in a report
Schema Objects
3 functions of Attribute Forms
Lookup Table structure of a moderately denormalized schema
10. Used to modify a Report
Report Editor
5 Report display views
3-Tier Architecture
Project
11. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Desktop Architec
Attribute Relationships
2 types of Fact Expressions
3 Schema types
12. 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
3 Schema types
To create a Report Prompt
Limitations of the Attribute Creation Wizard
Project-level options/settings
13. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Locking and Resizing
Required on the report for Outline Model to work
Attribute Relationships
3 types of Attributes
14. OLAP data storage measure
View Filter
Terabytes (TB)
File types are allowed for exporting a Report
Report Definitions
15. A user interface for creating and maintaining a BI environment
To edit the appearance of a Graph in a report
MSTR Desktop
Using a Search Object
Configuration Wizard
16. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
3 Types of Objects in MSTR Desktop
Tasks when defining a User Hierarchy
Physical Schema
Lookup Table structure of a completely denormalized schema
17. Used to limit a possibly overwhelming set of potential prompt answers
Search Object
Relationship Tables
Search-based prompts
Facts
18. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Facts
3 components of a Report
Schema
19. Enables you to format report values based on a condition - such as highlights - font colors - etc.
3 Schema types
Report Definitions
Thresholding
Desktop Administrative Functions
20. Columns - Tables
Physical Schema
Advantage of a completely denormalized schema
Methods are there to creating Attributes
2 components of a Physical Schema
21. 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
Simple Metrics
MSTR Connectivity Wizard
4 tasks of the Attribute Creation Wizard
Outline Mode
22. You can _____________ in the Architect Graphical Interface.
Architect Graphical Interface
3 types of Attributes
Very high; part of ETL process
Rollback your changes
23. The unique values of an attribute obtained from the data-warehouse
3 Types of Objects in MSTR Desktop
Attribute Elements
2-Tier Architecture
MSTR Connectivity Wizard
24. All report-level options overwrite ___________.
Project-level options/settings
4 factors to consider when designing a data-warehouse schema
MSTR Desktop
Lookup Tables
25. Schema Objects - Application Objects - Configuration Objects
Lookup Table structure of a moderately denormalized schema
3 Types of Objects in MSTR Desktop
Report Filter
Attribute or its relationship(s)
26. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
4 properties you must know in order to create attributes using the Attribute Editor
Different methods for creating Page-by fields
MSTR Desktop
MSTR Desktop Architect
27. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Attribute Creation Wizard good for
3 Methods of MSTR Desktop navigation
2 types of Table Keys
3 components of a Report
28. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Level Prompts
Methods are there to creating Attributes
Components of a Derived Metric
Types of drilling
29. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Sorting
Aggregate a Metric
Application Objects
4 types of Metrics
30. More storage - Complex SQL - Simple ETL
Attribute Creation Wizard good for
Characteristics of a Compound Table Key
The System
Attribute Elements
31. Level of OLTP integration
By default
2 types of Attribute Relationships
Minimal or none
The 3 MSTR Tools
32. What tool do you use to create the Metadata shell?
Search Object
Fact Tables
Logical Data Model
Configuration Wizard
33. 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
ID form
Characteristics of a Simple Table Key
Shortcut Bar
34. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
4 tasks of the Attribute Creation Wizard
ETL process
5 steps to creating a logical data model
Stored
35. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Very high; part of ETL process
Reports
Aggregate a Metric
ETL process
36. View Filters can only ___________.
Data warehouse characteristics
4 factors to consider when designing a data-warehouse schema
Report Filter operators
Reference Report Objects
37. Compound - Homogeneous - Heterogeneous
4 basic Schema objects
3 types of Attributes
Process for creating the Project Metadata
Report Prompts
38. It contains links to specific folders in the Folder List
To drill through User Hierarchies
Data warehouse characteristics
Shortcut Bar
Physical Schema
39. OLTP retains data ________
Default Project folder structure
Report Subscription
Short-term (2 - 6 months)
To save a Report Format
40. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Cannot create project objects
The 3 MSTR Tools
Characteristics of Nested Metrics
Limitations of the Attribute Creation Wizard
41. A new tool for project design tasks - used for fine-tuning a project after initial creation
Attribute Forms
Data warehouse characteristics
Architect Graphical Interface
Report Objects
42. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
Banding
Characteristics of a Compound Table Key
ID form
43. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Components of a MSTR architecture
Reference Report Objects
Characteristics of a Compound Table Key
OLAP
44. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Schema
MSTR Desktop
Sorting
45. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Desktop Analyst
The System
Components of a Derived Metric
4 tasks of the Attribute Creation Wizard
46. 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
Objects you are allowed to Page-by
Page-by
3 functions of Attribute Forms
The 3 MSTR Tools
47. It contains the ID column of the parent attribute
Page-by
Using a Search Object
Drilling
Lookup Table structure of a completely normalized schema
48. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Rollback your changes
Warehouse Catalog
To drill through User Hierarchies
49. Create the Project Source - Create the Database Instance
4 properties you must know in order to create attributes using the Attribute Editor
Unlimited
ETL
To create the Project connectivity
50. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Homogeneous Attribute
Source system characteristics
To drill through User Hierarchies