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. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Minimal or none
MSTR OLAP Services
5 Report display views
2 types of Attribute Expression
2. Reduced number of JOINS in the generated SQL
Types of analysis you can perform with OLAP Services
Data warehouse characteristics
Advantage of a completely denormalized schema
Notes
3. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
4 types of Prompts
2 options for Sorting
To save a Report Format
Very high; part of ETL process
4. A condition data must meet in order to be included in a report. Does affect the SQL.
4 factors to consider when designing a data-warehouse schema
View Filters
Report Filter
Report Definitions
5. Using the Prompt Generation Wizard - Inside the Report Editor
Report Subscription
To create a Report Prompt
To drill through User Hierarchies
ID form
6. Used to "fine-tune" your Project
By default
Architect Graphical Interface
4 types of Metrics
Filter Definition Prompts
7. View Filters can only ___________.
Shortcut Bar
Shortcut in MSTR Desktop
Reference Report Objects
Metrics
8. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Highest-level attributes
Reports
Physical Schema
9. 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
2 options for Sorting
Sample Metrics commonly performed on Facts
Logical Data Model
10. Store info on relationships between 2 or more tables (attributes) - like an Index table.
4 properties you must know in order to create attributes using the Attribute Editor
Schema Objects
Relationship Tables
4 types of Report Filters
11. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
To edit the appearance of a Graph in a report
Report Editor
5 steps to creating a logical data model
Data Pivoting
12. 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
Simple Metrics
Process for creating the Project Metadata
Lookup Table structure of a completely normalized schema
13. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
To create a Report Prompt
4 parts of the Project Design Process
The System
Report Objects
14. To see data at completely different levels - other than that of the original Grid or Graph
Derived Attribute Expression
The System
Long-term (2 - 5 years)
Drilling
15. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Display views you can Print by
Limitations of the Attribute Creation Wizard
Table Keys
Relationship Tables
16. The logical associations between attributes that exist based on a business rule
Source system characteristics
Attribute Relationships
Facts
Desktop Architec
17. You can e-mail reports by going to _____
Minimal or none
File > Email Reports As
Stored
Project
18. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
MSTR applications
Report Filter operators
Report Formatting
User Hierarchies
19. 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 drill through User Hierarchies
Report Prompts
Types of analysis you can perform with OLAP Services
Report Definitions
20. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
3 Types of Objects in MSTR Desktop
Homogeneous Fact
Heterogeneous Fact
4 properties you must know in order to create attributes using the Attribute Editor
21. Used for - Initially populating the Metadata - Creating schema objects
Shortcut in MSTR Desktop
Very high; part of ETL process
Default Project folder structure
MSTR Desktop Architect
22. A user interface for creating and maintaining a BI environment
Report Filter
MSTR Desktop
Using a Search Object
Report Definitions
23. Direct: 2-tier - Server: 3-tier
3 Types of Objects in MSTR Desktop
User Hierarchies
2 ways you can configure the Project Source to connect to the Metadata database
Value Prompts
24. You can _____________ in the Architect Graphical Interface.
4 types of Metrics
Attribute or its relationship(s)
Warehouse Catalog
Rollback your changes
25. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
View Filters
Logical Data Model
Attribute Elements
Types of analysis you can perform with OLAP Services
26. OLAP retains data ________
Shortcut Bar
Long-term (2 - 5 years)
Filter Definition Prompts
2 types of Attribute Expression
27. Must have a one-to-one relationship with all other forms.
Report Objects
Relationship Tables
Attribute Forms
3-Tier Architecture
28. Enables you to lock column headers so that they always appear when scrolling
4 basic Schema objects
3 Sections of the MSTR Desktop interface
Page-by
Locking and Resizing
29. 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
Gigabytes (GB)
Data Pivoting
MSTR Desktop
30. It contains the ID and DESC columns of all higher-level attributes
Hierarchies
2 types of Attribute Relationships
Limitations of the Attribute Creation Wizard
Lookup Table structure of a completely denormalized schema
31. User requirements - Existing source data - Technical and performance considerations
Sorting
File > Email Reports As
Factors to consider when designing a logical data model
Report Objects
32. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
MSTR Desktop Architect
Schema
3 Types of Objects in MSTR Desktop
Search Object
33. Metrics that perform multiple aggregations; one calculation inside of another.
Attributes
To drill through User Hierarchies
Nested Metrics
File > Email Reports As
34. The Attribute Form Expression that maps to a single column - no matter the number of tables
MSTR OLAP Services
Simple Attribute Expression
Report Definitions
5 Report display views
35. How users can share comments for reports to other users
Report Editor
Notes
Shortcut in MSTR Desktop
Tasks when defining a User Hierarchy
36. Simple - Derived
4 factors to consider when designing a data-warehouse schema
4 parts of the Project Design Process
2 types of Attribute Expression
Report Filter operators
37. Specifies a condition data must meet in order to be included in a report
Factors to consider when designing a logical data model
Heterogeneous Fact
4 factors to consider when designing a data-warehouse schema
Report Filter
38. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Factors to consider when designing a logical data model
Facts
Data warehouse characteristics
39. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Outline Mode
View Filter
Architect Graphical Interface
4 basic Schema objects
40. Formula - Level (Dimensionality) - Conditionality - Transformation
3 Schema types
Report Subscription
MSTR Connectivity Wizard
Components of a Metric
41. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
ETL
Rollback your changes
Attribute Forms
42. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
3 Types of Objects in MSTR Desktop
OLAP
3 project creation interfaces
Fact Expression
43. What tool do you use to create the Metadata DSN connection?
MSTR Desktop
MSTR Connectivity Wizard
3 components of a Report
Project Source
44. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
To "drill down" on a report
To qualify a Metric in a Set Qualification
Project Source
45. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Characteristics of a Compound Table Key
Stored
Different methods for creating Page-by fields
Display views you can Print by
46. Groupings of directly related attributes. Also commonly known as "dimensions".
MSTR Connectivity Wizard
Application Objects
Subtotals
Hierarchies
47. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Locking and Resizing
Advantage of a completely denormalized schema
Metrics
48. Schema Objects - Application Objects - Configuration Objects
5 steps to creating a logical data model
Facts
3 Types of Objects in MSTR Desktop
Characteristics of a Compound Table Key
49. The Attribute Form maps to different column names in multiple tables
MSTR Connectivity Wizard
Simple Metrics
Heterogeneous Attribute
ETL
50. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
To "drill down" on a report
2 types of Attribute Relationships
3 Sections of the MSTR Desktop interface
Reports