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. Level of OLAP integration
Components of a Metric
Very high; part of ETL process
Short-term (2 - 6 months)
Reports
2. Metrics you create within a report using only those objects in the report.
Derived Metrics
4 parts of the Project Design Process
2 components of a Physical Schema
Project Creation Wizard
3. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
2 components of a Physical Schema
2 types of Table Keys
Homogeneous Fact
4. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
4 parts of the Project Design Process
Report Definitions
Search Object
5. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Column Aliases
Limitations of the Attribute Creation Wizard
Banding
Object Prompts
6. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
2 options for Sorting
To edit the appearance of a Graph in a report
To qualify a Metric in a Set Qualification
Compound Metric
7. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
4 tasks of the Attribute Creation Wizard
Shortcut in MSTR Desktop
2 ways you can configure the Project Source to connect to the Metadata database
8. Template - Filter - View of a Report
Schema Object Editor
Attribute Forms
3 components of a Report
Fact Expression
9. AND - OR - OR NOT - AND NOT
Desktop Analyst
2 types of Facts
Data warehouse characteristics
Report Filter operators
10. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Attribute Elements
4 parts of the Project Design Process
Characteristics of a Compound Table Key
2 types of Fact Expressions
11. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
To qualify a Metric in a Set Qualification
Components of a Derived Metric
2 types of Attribute Relationships
12. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Report Subscription
4 tasks of the Attribute Creation Wizard
Source system characteristics
13. All report-level options overwrite ___________.
Project-level options/settings
2 components of a Physical Schema
Shortcut in MSTR Desktop
Object Prompts
14. 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
File types are allowed for exporting a Report
Compound Attribute
Level Prompts
15. It contains the ID column of all higher-level attributes
2 types of Attribute Expression
Heterogeneous Fact
Lookup Table structure of a moderately denormalized schema
Metrics
16. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
User Hierarchies
Notes
The System
3 column types of a Physical Schema
17. Top menu/dropdowns - Toolbar - Right-click popup menus
Logical Data Model
The System
3 Methods of MSTR Desktop navigation
3 types of Attributes
18. User requirements - Existing source data - Technical and performance considerations
Lookup Table structure of a completely denormalized schema
5 Report display views
Factors to consider when designing a logical data model
Value Prompts
19. Creating multiple attributes quickly. Used during the initial project creation.
3 types of Attributes
ETL process
Attribute Creation Wizard good for
Homogeneous Fact
20. View Filters are saved with the _____________.
Shortcut in MSTR Desktop
4 types of Prompts
3 Methods of MSTR Desktop navigation
Report Definitions
21. Filter definition prompts - Object prompts - Value prompts - Level prompts
Attribute Forms
4 types of Prompts
To create the Project connectivity
Derived Attribute Expression
22. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
'View of a Report'
ETL process
4 properties you must know in order to create attributes using the Attribute Editor
3 functions of Attribute Forms
23. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
The System
Column Aliases
2-Tier Architecture
24. View Filters can only ___________.
Reference Report Objects
Page-by
Lookup Tables
2 components of a Physical Schema
25. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
To create a Report Prompt
Filter Definition Prompts
Desktop Architec
Homogeneous Attribute
26. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Derived Metrics
MSTR applications
Characteristics of a Simple Table Key
User Hierarchies
27. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Components of the Logical Data Model
2 ways you can configure the Project Source to connect to the Metadata database
Relationship Tables
Page-by
28. It contains the ID and DESC columns of all higher-level attributes
Report Editor
Physical Schema
Lookup Table structure of a completely denormalized schema
2-Tier Architecture
29. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Compound Attribute
Application Objects
4 parts of the Project Design Process
New SQL
30. 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
Objects you are allowed to Page-by
Value Prompts
Limitations of the Attribute Creation Wizard
31. 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
Compound Metric
To "drill down" on a report
Characteristics of Nested Metrics
Data Pivoting
32. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Stored
Report Objects
Gigabytes (GB)
33. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Report Prompts
Different methods for creating Page-by fields
Configuration Wizard
34. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Homogeneous Fact
File > Email Reports As
Required on the report for Outline Model to work
Reference Report Objects
35. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
To create the Project connectivity
Object Prompts
Desktop Administrative Functions
Reports
36. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
37. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Report Filter
2 methods to creating Facts
Sample Metrics commonly performed on Facts
3 project creation interfaces
38. Compound - Homogeneous - Heterogeneous
Sample Metrics commonly performed on Facts
Types of analysis you can perform with OLAP Services
The System
3 types of Attributes
39. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Homogeneous Fact
5 Report display views
Rollback your changes
Physical Schema
40. The unique values of an attribute obtained from the data-warehouse
Characteristics of a Compound Table Key
Simple Metrics
Attribute Elements
Components of the Logical Data Model
41. Direct: 2-tier - Server: 3-tier
Source system characteristics
2 ways you can configure the Project Source to connect to the Metadata database
New SQL
By default
42. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Attribute Forms
Desktop Designer
View Filters
2 types of Table Keys
43. Columns - Tables
Schema Objects
2 components of a Physical Schema
Table Keys
2 types of Attribute Relationships
44. OLAP retains data ________
3 Schema types
Terabytes (TB)
Long-term (2 - 5 years)
Homogeneous Attribute
45. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Report Filter operators
Factors to consider when designing a logical data model
Stored
Facts
46. Subtotals reflect accumulations at selected attribute levels
2 options for Sorting
Subtotals
Report Editor
Schema
47. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Data warehouse characteristics
Factors to consider when designing a logical data model
Report Objects
48. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Methods are there to creating Attributes
5 steps to creating a logical data model
ETL
Page-by
49. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
3-Tier Architecture
Shortcut Bar
Report Editor
File types are allowed for exporting a Report
50. Create the Project Source - Create the Database Instance
To create the Project connectivity
Simple Attribute Expression
Schema Object Editor
Rollback your changes