SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. More storage - Complex SQL - Simple ETL
5 Report display views
Desktop Designer
Characteristics of a Compound Table Key
Attribute or its relationship(s)
2. Level of OLTP integration
The 3 MSTR Tools
4 parts of the Project Design Process
4 factors to consider when designing a data-warehouse schema
Minimal or none
3. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
New SQL
Fact Expression
Desktop Administrative Functions
Report Template
4. 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
2 methods to creating Facts
ID form
Components of a Metric
Characteristics of Nested Metrics
5. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Project
4 properties you must know in order to create attributes using the Attribute Editor
Different methods for creating Page-by fields
Default Project folder structure
6. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
4 factors to consider when designing a data-warehouse schema
Schema
2 types of Table Keys
To edit the appearance of a Graph in a report
7. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
3 Types of Objects in MSTR Desktop
Characteristics of a Simple Table Key
OLAP
8. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
4 tasks of the Attribute Creation Wizard
2 options for Sorting
Filter Definition Prompts
Report Prompts
9. One that uses 2 or more columns as its ID
3 functions of Attribute Forms
Report Objects
Compound Attribute
Metrics
10. Reduced number of JOINS in the generated SQL
Fact Tables
OLAP
Advantage of a completely denormalized schema
To "drill down" on a report
11. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Lookup Table structure of a completely denormalized schema
Tasks when defining a User Hierarchy
Schema Object Editor
Different methods for creating Page-by fields
12. Subtotals reflect accumulations at selected attribute levels
Subtotals
Object Prompts
Desktop Architec
Homogeneous Attribute
13. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Characteristics of a Compound Table Key
Homogeneous Fact
Required on the report for Outline Model to work
14. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Reports
Attribute or its relationship(s)
Sample Metrics commonly performed on Facts
View Filter
15. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Characteristics of a Compound Table Key
File > Email Reports As
To save a Report Format
MSTR Desktop Architect
16. Used to "fine-tune" your Project
Components of a Metric
Report Template
Architect Graphical Interface
Factors to consider when designing a logical data model
17. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Report Filter operators
Simple Metrics
Characteristics of a Compound Table Key
Banding
18. Compound - Homogeneous - Heterogeneous
Lookup Table structure of a moderately denormalized schema
3 types of Attributes
Report Filter operators
Subtotals
19. 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.
Page-by
User Hierarchies
Process for creating the Project Metadata
2 types of Attribute Relationships
20. Grid View - Graph View - Grid/Graph View - SQL View
4 properties you must know in order to create attributes using the Attribute Editor
Report Objects
Display views you can Print by
To edit the appearance of a Graph in a report
21. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Minimal or none
3 Methods of MSTR Desktop navigation
Default Project folder structure
Configuration Wizard
22. User requirements - Existing source data - Technical and performance considerations
Attribute Elements
Aggregate a Metric
ETL
Factors to consider when designing a logical data model
23. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Stored
4 types of Metrics
Project
3 Schema types
24. Metrics aggregate on the lowest-level attribute __________.
3-Tier Architecture
Characteristics of a Compound Table Key
Application Objects
By default
25. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Drilling
Components of Compound Metrics
Lookup Table structure of a moderately denormalized schema
OLTP
26. A subset of a report that users can manipulate without altering the SQL
27. OLTP data storage measure
Logical Data Model
3 Types of Objects in MSTR Desktop
File > Email Reports As
Gigabytes (GB)
28. Less storage - Simple SQL - Complex ETL
File > Email Reports As
Locking and Resizing
Cannot create project objects
Characteristics of a Simple Table Key
29. 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
Subtotals
View Filters
2 types of Attribute Relationships
3 Schema types
30. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
5 Report display views
Lookup Tables
Tasks when defining a User Hierarchy
Hierarchies
31. Used to limit a possibly overwhelming set of potential prompt answers
Display views you can Print by
Search-based prompts
Data warehouse characteristics
'View of a Report'
32. To define the level of aggregation for a specific metric - Used for qualifications
2 types of Attribute Relationships
Report Filter
Attributes
Search-based prompts
33. It contains links to specific folders in the Folder List
Shortcut Bar
Short-term (2 - 6 months)
Relationship Tables
Characteristics of a Simple Table Key
34. Primary keys
Terabytes (TB)
MSTR Desktop Architect
Table Keys
View Filter
35. A user interface for creating and maintaining a BI environment
Heterogeneous Fact
Filter Definition Prompts
Warehouse Catalog
MSTR Desktop
36. All report-level options overwrite ___________.
3 column types of a Physical Schema
Project-level options/settings
Using a Search Object
Schema Objects
37. An environment in which the MSTR Desktop connects directly to the Metadata database.
Compound Attribute
2-Tier Architecture
Minimal or none
3 Types of Objects in MSTR Desktop
38. A new tool for project design tasks - used for fine-tuning a project after initial creation
3 Schema types
Page-by
Architect Graphical Interface
2 methods to creating Facts
39. View Filters can only ___________.
Types of drilling
Object Prompts
Reference Report Objects
Level Prompts
40. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
4 tasks of the Attribute Creation Wizard
4 factors to consider when designing a data-warehouse schema
New SQL
41. A method of organizing the appearance of report results in a Grid report based on a criteria
Homogeneous Attribute
Banding
Object Prompts
2 options for Sorting
42. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Homogeneous Attribute
Page-by
4 types of Metrics
OLAP
43. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
2 types of Fact Expressions
Report Editor
4 tasks of the Attribute Creation Wizard
Short-term (2 - 6 months)
44. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Schema
Report Objects
Display views you can Print by
View Filter
45. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
Heterogeneous Fact
2 types of Attribute Relationships
Limitations of the Attribute Creation Wizard
46. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Notes
Search Object
Source system characteristics
47. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Physical Schema
Drilling
Very high; part of ETL process
48. Specifies what info to retrieve from a data-warehouse - and how to display it
Reports
4 types of Metrics
Attribute or its relationship(s)
Report Template
49. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To create a Report Prompt
Short-term (2 - 6 months)
Types of analysis you can perform with OLAP Services
Tasks when defining a User Hierarchy
50. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Gigabytes (GB)
Relationship Tables
Source system characteristics
Attribute Forms