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. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Level Prompts
Using a Search Object
Tasks when defining a User Hierarchy
Warehouse Catalog
2. Must have a one-to-one relationship with all other forms.
Report Template
Attribute Forms
Desktop Administrative Functions
The 3 MSTR Tools
3. The Attribute Form Expression that maps to a single column - no matter the number of tables
Attribute or its relationship(s)
Drilling
Simple Attribute Expression
3 project creation interfaces
4. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Characteristics of a Compound Table Key
Characteristics of a Simple Table Key
Desktop Designer
5. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Types of drilling
5 steps to creating a logical data model
Application Objects
6. Used for - Initially populating the Metadata - Creating schema objects
Attribute Forms
Report Subscription
MSTR Desktop Architect
Project-level options/settings
7. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLAP
Data Pivoting
Hierarchies
Page-by
8. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Report Filter
Physical Schema
Tasks when defining a User Hierarchy
Report Prompts
9. Formula - Level (Dimensionality) - Conditionality - Transformation
File > Email Reports As
'View of a Report'
Long-term (2 - 5 years)
Components of a Metric
10. How users can share comments for reports to other users
3 Types of Objects in MSTR Desktop
Derived Metrics
Notes
MSTR Desktop
11. View Filters can only ___________.
To save a Report Format
Logical Data Model
Search-based prompts
Reference Report Objects
12. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Short-term (2 - 6 months)
Components of a MSTR architecture
Source system characteristics
3 project creation interfaces
13. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
Level Prompts
3 project creation interfaces
Locking and Resizing
14. You can e-mail reports by going to _____
Application Objects
Factors to consider when designing a logical data model
File > Email Reports As
Report Subscription
15. 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
ETL
Types of drilling
'View of a Report'
To edit the appearance of a Graph in a report
16. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
To drill through User Hierarchies
Level Prompts
Hierarchies
3 Methods of MSTR Desktop navigation
17. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
3 Schema types
4 types of Report Filters
Components of Compound Metrics
To qualify a Metric in a Set Qualification
18. Using the Prompt Generation Wizard - Inside the Report Editor
Reports
Terabytes (TB)
To create a Report Prompt
Project
19. OLTP data storage measure
3 project creation interfaces
Source system characteristics
Gigabytes (GB)
3-Tier Architecture
20. A method of organizing the appearance of report results in a Grid report based on a criteria
Lookup Tables
Banding
Report Objects
2 types of Attribute Expression
21. Enables you to rearrange the columns and rows in a report.
Data Pivoting
2 types of Facts
Short-term (2 - 6 months)
Thresholding
22. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Locking and Resizing
Facts
File > Email Reports As
2 options for Sorting
23. A feature that enables users to delivers reports to the history list - cache or mobile
Limitations of the Attribute Creation Wizard
Source system characteristics
Notes
Report Subscription
24. 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.
Lookup Tables
Attribute Forms
Report Prompts
Report Editor
25. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Level Prompts
4 properties you must know in order to create attributes using the Attribute Editor
4 factors to consider when designing a data-warehouse schema
Filter Definition Prompts
26. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Lookup Table structure of a completely denormalized schema
Nested Metrics
Report Filter
Report Objects
27. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
MSTR Desktop Architect
Thresholding
5 steps to creating a logical data model
File types are allowed for exporting a Report
28. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
File > Email Reports As
Project Creation Wizard
Object Prompts
Locking and Resizing
29. A shortcut to an existing Object in a Project
2 ways you can configure the Project Source to connect to the Metadata database
Locking and Resizing
Shortcut in MSTR Desktop
Notes
30. One that uses 2 or more columns as its ID
Compound Attribute
MSTR Desktop Architect
Methods are there to creating Attributes
View Filters
31. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
4 types of Report Filters
Desktop Designer
By default
Rollback your changes
32. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Desktop Designer
Using a Search Object
3 project creation interfaces
33. Specifies a condition data must meet in order to be included in a report
Required on the report for Outline Model to work
Report Filter
3 Sections of the MSTR Desktop interface
Aggregate a Metric
34. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
5 steps to creating a logical data model
3 functions of Attribute Forms
Limitations of the Attribute Creation Wizard
View Filter
35. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Report Filter
2 types of Facts
Sample Metrics commonly performed on Facts
2 components of a Physical Schema
36. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Notes
Attributes
3-Tier Architecture
Heterogeneous Attribute
37. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
4 properties you must know in order to create attributes using the Attribute Editor
ETL
2 types of Attribute Relationships
38. Groupings of directly related attributes. Also commonly known as "dimensions".
Level Prompts
OLTP
Hierarchies
To save a Report Format
39. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
2 ways you can configure the Project Source to connect to the Metadata database
Reports
3-Tier Architecture
40. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Subtotals
MSTR OLAP Services
Different methods for creating Page-by fields
Attribute or its relationship(s)
41. Template - Filter - View of a Report
Components of a MSTR architecture
Rollback your changes
2-Tier Architecture
3 components of a Report
42. Enables you to select and display subsets of a report as separate pages.
Heterogeneous Attribute
Metrics
Tasks when defining a User Hierarchy
Page-by
43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Components of a Metric
Search-based prompts
Table Keys
44. OLAP data storage measure
ETL
Terabytes (TB)
Simple Metrics
Attributes
45. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
3-Tier Architecture
2 types of Table Keys
Cannot create project objects
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
2 types of Table Keys
Limitations of the Attribute Creation Wizard
MSTR applications
5 Report display views
47. Used to modify a Report
Report Filter operators
The 3 MSTR Tools
Report Editor
Report Subscription
48. What tool do you use to create the Metadata DSN connection?
Report Objects
Minimal or none
MSTR Connectivity Wizard
Sorting
49. A new tool for project design tasks - used for fine-tuning a project after initial creation
View Filter
To edit the appearance of a Graph in a report
Architect Graphical Interface
4 factors to consider when designing a data-warehouse schema
50. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Data Pivoting
Application Objects
Gigabytes (GB)
Search-based prompts