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. OLAP Services does not add any ______ to the report query.
File types are allowed for exporting a Report
Heterogeneous Attribute
Metrics
New SQL
2. Direct: 2-tier - Server: 3-tier
Factors to consider when designing a logical data model
2 ways you can configure the Project Source to connect to the Metadata database
MSTR Desktop Architect
The System
3. ID columns - Description columns - Fact columns
Components of a MSTR architecture
Aggregate a Metric
The 3 MSTR Tools
3 column types of a Physical Schema
4. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
ID form
Compound Metric
To create the Project connectivity
Types of analysis you can perform with OLAP Services
5. Enables you to lock column headers so that they always appear when scrolling
To drill through User Hierarchies
Locking and Resizing
To edit the appearance of a Graph in a report
Report Formatting
6. Top menu/dropdowns - Toolbar - Right-click popup menus
Factors to consider when designing a logical data model
3 Methods of MSTR Desktop navigation
Minimal or none
Heterogeneous Fact
7. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Components of the Logical Data Model
Different methods for creating Page-by fields
Hierarchies
Project Source
8. Formula - Level (Dimensionality) - Conditionality - Transformation
Homogeneous Fact
To "drill down" on a report
Lookup Table structure of a moderately denormalized schema
Components of a Metric
9. A feature that enables users to delivers reports to the history list - cache or mobile
Desktop Architec
Report Subscription
Report Prompts
4 basic Schema objects
10. It contains the ID column of all higher-level attributes
4 basic Schema objects
Report Filter
Report Definitions
Lookup Table structure of a moderately denormalized schema
11. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Compound Attribute
Schema
Table Keys
To save a Report Format
12. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Architect Graphical Interface
Data Pivoting
Components of Compound Metrics
4 parts of the Project Design Process
13. 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
5 Report display views
2-Tier Architecture
4 factors to consider when designing a data-warehouse schema
3 Schema types
14. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
3 Schema types
Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
Logical Data Model
15. The unique values of an attribute obtained from the data-warehouse
Derived Metrics
Attribute Elements
Highest-level attributes
2 types of Table Keys
16. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Highest-level attributes
3-Tier Architecture
ETL
Data warehouse characteristics
17. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Derived Metrics
Cannot create project objects
Metrics
Unlimited
18. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Nested Metrics
5 steps to creating a logical data model
4 types of Metrics
19. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
2 types of Attribute Relationships
Object Prompts
Schema Object Editor
Shortcut Bar
20. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sample Metrics commonly performed on Facts
Required on the report for Outline Model to work
Sorting
Attribute or its relationship(s)
21. Template - Filter - View of a Report
Lookup Tables
Report Editor
Banding
3 components of a Report
22. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
MSTR applications
Compound Attribute
Types of drilling
23. You must select "Other directions" when drilling attributes while viewing a report
Thresholding
To drill through User Hierarchies
Filter Definition Prompts
Physical Schema
24. Filter definition prompts - Object prompts - Value prompts - Level prompts
Lookup Tables
4 types of Prompts
Project Source
Schema
25. Descriptive data that provides context for Facts.
4 types of Prompts
5 Report display views
3 Schema types
Attribute Forms
26. To define the level of aggregation for a specific metric - Used for qualifications
2 types of Attribute Expression
Shortcut Bar
Attributes
Simple Metrics
27. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Heterogeneous Fact
Shortcut Bar
Fact Tables
ETL
28. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Simple Attribute Expression
Limitations of the Attribute Creation Wizard
MSTR applications
Attributes
29. Metrics you create within a report using only those objects in the report.
ETL
Derived Attribute Expression
Derived Metrics
4 types of Prompts
30. Facts associated to different column names in 2 or more tables
ID form
Search-based prompts
Heterogeneous Fact
Attribute or its relationship(s)
31. More storage - Complex SQL - Simple ETL
To create the Project connectivity
2 types of Fact Expressions
Characteristics of a Compound Table Key
Report Definitions
32. 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
MSTR Desktop Architect
MSTR applications
5 steps to creating a logical data model
33. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Objects you are allowed to Page-by
5 Report display views
Drilling
Components of Compound Metrics
34. OLTP retains data ________
Physical Schema
Compound Metric
Short-term (2 - 6 months)
Report Filter
35. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
View Filters
Thresholding
3 column types of a Physical Schema
36. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Value Prompts
Project
Report Editor
Sorting
37. Level of OLAP integration
Very high; part of ETL process
To create the Project connectivity
Report Formatting
Methods are there to creating Attributes
38. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Report Template
Report Objects
Reports
The System
39. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Architect Graphical Interface
Data warehouse characteristics
4 factors to consider when designing a data-warehouse schema
Facts
40. Homogeneous - Heterogeneous
Subtotals
2 types of Facts
2 types of Table Keys
Lookup Table structure of a completely denormalized schema
41. 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
2 options for Sorting
Shortcut in MSTR Desktop
3 functions of Attribute Forms
4 types of Prompts
42. 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
43. Metrics aggregate on the lowest-level attribute __________.
To edit the appearance of a Graph in a report
To create a Report Prompt
By default
Components of a Metric
44. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
The 3 MSTR Tools
Process for creating the Project Metadata
Project Creation Wizard
Reference Report Objects
45. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Nested Metrics
Report Formatting
View Filter
Report Objects
46. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Facts
To "drill down" on a report
Schema Object Editor
Different methods for creating Page-by fields
47. Store info on relationships between 2 or more tables (attributes) - like an Index table.
File > Email Reports As
Relationship Tables
Homogeneous Fact
View Filters
48. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Data warehouse characteristics
4 types of Metrics
2 types of Fact Expressions
Limitations of the Attribute Creation Wizard
49. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Report Formatting
Desktop Designer
2 ways you can configure the Project Source to connect to the Metadata database
Components of a Derived Metric
50. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
4 tasks of the Attribute Creation Wizard
Characteristics of a Simple Table Key
Column Aliases
Hierarchies