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. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Banding
3-Tier Architecture
Source system characteristics
2. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Data Pivoting
4 factors to consider when designing a data-warehouse schema
5 steps to creating a logical data model
3. 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
Banding
Types of drilling
Search Object
Default Project folder structure
4. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Source system characteristics
Shortcut in MSTR Desktop
Homogeneous Fact
5. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Filter Definition Prompts
Locking and Resizing
Minimal or none
6. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
File types are allowed for exporting a Report
Column Aliases
3 project creation interfaces
Highest-level attributes
7. A development environment to create BI applications - allowing users to edit the Metadata database
Reference Report Objects
Desktop Architec
Simple Attribute Expression
Outline Mode
8. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
2 components of a Physical Schema
Logical Data Model
MSTR Desktop Architect
9. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Report Filter
2 methods to creating Facts
Attribute Forms
ETL process
10. OLTP data storage measure
The System
Gigabytes (GB)
Subtotals
2-Tier Architecture
11. Groupings of directly related attributes. Also commonly known as "dimensions".
2 types of Table Keys
Components of Compound Metrics
Hierarchies
Types of drilling
12. Enables you to select which tables from the data-warehouse to store in the Metadata database
To edit the appearance of a Graph in a report
2 types of Attribute Relationships
Warehouse Catalog
Physical Schema
13. ID columns - Description columns - Fact columns
Minimal or none
3 column types of a Physical Schema
ID form
Object Prompts
14. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
2 types of Table Keys
Compound Metric
Lookup Table structure of a completely denormalized schema
15. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Components of a Derived Metric
Heterogeneous Fact
Schema
3-Tier Architecture
16. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Lookup Tables
2 components of a Physical Schema
Metrics
17. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Report Editor
Notes
4 parts of the Project Design Process
Derived Metrics
18. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
2 components of a Physical Schema
2 types of Table Keys
Homogeneous Attribute
Application Objects
19. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
MSTR Desktop
Table Keys
Facts
5 Report display views
20. AND - OR - OR NOT - AND NOT
Report Filter operators
ETL
Facts
Banding
21. Prompts to select a single value on which to qualify a date - number or text string.
Attributes
Table Keys
Value Prompts
4 tasks of the Attribute Creation Wizard
22. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
2 types of Fact Expressions
Limitations of the Attribute Creation Wizard
Process for creating the Project Metadata
3 types of Attributes
23. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Data Pivoting
Architect Graphical Interface
Sample Metrics commonly performed on Facts
MSTR OLAP Services
24. Metrics that perform multiple aggregations; one calculation inside of another.
Stored
Objects you are allowed to Page-by
Physical Schema
Nested Metrics
25. A method of organizing the appearance of report results in a Grid report based on a criteria
Lookup Table structure of a completely normalized schema
Banding
Data Pivoting
Table Keys
26. It contains the ID and DESC columns of all higher-level attributes
Types of drilling
4 tasks of the Attribute Creation Wizard
Shortcut in MSTR Desktop
Lookup Table structure of a completely denormalized schema
27. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Compound Metric
2 types of Table Keys
Level Prompts
3 components of a Report
28. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Components of Compound Metrics
4 tasks of the Attribute Creation Wizard
Column Aliases
'View of a Report'
29. OLAP Services does not add any ______ to the report query.
New SQL
Derived Metrics
Locking and Resizing
Value Prompts
30. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Using a Search Object
Architect Graphical Interface
3 column types of a Physical Schema
Derived Attribute Expression
31. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Shortcut in MSTR Desktop
Compound Metric
Lookup Table structure of a completely denormalized schema
Outline Mode
32. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Simple Metrics
Characteristics of Nested Metrics
The 3 MSTR Tools
33. 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
Relationship Tables
Characteristics of Nested Metrics
Source system characteristics
Level Prompts
34. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
View Filters
The System
Report Subscription
Project-level options/settings
35. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Editor
Subtotals
Report Filter
'View of a Report'
36. 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
Table Keys
Drilling
Value Prompts
3 functions of Attribute Forms
37. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Report Definitions
Attribute Elements
Logical Data Model
Relationship Tables
38. Attribute Creation Wizard - Attribute Editor
Facts
2-Tier Architecture
Methods are there to creating Attributes
Level Prompts
39. The logical associations between attributes that exist based on a business rule
4 types of Prompts
Attribute Relationships
OLAP
Components of a MSTR architecture
40. Columns - Tables
ID form
Attribute Relationships
MSTR applications
2 components of a Physical Schema
41. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Relationship Tables
Facts
2 types of Table Keys
File types are allowed for exporting a Report
42. Enables you to rearrange the columns and rows in a report.
Sample Metrics commonly performed on Facts
Data Pivoting
To drill through User Hierarchies
New SQL
43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Search Object
Architect Graphical Interface
Heterogeneous Fact
44. Simple - Derived
Banding
Lookup Table structure of a completely normalized schema
Shortcut Bar
2 types of Attribute Expression
45. You must select "Other directions" when drilling attributes while viewing a report
2 types of Table Keys
Report Definitions
To drill through User Hierarchies
Report Prompts
46. All report-level options overwrite ___________.
3 Types of Objects in MSTR Desktop
The System
Project-level options/settings
Limitations of the Attribute Creation Wizard
47. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
To drill through User Hierarchies
Report Prompts
Attribute Forms
48. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Simple Attribute Expression
Notes
Components of a Metric
49. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Different methods for creating Page-by fields
To edit the appearance of a Graph in a report
Lookup Table structure of a completely normalized schema
Shortcut in MSTR Desktop
50. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Sample Metrics commonly performed on Facts
3 project creation interfaces
Search Object
Lookup Table structure of a completely denormalized schema