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. The default entry-points.
OLAP
Highest-level attributes
Project Creation Wizard
MSTR Desktop Architect
2. View Filters are saved with the _____________.
Report Definitions
Desktop Designer
To save a Report Format
Attributes
3. A user interface for creating and maintaining a BI environment
Report Editor
2 types of Facts
MSTR Desktop
Data Pivoting
4. Reduced number of JOINS in the generated SQL
4 types of Prompts
Nested Metrics
Configuration Wizard
Advantage of a completely denormalized schema
5. Groupings of directly related attributes. Also commonly known as "dimensions".
Cannot create project objects
3 functions of Attribute Forms
Heterogeneous Attribute
Hierarchies
6. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Attributes
4 parts of the Project Design Process
4 basic Schema objects
Derived Attribute Expression
7. OLAP data storage measure
Homogeneous Fact
Terabytes (TB)
Homogeneous Attribute
Heterogeneous Attribute
8. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Search Object
Desktop Administrative Functions
Shortcut Bar
View Filter
9. A shortcut to an existing Object in a Project
MSTR Desktop
Warehouse Catalog
Shortcut in MSTR Desktop
3 Sections of the MSTR Desktop interface
10. Used to limit a possibly overwhelming set of potential prompt answers
Factors to consider when designing a logical data model
Search-based prompts
3 components of a Report
3 column types of a Physical Schema
11. Level of OLAP integration
Very high; part of ETL process
Components of Compound Metrics
Report Template
Using a Search Object
12. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Different methods for creating Page-by fields
Facts
Limitations of the Attribute Creation Wizard
Attributes
13. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Attribute or its relationship(s)
To edit the appearance of a Graph in a report
Metrics
Different methods for creating Page-by fields
14. View Filters can only ___________.
OLAP
Reference Report Objects
Desktop Administrative Functions
2 options for Sorting
15. User reporting requirements - Query performance - Data volume - DB Maintenance
Reports
4 factors to consider when designing a data-warehouse schema
To edit the appearance of a Graph in a report
Heterogeneous Attribute
16. Filter definition prompts - Object prompts - Value prompts - Level prompts
5 Report display views
4 types of Prompts
Methods are there to creating Attributes
Lookup Tables
17. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
Components of a MSTR architecture
4 types of Report Filters
2 types of Fact Expressions
18. It contains the ID column of all higher-level attributes
Project-level options/settings
3 Methods of MSTR Desktop navigation
Components of Compound Metrics
Lookup Table structure of a moderately denormalized schema
19. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
OLAP
3 types of Attributes
Aggregate a Metric
20. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Architect Graphical Interface
Notes
Long-term (2 - 5 years)
21. To define the level of aggregation for a specific metric - Used for qualifications
Data warehouse characteristics
To edit the appearance of a Graph in a report
Attributes
Outline Mode
22. Allow you to interact with the BI system - logically organize data to analyze complex relationships
4 tasks of the Attribute Creation Wizard
Search-based prompts
MSTR applications
MSTR Connectivity Wizard
23. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
5 steps to creating a logical data model
Source system characteristics
To save a Report Format
Reference Report Objects
24. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
By default
Lookup Tables
Schema Object Editor
Outline Mode
25. 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
4 types of Prompts
Characteristics of Nested Metrics
Report Objects
Banding
26. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
2 types of Facts
Required on the report for Outline Model to work
Object Prompts
27. Facts associated to the same column name in 1 or more tables
Metrics
Homogeneous Fact
3 functions of Attribute Forms
Components of a Metric
28. Folder List - Object Viewer - Shortcut Bar
To edit the appearance of a Graph in a report
3 Sections of the MSTR Desktop interface
Report Formatting
Unlimited
29. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Heterogeneous Attribute
Shortcut in MSTR Desktop
Thresholding
2 options for Sorting
30. Top menu/dropdowns - Toolbar - Right-click popup menus
4 types of Report Filters
3 Methods of MSTR Desktop navigation
User Hierarchies
To "drill down" on a report
31. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Lookup Table structure of a moderately denormalized schema
Notes
Schema Objects
32. What tool do you use to create the Metadata shell?
Configuration Wizard
Project Creation Wizard
Attribute Creation Wizard good for
Column Aliases
33. Must have Subtotals enabled - or you won't see any data for higher-level attributes
View Filters
Required on the report for Outline Model to work
MSTR Desktop
Sample Metrics commonly performed on Facts
34. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search-based prompts
Search Object
Desktop Analyst
4 types of Prompts
35. Used to modify a Report
Facts
Report Editor
Search Object
Attribute or its relationship(s)
36. Tables - Facts - Attributes - Hierarchies
Banding
Schema
Objects you are allowed to Page-by
4 basic Schema objects
37. 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
38. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Derived Metrics
Warehouse Catalog
3 column types of a Physical Schema
Components of a MSTR architecture
39. 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
Filter Definition Prompts
Report Filter
Default Project folder structure
Homogeneous Fact
40. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Short-term (2 - 6 months)
Project Creation Wizard
Simple Attribute Expression
The System
41. One that uses 2 or more columns as its ID
Report Formatting
Compound Attribute
Factors to consider when designing a logical data model
3 Sections of the MSTR Desktop interface
42. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
User Hierarchies
Process for creating the Project Metadata
Long-term (2 - 5 years)
43. More storage - Complex SQL - Simple ETL
Display views you can Print by
Homogeneous Attribute
Compound Metric
Characteristics of a Compound Table Key
44. You can e-mail reports by going to _____
File > Email Reports As
4 types of Report Filters
Compound Metric
MSTR applications
45. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Homogeneous Attribute
Data warehouse characteristics
Project Creation Wizard
46. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
New SQL
Rollback your changes
Lookup Table structure of a moderately denormalized schema
Filter Definition Prompts
47. Create the Project Source - Create the Database Instance
Search Object
To create the Project connectivity
Facts
Project
48. The System Hierarchy is automatically updated whenever you make a change to an __________________.
MSTR Connectivity Wizard
Attribute or its relationship(s)
4 basic Schema objects
Display views you can Print by
49. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
Types of analysis you can perform with OLAP Services
Attribute or its relationship(s)
2-Tier Architecture
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
Source system characteristics
Components of the Logical Data Model
MSTR applications
Types of drilling