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. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Report Filter
Project Source
Process for creating the Project Metadata
Level Prompts
2. Tables - Facts - Attributes - Hierarchies
Desktop Analyst
Locking and Resizing
Search-based prompts
4 basic Schema objects
3. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Characteristics of Nested Metrics
To "drill down" on a report
Components of a Derived Metric
Sample Metrics commonly performed on Facts
4. Metrics that perform multiple aggregations; one calculation inside of another.
3-Tier Architecture
Nested Metrics
Desktop Analyst
Notes
5. The Attribute Form maps to different column names in multiple tables
Application Objects
Heterogeneous Attribute
Report Subscription
Terabytes (TB)
6. View Filters can only ___________.
Lookup Table structure of a moderately denormalized schema
2 types of Facts
Reference Report Objects
2 types of Fact Expressions
7. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Architect Graphical Interface
Level Prompts
Components of Compound Metrics
8. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Shortcut Bar
2 options for Sorting
Lookup Tables
9. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Desktop Analyst
OLAP
Sample Metrics commonly performed on Facts
Hierarchies
10. 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
Logical Data Model
Thresholding
To create a Report Prompt
Characteristics of Nested Metrics
11. A new tool for project design tasks - used for fine-tuning a project after initial creation
Components of a Derived Metric
Fact Tables
Types of drilling
Architect Graphical Interface
12. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
4 parts of the Project Design Process
3-Tier Architecture
View Filters
2 ways you can configure the Project Source to connect to the Metadata database
13. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Facts
MSTR applications
Heterogeneous Fact
ETL process
14. It contains the ID column of all higher-level attributes
2 types of Facts
Lookup Table structure of a moderately denormalized schema
Tasks when defining a User Hierarchy
4 properties you must know in order to create attributes using the Attribute Editor
15. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Stored
Display views you can Print by
Level Prompts
Aggregate a Metric
16. 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
Simple Metrics
Metrics
Process for creating the Project Metadata
2 ways you can configure the Project Source to connect to the Metadata database
17. OLTP data storage measure
To qualify a Metric in a Set Qualification
Short-term (2 - 6 months)
Lookup Table structure of a completely normalized schema
Gigabytes (GB)
18. Specifies a condition data must meet in order to be included in a report
Report Filter
Filter Definition Prompts
Terabytes (TB)
3 functions of Attribute Forms
19. Must have a one-to-one relationship with all other forms.
Data warehouse characteristics
Homogeneous Attribute
Attribute Forms
Report Filter
20. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
4 types of Metrics
Report Template
Sample Metrics commonly performed on Facts
Report Objects
21. Groupings of directly related attributes. Also commonly known as "dimensions".
5 steps to creating a logical data model
Report Subscription
Hierarchies
OLTP
22. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Characteristics of a Compound Table Key
Project
New SQL
Cannot create project objects
23. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Attribute Relationships
5 Report display views
2 types of Fact Expressions
3 column types of a Physical Schema
24. The actual column name for a fact. Every fact must have at least 1 expression.
Facts
Unlimited
Report Filter
Fact Expression
25. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Derived Metrics
2 types of Fact Expressions
Thresholding
Physical Schema
26. Used to "fine-tune" your Project
Shortcut in MSTR Desktop
Desktop Administrative Functions
Architect Graphical Interface
2 types of Attribute Expression
27. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
3 components of a Report
Heterogeneous Fact
ETL process
Stored
28. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
To qualify a Metric in a Set Qualification
By default
The 3 MSTR Tools
Sorting
29. Attribute Creation Wizard - Attribute Editor
Gigabytes (GB)
Cannot create project objects
Methods are there to creating Attributes
Report Objects
30. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Advantage of a completely denormalized schema
3 components of a Report
Heterogeneous Attribute
Unlimited
31. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Characteristics of a Compound Table Key
Homogeneous Fact
2 options for Sorting
Configuration Wizard
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
Derived Attribute Expression
3 project creation interfaces
Nested Metrics
33. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Stored
4 types of Prompts
Lookup Tables
34. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
To edit the appearance of a Graph in a report
3 Schema types
Using a Search Object
Report Formatting
35. 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
3 column types of a Physical Schema
File types are allowed for exporting a Report
Default Project folder structure
36. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Relationship Tables
Components of a Metric
The System
37. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Components of Compound Metrics
3 Types of Objects in MSTR Desktop
ID form
Lookup Tables
38. Template - Filter - View of a Report
Project Source
Attribute Elements
3 column types of a Physical Schema
3 components of a Report
39. The logical associations between attributes that exist based on a business rule
Facts
User Hierarchies
Attribute Relationships
Data warehouse characteristics
40. Subtotals reflect accumulations at selected attribute levels
ETL
Attribute Creation Wizard good for
Column Aliases
Subtotals
41. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Facts
Desktop Designer
Locking and Resizing
Relationship Tables
42. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
2 types of Facts
Minimal or none
4 types of Report Filters
Column Aliases
43. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Characteristics of a Simple Table Key
Schema Objects
Unlimited
Shortcut Bar
44. OLAP retains data ________
To drill through User Hierarchies
Outline Mode
2-Tier Architecture
Long-term (2 - 5 years)
45. More storage - Complex SQL - Simple ETL
Report Filter
3-Tier Architecture
Aggregate a Metric
Characteristics of a Compound Table Key
46. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Attribute Forms
Warehouse Catalog
3 components of a Report
3 project creation interfaces
47. AND - OR - OR NOT - AND NOT
Level Prompts
Very high; part of ETL process
Report Filter operators
3 project creation interfaces
48. One that uses 2 or more columns as its ID
Project Source
4 tasks of the Attribute Creation Wizard
2 types of Attribute Relationships
Compound Attribute
49. It contains the ID column of the parent attribute
Heterogeneous Attribute
4 parts of the Project Design Process
To "drill down" on a report
Lookup Table structure of a completely normalized schema
50. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Types of drilling
2-Tier Architecture
Highest-level attributes
Data Pivoting