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. 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
MSTR OLAP Services
4 types of Report Filters
Schema Objects
3 Methods of MSTR Desktop navigation
2. Enables you to select which tables from the data-warehouse to store in the Metadata database
Level Prompts
Warehouse Catalog
Fact Expression
Report Formatting
3. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Notes
Factors to consider when designing a logical data model
OLTP
To create the Project connectivity
4. 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
The System
Simple Attribute Expression
5. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Project
Highest-level attributes
Thresholding
6. Facts - Attributes - Hierarchies
Cannot create project objects
Components of the Logical Data Model
Project-level options/settings
MSTR Desktop
7. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Simple Metrics
To create a Report Prompt
Limitations of the Attribute Creation Wizard
Outline Mode
8. How users can share comments for reports to other users
Reports
5 steps to creating a logical data model
Notes
Desktop Analyst
9. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Subtotals
Very high; part of ETL process
Derived Attribute Expression
Unlimited
10. It contains links to specific folders in the Folder List
Homogeneous Fact
Table Keys
Shortcut Bar
Different methods for creating Page-by fields
11. 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
'View of a Report'
Types of drilling
Search-based prompts
Data warehouse characteristics
12. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Factors to consider when designing a logical data model
Source system characteristics
Advantage of a completely denormalized schema
13. OLAP data storage measure
Very high; part of ETL process
Terabytes (TB)
3 components of a Report
Compound Attribute
14. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Attribute Forms
Aggregate a Metric
Filter Definition Prompts
Facts
15. A development environment to create BI applications - allowing users to edit the Metadata database
Minimal or none
Object Prompts
Components of Compound Metrics
Desktop Architec
16. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
MSTR Connectivity Wizard
ETL process
Derived Attribute Expression
Report Prompts
17. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Lookup Tables
Characteristics of a Simple Table Key
Types of analysis you can perform with OLAP Services
18. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
3-Tier Architecture
Schema Objects
Fact Expression
19. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Subtotals
Data warehouse characteristics
Minimal or none
Report Objects
20. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Architect Graphical Interface
4 tasks of the Attribute Creation Wizard
Components of the Logical Data Model
Components of a Metric
21. 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
2 ways you can configure the Project Source to connect to the Metadata database
To drill through User Hierarchies
Stored
Characteristics of Nested Metrics
22. Homogeneous - Heterogeneous
File > Email Reports As
4 properties you must know in order to create attributes using the Attribute Editor
MSTR applications
2 types of Facts
23. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
3 components of a Report
Using a Search Object
Desktop Administrative Functions
Locking and Resizing
24. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
3 Schema types
Data warehouse characteristics
2 options for Sorting
Using a Search Object
25. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Terabytes (TB)
Attribute or its relationship(s)
Attribute Creation Wizard good for
26. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Aggregate a Metric
Schema
Lookup Table structure of a completely denormalized schema
To create a Report Prompt
27. It contains the ID and DESC columns of all higher-level attributes
Sorting
Lookup Table structure of a completely denormalized schema
2 ways you can configure the Project Source to connect to the Metadata database
Configuration Wizard
28. 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
Characteristics of a Simple Table Key
4 factors to consider when designing a data-warehouse schema
3 functions of Attribute Forms
Long-term (2 - 5 years)
29. A feature that enables users to delivers reports to the history list - cache or mobile
Page-by
Nested Metrics
5 steps to creating a logical data model
Report Subscription
30. To see data at completely different levels - other than that of the original Grid or Graph
4 factors to consider when designing a data-warehouse schema
Drilling
Attribute or its relationship(s)
2 methods to creating Facts
31. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Rollback your changes
New SQL
Tasks when defining a User Hierarchy
MSTR applications
32. The Attribute Form maps to different column names in multiple tables
Components of the Logical Data Model
Reference Report Objects
Components of Compound Metrics
Heterogeneous Attribute
33. Subtotals reflect accumulations at selected attribute levels
Compound Metric
Logical Data Model
Application Objects
Subtotals
34. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
4 basic Schema objects
Object Prompts
Lookup Table structure of a completely denormalized schema
Components of a Derived Metric
35. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Compound Metric
4 properties you must know in order to create attributes using the Attribute Editor
Reports
36. Simple - Compound - Nested - Derived
Project Creation Wizard
4 types of Metrics
Report Template
Desktop Designer
37. Metrics that perform multiple aggregations; one calculation inside of another.
4 basic Schema objects
Drilling
Nested Metrics
Different methods for creating Page-by fields
38. OLAP Services does not add any ______ to the report query.
The 3 MSTR Tools
Required on the report for Outline Model to work
Report Filter
New SQL
39. Folder List - Object Viewer - Shortcut Bar
Advantage of a completely denormalized schema
3 project creation interfaces
3 Sections of the MSTR Desktop interface
Report Filter
40. Less storage - Simple SQL - Complex ETL
Unlimited
Architect Graphical Interface
Characteristics of a Simple Table Key
MSTR OLAP Services
41. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Search Object
Drilling
Reports
Value Prompts
42. 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
Using a Search Object
Default Project folder structure
Simple Metrics
Advantage of a completely denormalized schema
43. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Characteristics of a Compound Table Key
Logical Data Model
Metrics
Subtotals
44. Specifies what info to retrieve from a data-warehouse - and how to display it
Types of analysis you can perform with OLAP Services
3 Methods of MSTR Desktop navigation
Report Template
Project-level options/settings
45. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Methods are there to creating Attributes
Desktop Analyst
Application Objects
Attribute Elements
46. AND - OR - OR NOT - AND NOT
Lookup Tables
Column Aliases
Report Filter operators
Source system characteristics
47. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Fact Tables
OLTP
Object Prompts
The System
48. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
By default
Default Project folder structure
Warehouse Catalog
49. 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
Attribute Elements
Logical Data Model
3 column types of a Physical Schema
3-Tier Architecture
50. Prompts to select a single value on which to qualify a date - number or text string.
Reference Report Objects
Metrics
Value Prompts
Hierarchies