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. Used to modify a Report
File types are allowed for exporting a Report
Report Editor
To "drill down" on a report
Facts
2. What tool do you use to create the Metadata DSN connection?
Thresholding
Metrics
The 3 MSTR Tools
MSTR Connectivity Wizard
3. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Terabytes (TB)
4 types of Prompts
To edit the appearance of a Graph in a report
To "drill down" on a report
4. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Project Source
Schema
Reports
'View of a Report'
5. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
File > Email Reports As
To "drill down" on a report
Drilling
To edit the appearance of a Graph in a report
6. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Metrics
ID form
Filter Definition Prompts
7. 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
8. The System Hierarchy is automatically updated whenever you make a change to an __________________.
3 Methods of MSTR Desktop navigation
Advantage of a completely denormalized schema
Attribute or its relationship(s)
Using a Search Object
9. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Minimal or none
3 components of a Report
Advantage of a completely denormalized schema
Metrics
10. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Nested Metrics
3-Tier Architecture
To edit the appearance of a Graph in a report
Project Source
11. The Attribute Form Expression that maps to a single column - no matter the number of tables
OLTP
Simple Attribute Expression
Attribute Forms
4 factors to consider when designing a data-warehouse schema
12. View Filters are saved with the _____________.
To drill through User Hierarchies
Report Subscription
Report Definitions
Short-term (2 - 6 months)
13. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Rollback your changes
2 types of Fact Expressions
MSTR Connectivity Wizard
Project Source
14. Tables - Facts - Attributes - Hierarchies
Factors to consider when designing a logical data model
2 types of Attribute Relationships
4 basic Schema objects
Attribute or its relationship(s)
15. 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
Advantage of a completely denormalized schema
The 3 MSTR Tools
Types of drilling
16. Used to "fine-tune" your Project
Architect Graphical Interface
Attribute or its relationship(s)
Homogeneous Fact
Advantage of a completely denormalized schema
17. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
To qualify a Metric in a Set Qualification
Configuration Wizard
2 types of Table Keys
Attribute Elements
18. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
3 Sections of the MSTR Desktop interface
Desktop Administrative Functions
Components of a MSTR architecture
Fact Tables
19. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Display views you can Print by
5 steps to creating a logical data model
Facts
View Filters
20. Extraction - transformation - loading
Project
2 types of Table Keys
Derived Metrics
ETL
21. OLAP Services does not add any ______ to the report query.
Derived Metrics
3 Schema types
New SQL
Lookup Tables
22. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Characteristics of a Compound Table Key
Column Aliases
Highest-level attributes
2-Tier Architecture
23. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
4 factors to consider when designing a data-warehouse schema
2-Tier Architecture
'View of a Report'
24. The Attribute Form maps to the same column name in multiple tables
ID form
Homogeneous Attribute
Compound Metric
2 types of Fact Expressions
25. Enables you to select which tables from the data-warehouse to store in the Metadata database
Heterogeneous Attribute
Level Prompts
Warehouse Catalog
Components of a Metric
26. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Outline Mode
To save a Report Format
ETL process
To edit the appearance of a Graph in a report
27. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Characteristics of a Simple Table Key
Nested Metrics
Compound Metric
Fact Tables
28. Attribute Creation Wizard - Attribute Editor
File > Email Reports As
Methods are there to creating Attributes
User Hierarchies
Filter Definition Prompts
29. Facts associated to the same column name in 1 or more tables
Components of Compound Metrics
Report Formatting
Homogeneous Fact
Report Definitions
30. Enables you to format report values based on a condition - such as highlights - font colors - etc.
3-Tier Architecture
Report Formatting
Thresholding
Default Project folder structure
31. The default entry-points.
3 Sections of the MSTR Desktop interface
Highest-level attributes
Tasks when defining a User Hierarchy
Rollback your changes
32. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
2 types of Attribute Relationships
Lookup Tables
Simple Metrics
33. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Thresholding
To create the Project connectivity
Components of a MSTR architecture
The 3 MSTR Tools
34. Top menu/dropdowns - Toolbar - Right-click popup menus
Column Aliases
Tasks when defining a User Hierarchy
Characteristics of Nested Metrics
3 Methods of MSTR Desktop navigation
35. Used to limit a possibly overwhelming set of potential prompt answers
Desktop Analyst
Reports
Lookup Table structure of a completely denormalized schema
Search-based prompts
36. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Attribute Creation Wizard good for
Long-term (2 - 5 years)
Methods are there to creating Attributes
37. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
Rollback your changes
3 project creation interfaces
Components of a Derived Metric
38. Must have a one-to-one relationship with all other forms.
Table Keys
Attribute Forms
Warehouse Catalog
Subtotals
39. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Report Template
Different methods for creating Page-by fields
Homogeneous Attribute
40. Less storage - Simple SQL - Complex ETL
4 types of Prompts
5 steps to creating a logical data model
Attribute Elements
Characteristics of a Simple Table Key
41. 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
Project Source
Logical Data Model
Desktop Architec
Heterogeneous Fact
42. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Lookup Tables
3 Sections of the MSTR Desktop interface
To create the Project connectivity
Using a Search Object
43. 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
Attribute Relationships
Schema Object Editor
Hierarchies
44. 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 create a Report Prompt
Tasks when defining a User Hierarchy
To qualify a Metric in a Set Qualification
OLTP
45. A condition data must meet in order to be included in a report. Does affect the SQL.
Homogeneous Attribute
Report Filter
2 types of Attribute Expression
File types are allowed for exporting a Report
46. Simple - Compound - Nested - Derived
4 types of Metrics
Heterogeneous Attribute
4 basic Schema objects
Column Aliases
47. 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
Report Editor
Value Prompts
3 functions of Attribute Forms
Compound Metric
48. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
Desktop Analyst
MSTR OLAP Services
Desktop Designer
49. View Filters can only ___________.
Characteristics of a Simple Table Key
To save a Report Format
Reference Report Objects
3 types of Attributes
50. Facts - Attributes - Hierarchies
Schema
Gigabytes (GB)
MSTR Desktop
Components of the Logical Data Model