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. Less storage - Simple SQL - Complex ETL
2 types of Attribute Expression
Characteristics of a Simple Table Key
MSTR OLAP Services
ETL
2. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
To qualify a Metric in a Set Qualification
Facts
Filter Definition Prompts
ID form
3. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Shortcut Bar
Derived Attribute Expression
MSTR applications
4. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Schema Object Editor
Schema Objects
Locking and Resizing
To edit the appearance of a Graph in a report
5. Attribute Creation Wizard - Attribute Editor
Data warehouse characteristics
Methods are there to creating Attributes
Terabytes (TB)
Table Keys
6. 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.
Objects you are allowed to Page-by
3 types of Attributes
Report Prompts
Nested Metrics
7. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Heterogeneous Attribute
View Filter
Project-level options/settings
Desktop Analyst
8. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
'View of a Report'
Report Formatting
Required on the report for Outline Model to work
9. Specifies a condition data must meet in order to be included in a report
Display views you can Print by
Shortcut in MSTR Desktop
Report Filter
Search Object
10. Formula - Level (Dimensionality) - Conditionality - Transformation
MSTR applications
Search-based prompts
Rollback your changes
Components of a Metric
11. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
ETL
2 types of Fact Expressions
4 parts of the Project Design Process
12. Grid View - Graph View - Grid/Graph View - SQL View
Application Objects
Stored
Display views you can Print by
4 basic Schema objects
13. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Default Project folder structure
Sample Metrics commonly performed on Facts
Attribute Forms
Report Objects
14. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
File types are allowed for exporting a Report
Types of analysis you can perform with OLAP Services
Report Formatting
Required on the report for Outline Model to work
15. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
Types of drilling
Schema Objects
Report Template
16. OLAP retains data ________
Application Objects
Attribute Elements
2 options for Sorting
Long-term (2 - 5 years)
17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
New SQL
Schema
3 components of a Report
Simple Metrics
18. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Long-term (2 - 5 years)
MSTR OLAP Services
ID form
19. 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
Characteristics of Nested Metrics
To save a Report Format
To edit the appearance of a Graph in a report
20. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Simple Metrics
Components of Compound Metrics
Relationship Tables
Filter Definition Prompts
21. The default entry-points.
Highest-level attributes
MSTR Desktop
MSTR Connectivity Wizard
The 3 MSTR Tools
22. OLAP data storage measure
2-Tier Architecture
Search-based prompts
Terabytes (TB)
Schema Objects
23. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Compound Metric
3 Sections of the MSTR Desktop interface
Components of Compound Metrics
ETL process
24. The System Hierarchy is automatically updated whenever you make a change to an __________________.
5 Report display views
Attribute or its relationship(s)
Characteristics of a Simple Table Key
The 3 MSTR Tools
25. Enables you to select and display subsets of a report as separate pages.
Search Object
Cannot create project objects
Page-by
Components of Compound Metrics
26. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
OLTP
Project Source
3 functions of Attribute Forms
To create a Report Prompt
27. Extraction - transformation - loading
MSTR applications
Required on the report for Outline Model to work
Table Keys
ETL
28. 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
Data Pivoting
Desktop Designer
2 types of Fact Expressions
29. You can e-mail reports by going to _____
Object Prompts
File > Email Reports As
2 types of Table Keys
Desktop Designer
30. Using the Prompt Generation Wizard - Inside the Report Editor
User Hierarchies
Filter Definition Prompts
To create a Report Prompt
To edit the appearance of a Graph in a report
31. Homogeneous - Heterogeneous
2 options for Sorting
Report Filter operators
File > Email Reports As
2 types of Facts
32. User reporting requirements - Query performance - Data volume - DB Maintenance
Components of Compound Metrics
4 factors to consider when designing a data-warehouse schema
Value Prompts
Facts
33. Must have a one-to-one relationship with all other forms.
Hierarchies
Warehouse Catalog
Attribute Forms
4 properties you must know in order to create attributes using the Attribute Editor
34. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Report Filter
Data warehouse characteristics
MSTR OLAP Services
Lookup Tables
35. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Physical Schema
File types are allowed for exporting a Report
Relationship Tables
OLTP
36. A new tool for project design tasks - used for fine-tuning a project after initial creation
4 tasks of the Attribute Creation Wizard
Components of a MSTR architecture
Architect Graphical Interface
Report Subscription
37. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
2 types of Table Keys
Components of Compound Metrics
3 Methods of MSTR Desktop navigation
38. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 methods to creating Facts
2 types of Table Keys
Report Template
Components of a Derived Metric
39. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Desktop Analyst
Schema Objects
2 options for Sorting
Compound Attribute
40. Descriptive data that provides context for Facts.
Stored
2 ways you can configure the Project Source to connect to the Metadata database
Report Definitions
Attribute Forms
41. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Architect Graphical Interface
Application Objects
MSTR OLAP Services
Project-level options/settings
42. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Methods are there to creating Attributes
Derived Attribute Expression
To save a Report Format
43. A method of organizing the appearance of report results in a Grid report based on a criteria
Components of the Logical Data Model
OLAP
Homogeneous Fact
Banding
44. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Architect Graphical Interface
Schema Objects
MSTR Connectivity Wizard
Objects you are allowed to Page-by
45. It contains links to specific folders in the Folder List
4 basic Schema objects
Shortcut Bar
Drilling
5 steps to creating a logical data model
46. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Project-level options/settings
2 types of Attribute Expression
Aggregate a Metric
Source system characteristics
47. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Banding
Default Project folder structure
To "drill down" on a report
Fact Tables
48. Used to modify a Report
Report Editor
3 project creation interfaces
Banding
Sample Metrics commonly performed on Facts
49. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Outline Mode
Metrics
Architect Graphical Interface
Required on the report for Outline Model to work
50. Metrics that perform multiple aggregations; one calculation inside of another.
Heterogeneous Attribute
Nested Metrics
Characteristics of Nested Metrics
Sorting