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. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Heterogeneous Fact
Report Subscription
Components of the Logical Data Model
2 types of Attribute Relationships
2. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Physical Schema
3 Sections of the MSTR Desktop interface
3 Schema types
3. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Column Aliases
Attribute Creation Wizard good for
Reports
By default
4. Less storage - Simple SQL - Complex ETL
Locking and Resizing
Characteristics of a Simple Table Key
Aggregate a Metric
Page-by
5. Simple - Derived
Required on the report for Outline Model to work
Search Object
2 types of Attribute Expression
Sample Metrics commonly performed on Facts
6. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
2-Tier Architecture
Configuration Wizard
By default
7. 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.
Simple Attribute Expression
Attributes
User Hierarchies
5 steps to creating a logical data model
8. It contains the ID column of all higher-level attributes
Desktop Analyst
2 types of Facts
Reports
Lookup Table structure of a moderately denormalized schema
9. Direct: 2-tier - Server: 3-tier
View Filters
2 options for Sorting
Project Creation Wizard
2 ways you can configure the Project Source to connect to the Metadata database
10. Extraction - transformation - loading
ETL
Object Prompts
Terabytes (TB)
OLTP
11. Metrics aggregate on the lowest-level attribute __________.
Fact Tables
Homogeneous Fact
By default
Stored
12. OLAP retains data ________
Long-term (2 - 5 years)
Homogeneous Attribute
Simple Metrics
Project
13. A condition data must meet in order to be included in a report. Does affect the SQL.
Components of a Derived Metric
Characteristics of a Compound Table Key
Report Filter
Warehouse Catalog
14. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Characteristics of a Simple Table Key
Project Creation Wizard
5 Report display views
15. Using the Prompt Generation Wizard - Inside the Report Editor
Short-term (2 - 6 months)
To create a Report Prompt
Highest-level attributes
2 methods to creating Facts
16. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Advantage of a completely denormalized schema
Report Objects
4 parts of the Project Design Process
17. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
4 types of Metrics
By default
Simple Metrics
18. AND - OR - OR NOT - AND NOT
Report Filter operators
5 steps to creating a logical data model
Physical Schema
Advantage of a completely denormalized schema
19. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Data warehouse characteristics
Attribute Elements
Application Objects
Sample Metrics commonly performed on Facts
20. All Attributes must have an _______.
3 functions of Attribute Forms
ID form
Cannot create project objects
Fact Expression
21. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
ID form
3 project creation interfaces
Cannot create project objects
4 parts of the Project Design Process
22. Metrics you create within a report using only those objects in the report.
Process for creating the Project Metadata
3 Methods of MSTR Desktop navigation
Lookup Table structure of a completely normalized schema
Derived Metrics
23. Reduced number of JOINS in the generated SQL
Desktop Analyst
Advantage of a completely denormalized schema
Shortcut in MSTR Desktop
Schema Object Editor
24. 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
25. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
3 Types of Objects in MSTR Desktop
Report Filter operators
2-Tier Architecture
26. Create the Project Source - Create the Database Instance
Short-term (2 - 6 months)
Locking and Resizing
Column Aliases
To create the Project connectivity
27. Level of OLAP integration
Report Definitions
Limitations of the Attribute Creation Wizard
Tasks when defining a User Hierarchy
Very high; part of ETL process
28. More storage - Complex SQL - Simple ETL
4 types of Prompts
Filter Definition Prompts
Project-level options/settings
Characteristics of a Compound Table Key
29. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
Logical Data Model
Desktop Architec
Lookup Table structure of a moderately denormalized schema
30. OLTP data storage measure
New SQL
Fact Expression
Gigabytes (GB)
Highest-level attributes
31. Folder List - Object Viewer - Shortcut Bar
Terabytes (TB)
Shortcut Bar
Report Filter
3 Sections of the MSTR Desktop interface
32. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Warehouse Catalog
Search Object
4 parts of the Project Design Process
3 Types of Objects in MSTR Desktop
33. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Data warehouse characteristics
Limitations of the Attribute Creation Wizard
Shortcut in MSTR Desktop
Fact Expression
34. To see data at completely different levels - other than that of the original Grid or Graph
3 Types of Objects in MSTR Desktop
Drilling
Minimal or none
Schema Object Editor
35. Subtotals reflect accumulations at selected attribute levels
Components of a Metric
Subtotals
To edit the appearance of a Graph in a report
Attribute Forms
36. Homogeneous - Heterogeneous
2 types of Attribute Expression
2 types of Facts
View Filter
Facts
37. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
View Filter
4 tasks of the Attribute Creation Wizard
Components of a MSTR architecture
To create a Report Prompt
38. Template - Filter - View of a Report
Homogeneous Fact
3 components of a Report
Warehouse Catalog
ETL process
39. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Shortcut Bar
Fact Tables
Application Objects
2 methods to creating Facts
40. How users can share comments for reports to other users
By default
Notes
Required on the report for Outline Model to work
Project-level options/settings
41. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
New SQL
Facts
Unlimited
2 ways you can configure the Project Source to connect to the Metadata database
42. 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.
3 Methods of MSTR Desktop navigation
Heterogeneous Fact
Schema
Report Prompts
43. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
The System
Sample Metrics commonly performed on Facts
Different methods for creating Page-by fields
Homogeneous Fact
44. To define the level of aggregation for a specific metric - Used for qualifications
Minimal or none
Report Editor
Attributes
To create a Report Prompt
45. 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
4 types of Report Filters
Highest-level attributes
Required on the report for Outline Model to work
OLTP
46. The unique values of an attribute obtained from the data-warehouse
Report Filter
Attribute Elements
4 types of Report Filters
MSTR Desktop
47. 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 Template
Attribute Creation Wizard good for
Default Project folder structure
4 parts of the Project Design Process
48. 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.
Thresholding
Gigabytes (GB)
Report Editor
View Filters
49. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Derived Attribute Expression
Components of a Metric
Derived Metrics
50. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
File types are allowed for exporting a Report
Report Filter
4 types of Prompts