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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Report Filter
5 Report display views
Locking and Resizing
2. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Physical Schema
Attribute Forms
Homogeneous Attribute
3. To define the level of aggregation for a specific metric - Used for qualifications
Heterogeneous Attribute
Attributes
Hierarchies
Source system characteristics
4. Specifies a condition data must meet in order to be included in a report
Search-based prompts
Report Filter
Tasks when defining a User Hierarchy
Attribute Forms
5. 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
Types of drilling
Notes
MSTR Desktop
Attribute Forms
6. Tables - Facts - Attributes - Hierarchies
Source system characteristics
MSTR Desktop Architect
To edit the appearance of a Graph in a report
4 basic Schema objects
7. Create the Project Source - Create the Database Instance
Gigabytes (GB)
To create the Project connectivity
Attribute Elements
Subtotals
8. 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
Architect Graphical Interface
5 Report display views
By default
9. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
To "drill down" on a report
Outline Mode
Level Prompts
2 options for Sorting
10. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
Reference Report Objects
4 properties you must know in order to create attributes using the Attribute Editor
4 factors to consider when designing a data-warehouse schema
11. Creating multiple attributes quickly. Used during the initial project creation.
User Hierarchies
Very high; part of ETL process
Attribute Creation Wizard good for
Project
12. Folder List - Object Viewer - Shortcut Bar
Default Project folder structure
Reference Report Objects
5 steps to creating a logical data model
3 Sections of the MSTR Desktop interface
13. OLAP data storage measure
Project Creation Wizard
Reports
Terabytes (TB)
Gigabytes (GB)
14. A user interface for creating and maintaining a BI environment
To save a Report Format
MSTR Desktop
Terabytes (TB)
Level Prompts
15. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
3 components of a Report
5 steps to creating a logical data model
Attribute Forms
Sample Metrics commonly performed on Facts
16. Used to "fine-tune" your Project
3 Methods of MSTR Desktop navigation
Short-term (2 - 6 months)
Architect Graphical Interface
View Filters
17. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Lookup Table structure of a moderately denormalized schema
Tasks when defining a User Hierarchy
Logical Data Model
Desktop Designer
18. 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
3 types of Attributes
Aggregate a Metric
Characteristics of Nested Metrics
Heterogeneous Fact
19. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
3 types of Attributes
Source system characteristics
Desktop Designer
The System
20. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Components of a Metric
Sample Metrics commonly performed on Facts
Lookup Tables
21. 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
MSTR Desktop
3 Schema types
Compound Attribute
Lookup Table structure of a completely normalized schema
22. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Notes
Terabytes (TB)
3-Tier Architecture
Attribute or its relationship(s)
23. View Filters can only ___________.
Reference Report Objects
Warehouse Catalog
Heterogeneous Attribute
Reports
24. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Fact Tables
MSTR OLAP Services
Object Prompts
25. Extraction - transformation - loading
MSTR applications
ETL
File types are allowed for exporting a Report
Report Subscription
26. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
Heterogeneous Attribute
3 components of a Report
Project
27. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Components of Compound Metrics
Minimal or none
5 Report display views
28. Simple - Compound - Nested - Derived
Page-by
To edit the appearance of a Graph in a report
File > Email Reports As
4 types of Metrics
29. The Attribute Form Expression that maps to a single column - no matter the number of tables
Nested Metrics
Simple Attribute Expression
Desktop Analyst
Architect Graphical Interface
30. Used to limit a possibly overwhelming set of potential prompt answers
User Hierarchies
To create the Project connectivity
Search-based prompts
Report Definitions
31. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Using a Search Object
Relationship Tables
Drilling
New SQL
32. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
3 Schema types
3 Types of Objects in MSTR Desktop
Stored
33. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Components of Compound Metrics
Metrics
Different methods for creating Page-by fields
Value Prompts
34. Used to modify a Report
Display views you can Print by
Reports
Report Editor
Characteristics of a Simple Table Key
35. The actual column name for a fact. Every fact must have at least 1 expression.
3 Methods of MSTR Desktop navigation
4 tasks of the Attribute Creation Wizard
Hierarchies
Fact Expression
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
OLAP
Components of a Derived Metric
Default Project folder structure
Aggregate a Metric
37. User reporting requirements - Query performance - Data volume - DB Maintenance
File > Email Reports As
2-Tier Architecture
To edit the appearance of a Graph in a report
4 factors to consider when designing a data-warehouse schema
38. OLTP data storage measure
By default
Project Source
Gigabytes (GB)
2 types of Attribute Expression
39. Simple - Derived
User Hierarchies
Lookup Tables
2 types of Attribute Expression
View Filters
40. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
4 tasks of the Attribute Creation Wizard
Reports
OLAP
Data warehouse characteristics
41. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
To save a Report Format
Level Prompts
Sample Metrics commonly performed on Facts
Desktop Administrative Functions
42. Schema Objects - Application Objects - Configuration Objects
Report Filter
3 Types of Objects in MSTR Desktop
View Filters
Heterogeneous Attribute
43. The unique values of an attribute obtained from the data-warehouse
Report Filter
4 basic Schema objects
Attribute Elements
Types of drilling
44. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Highest-level attributes
To qualify a Metric in a Set Qualification
2 types of Attribute Relationships
Factors to consider when designing a logical data model
45. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Required on the report for Outline Model to work
Homogeneous Fact
Schema
Level Prompts
46. Template - Filter - View of a Report
Compound Metric
3 components of a Report
Report Filter
Short-term (2 - 6 months)
47. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
2 components of a Physical Schema
Process for creating the Project Metadata
5 steps to creating a logical data model
ETL process
48. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Long-term (2 - 5 years)
Report Prompts
MSTR Desktop
Different methods for creating Page-by fields
49. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
3 Schema types
4 factors to consider when designing a data-warehouse schema
Stored
The 3 MSTR Tools
50. OLTP retains data ________
Thresholding
Short-term (2 - 6 months)
3 column types of a Physical Schema
To qualify a Metric in a Set Qualification