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. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Fact Tables
Desktop Analyst
Report Filter
Data warehouse characteristics
2. Subtotals reflect accumulations at selected attribute levels
5 steps to creating a logical data model
Report Filter
Facts
Subtotals
3. You can e-mail reports by going to _____
Object Prompts
3 project creation interfaces
File > Email Reports As
Characteristics of a Simple Table Key
4. Level of OLTP integration
Object Prompts
Minimal or none
4 parts of the Project Design Process
Attribute Forms
5. You must select "Other directions" when drilling attributes while viewing a report
Project-level options/settings
The 3 MSTR Tools
Search-based prompts
To drill through User Hierarchies
6. View Filters can only ___________.
Facts
4 types of Metrics
3 Methods of MSTR Desktop navigation
Reference Report Objects
7. Using the Prompt Generation Wizard - Inside the Report Editor
Warehouse Catalog
Characteristics of a Compound Table Key
Unlimited
To create a Report Prompt
8. User reporting requirements - Query performance - Data volume - DB Maintenance
Characteristics of a Compound Table Key
4 factors to consider when designing a data-warehouse schema
Required on the report for Outline Model to work
Desktop Architec
9. Schema Objects - Application Objects - Configuration Objects
3 Sections of the MSTR Desktop interface
OLAP
Methods are there to creating Attributes
3 Types of Objects in MSTR Desktop
10. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Characteristics of a Simple Table Key
Sample Metrics commonly performed on Facts
3 Methods of MSTR Desktop navigation
Attribute Forms
11. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Facts
Default Project folder structure
Schema Object Editor
Characteristics of a Simple Table Key
12. All Attributes must have an _______.
ID form
'View of a Report'
Architect Graphical Interface
Report Definitions
13. Extraction - transformation - loading
Lookup Table structure of a completely denormalized schema
4 basic Schema objects
ETL
4 types of Prompts
14. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
2 options for Sorting
Shortcut in MSTR Desktop
Shortcut Bar
15. One that uses 2 or more columns as its ID
Report Filter operators
Attribute Elements
MSTR Connectivity Wizard
Compound Attribute
16. OLTP retains data ________
Short-term (2 - 6 months)
4 tasks of the Attribute Creation Wizard
Subtotals
Required on the report for Outline Model to work
17. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Source system characteristics
Components of a MSTR architecture
Column Aliases
Characteristics of Nested Metrics
18. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Search Object
4 types of Metrics
2 types of Table Keys
OLTP
19. The Attribute Form maps to different column names in multiple tables
Banding
Architect Graphical Interface
Advantage of a completely denormalized schema
Heterogeneous Attribute
20. An environment in which the MSTR Desktop connects directly to the Metadata database.
Notes
4 tasks of the Attribute Creation Wizard
2-Tier Architecture
3 functions of Attribute Forms
21. 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
Desktop Administrative Functions
Shortcut Bar
3 Schema types
Report Objects
22. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Lookup Table structure of a completely denormalized schema
To drill through User Hierarchies
3-Tier Architecture
23. Enables you to select which tables from the data-warehouse to store in the Metadata database
Data warehouse characteristics
Warehouse Catalog
Shortcut Bar
Report Filter
24. Columns - Tables
Project Source
2 components of a Physical Schema
Long-term (2 - 5 years)
Homogeneous Attribute
25. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Limitations of the Attribute Creation Wizard
To edit the appearance of a Graph in a report
ID form
Attribute Forms
26. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Page-by
ETL process
Subtotals
27. 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.
2 options for Sorting
User Hierarchies
Project
Report Objects
28. 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
29. The actual column name for a fact. Every fact must have at least 1 expression.
Notes
Fact Expression
2 options for Sorting
Components of a MSTR architecture
30. Enables you to lock column headers so that they always appear when scrolling
Search Object
Data warehouse characteristics
Locking and Resizing
Attribute Forms
31. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Report Template
2 methods to creating Facts
Object Prompts
Facts
32. Used to modify a Report
3 Schema types
Sample Metrics commonly performed on Facts
Report Editor
5 steps to creating a logical data model
33. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Long-term (2 - 5 years)
Heterogeneous Fact
To create the Project connectivity
34. Template - Filter - View of a Report
By default
Value Prompts
3 components of a Report
Terabytes (TB)
35. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
New SQL
Attribute Creation Wizard good for
Aggregate a Metric
Attribute Forms
36. Enables you to rearrange the columns and rows in a report.
Methods are there to creating Attributes
Data Pivoting
To qualify a Metric in a Set Qualification
Report Definitions
37. A shortcut to an existing Object in a Project
5 Report display views
Level Prompts
Shortcut in MSTR Desktop
Column Aliases
38. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Project Source
Report Filter operators
2 types of Fact Expressions
Report Template
39. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Desktop Administrative Functions
2 types of Fact Expressions
To qualify a Metric in a Set Qualification
40. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Thresholding
Factors to consider when designing a logical data model
Compound Metric
Report Formatting
41. Used to "fine-tune" your Project
3 functions of Attribute Forms
Architect Graphical Interface
Configuration Wizard
New SQL
42. 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.
Search Object
Logical Data Model
Facts
View Filters
43. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Outline Mode
Report Editor
MSTR Connectivity Wizard
44. A method of organizing the appearance of report results in a Grid report based on a criteria
3 types of Attributes
Banding
3 Methods of MSTR Desktop navigation
New SQL
45. Simple - Compound - Nested - Derived
Drilling
4 types of Metrics
Data warehouse characteristics
Schema Object Editor
46. Enables you to select and display subsets of a report as separate pages.
Page-by
Report Filter
Facts
Attribute Relationships
47. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Physical Schema
Stored
Object Prompts
Unlimited
48. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Attribute Elements
To edit the appearance of a Graph in a report
Nested Metrics
49. 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
Application Objects
Stored
3 Sections of the MSTR Desktop interface
50. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Page-by
To "drill down" on a report
Report Objects
2-Tier Architecture