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. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Fact Tables
Relationship Tables
Objects you are allowed to Page-by
Very high; part of ETL process
2. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
4 tasks of the Attribute Creation Wizard
To create the Project connectivity
Attribute or its relationship(s)
Sample Metrics commonly performed on Facts
3. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Factors to consider when designing a logical data model
Table Keys
3 Methods of MSTR Desktop navigation
Process for creating the Project Metadata
4. The System Hierarchy is automatically updated whenever you make a change to an __________________.
2-Tier Architecture
Sorting
2 options for Sorting
Attribute or its relationship(s)
5. Columns - Tables
Homogeneous Attribute
Thresholding
2 methods to creating Facts
2 components of a Physical Schema
6. Enables you to rearrange the columns and rows in a report.
Drilling
Page-by
Data Pivoting
Subtotals
7. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
3 types of Attributes
Different methods for creating Page-by fields
2 methods to creating Facts
4 properties you must know in order to create attributes using the Attribute Editor
8. 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
Project-level options/settings
To create a Report Prompt
Data Pivoting
9. View Filters can only ___________.
Desktop Administrative Functions
To save a Report Format
Reference Report Objects
Display views you can Print by
10. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Desktop Designer
Types of analysis you can perform with OLAP Services
3 Methods of MSTR Desktop navigation
11. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Facts
Lookup Tables
View Filter
Application Objects
12. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
MSTR Desktop Architect
Application Objects
Lookup Tables
Architect Graphical Interface
13. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Very high; part of ETL process
Components of a Derived Metric
Application Objects
Components of a MSTR architecture
14. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
The 3 MSTR Tools
Report Template
Simple Metrics
Report Objects
15. OLAP Services does not add any ______ to the report query.
New SQL
Banding
Desktop Designer
OLTP
16. Prompts to select a single value on which to qualify a date - number or text string.
Thresholding
Components of the Logical Data Model
Value Prompts
The 3 MSTR Tools
17. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Report Editor
Thresholding
Unlimited
18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Using a Search Object
2 components of a Physical Schema
To save a Report Format
Architect Graphical Interface
19. More storage - Complex SQL - Simple ETL
Types of drilling
Types of analysis you can perform with OLAP Services
4 types of Metrics
Characteristics of a Compound Table Key
20. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
To create a Report Prompt
Fact Expression
Attribute Forms
21. Facts - Attributes - Hierarchies
Components of the Logical Data Model
2 types of Attribute Expression
4 types of Prompts
Factors to consider when designing a logical data model
22. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Tasks when defining a User Hierarchy
Search Object
Simple Metrics
23. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
4 types of Prompts
Schema
Report Filter
Attribute Relationships
24. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Page-by
Reference Report Objects
2 methods to creating Facts
Heterogeneous Attribute
25. It contains links to specific folders in the Folder List
To qualify a Metric in a Set Qualification
Characteristics of Nested Metrics
Report Subscription
Shortcut Bar
26. A user interface for creating and maintaining a BI environment
MSTR Desktop
Physical Schema
Filter Definition Prompts
'View of a Report'
27. Used to "fine-tune" your Project
Short-term (2 - 6 months)
The System
Different methods for creating Page-by fields
Architect Graphical Interface
28. Descriptive data that provides context for Facts.
Reference Report Objects
4 factors to consider when designing a data-warehouse schema
Attribute Forms
3 project creation interfaces
29. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
Locking and Resizing
Logical Data Model
2 types of Table Keys
30. 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-Tier Architecture
3 Sections of the MSTR Desktop interface
Methods are there to creating Attributes
31. 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
Logical Data Model
Application Objects
3 components of a Report
Characteristics of a Simple Table Key
32. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
Project-level options/settings
Facts
Different methods for creating Page-by fields
33. Direct: 2-tier - Server: 3-tier
View Filters
Components of a Derived Metric
Search Object
2 ways you can configure the Project Source to connect to the Metadata database
34. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
5 Report display views
Required on the report for Outline Model to work
Locking and Resizing
35. 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.
Attributes
Reference Report Objects
View Filters
Required on the report for Outline Model to work
36. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Characteristics of Nested Metrics
Components of a Derived Metric
Warehouse Catalog
Components of Compound Metrics
37. Creating multiple attributes quickly. Used during the initial project creation.
Process for creating the Project Metadata
Project Creation Wizard
Derived Attribute Expression
Attribute Creation Wizard good for
38. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Display views you can Print by
Components of a Metric
3 types of Attributes
39. Enables you to select and display subsets of a report as separate pages.
Objects you are allowed to Page-by
To drill through User Hierarchies
Page-by
Schema Objects
40. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Thresholding
MSTR Desktop
3 Schema types
41. Must have a one-to-one relationship with all other forms.
4 parts of the Project Design Process
MSTR Connectivity Wizard
Attribute Forms
Relationship Tables
42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Types of drilling
Tasks when defining a User Hierarchy
OLTP
Schema Objects
43. It contains the ID and DESC columns of all higher-level attributes
3 column types of a Physical Schema
Characteristics of a Compound Table Key
Lookup Table structure of a completely denormalized schema
Schema Object Editor
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
Unlimited
Components of a Metric
Short-term (2 - 6 months)
To qualify a Metric in a Set Qualification
45. The Attribute Form Expression that maps to a single column - no matter the number of tables
Aggregate a Metric
Simple Attribute Expression
Schema Object Editor
MSTR applications
46. To define the level of aggregation for a specific metric - Used for qualifications
Simple Metrics
Reference Report Objects
Nested Metrics
Attributes
47. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
2 options for Sorting
Tasks when defining a User Hierarchy
Highest-level attributes
48. Compound - Homogeneous - Heterogeneous
3 Sections of the MSTR Desktop interface
Attribute Creation Wizard good for
Outline Mode
3 types of Attributes
49. 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
Report Prompts
Compound Attribute
Default Project folder structure
File > Email Reports As
50. Level of OLTP integration
OLTP
Hierarchies
Minimal or none
Components of Compound Metrics