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. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Terabytes (TB)
Desktop Administrative Functions
4 factors to consider when designing a data-warehouse schema
Default Project folder structure
2. Columns - Tables
2 components of a Physical Schema
ETL
4 parts of the Project Design Process
Report Filter
3. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Characteristics of a Simple Table Key
Report Filter
Heterogeneous Fact
Filter Definition Prompts
4. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
To "drill down" on a report
Gigabytes (GB)
Fact Tables
5. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Shortcut in MSTR Desktop
Search Object
2 types of Table Keys
3-Tier Architecture
6. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Report Objects
Required on the report for Outline Model to work
Data warehouse characteristics
Physical Schema
7. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Sample Metrics commonly performed on Facts
Schema Object Editor
Outline Mode
2 options for Sorting
8. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 types of Attribute Expression
Metrics
Search Object
MSTR applications
9. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Fact Expression
4 properties you must know in order to create attributes using the Attribute Editor
Advantage of a completely denormalized schema
10. To define the level of aggregation for a specific metric - Used for qualifications
MSTR OLAP Services
Methods are there to creating Attributes
Sorting
Attributes
11. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Homogeneous Attribute
To edit the appearance of a Graph in a report
Simple Attribute Expression
12. Facts associated to the same column name in 1 or more tables
Logical Data Model
Notes
Types of drilling
Homogeneous Fact
13. 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
Facts
Simple Metrics
Reports
Compound Metric
14. What tool do you use to create the Metadata shell?
Report Definitions
Configuration Wizard
Desktop Architec
To create the Project connectivity
15. Homogeneous - Heterogeneous
The 3 MSTR Tools
OLAP
Terabytes (TB)
2 types of Facts
16. 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.
Gigabytes (GB)
Banding
Configuration Wizard
View Filters
17. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Report Editor
Search-based prompts
Facts
Lookup Tables
18. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
To create the Project connectivity
Physical Schema
To create a Report Prompt
4 basic Schema objects
19. To see data at completely different levels - other than that of the original Grid or Graph
Table Keys
Reference Report Objects
New SQL
Drilling
20. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Desktop Analyst
Terabytes (TB)
Report Filter
Reports
21. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Characteristics of a Simple Table Key
Minimal or none
Default Project folder structure
22. Metrics aggregate on the lowest-level attribute __________.
By default
3-Tier Architecture
To edit the appearance of a Graph in a report
4 types of Prompts
23. 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
Compound Attribute
Lookup Table structure of a completely denormalized schema
Hierarchies
24. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Configuration Wizard
File types are allowed for exporting a Report
Fact Tables
25. The Attribute Form maps to the same column name in multiple tables
Banding
Data warehouse characteristics
Homogeneous Attribute
Unlimited
26. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Application Objects
Filter Definition Prompts
To qualify a Metric in a Set Qualification
File types are allowed for exporting a Report
27. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Level Prompts
Page-by
Compound Attribute
28. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
To create the Project connectivity
User Hierarchies
Components of the Logical Data Model
OLTP
29. Template - Filter - View of a Report
Lookup Table structure of a completely normalized schema
3 components of a Report
Methods are there to creating Attributes
To save a Report Format
30. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Heterogeneous Fact
2 options for Sorting
Display views you can Print by
Report Objects
31. OLAP data storage measure
Terabytes (TB)
Report Definitions
2 options for Sorting
Lookup Table structure of a completely normalized schema
32. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Advantage of a completely denormalized schema
OLTP
Homogeneous Attribute
Thresholding
33. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
3 Methods of MSTR Desktop navigation
Schema
2 methods to creating Facts
Report Definitions
34. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Level Prompts
Desktop Analyst
Compound Metric
3 types of Attributes
35. All report-level options overwrite ___________.
Report Definitions
Project-level options/settings
Homogeneous Fact
File > Email Reports As
36. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Report Filter operators
Factors to consider when designing a logical data model
2 options for Sorting
37. A method of organizing the appearance of report results in a Grid report based on a criteria
Gigabytes (GB)
Report Template
Banding
Process for creating the Project Metadata
38. 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
2 ways you can configure the Project Source to connect to the Metadata database
3 functions of Attribute Forms
Sample Metrics commonly performed on Facts
2 types of Table Keys
39. 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
Logical Data Model
Rollback your changes
Report Definitions
40. View Filters can only ___________.
Objects you are allowed to Page-by
Derived Attribute Expression
Report Filter operators
Reference Report Objects
41. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Desktop Analyst
Minimal or none
To save a Report Format
Advantage of a completely denormalized schema
42. An environment in which the MSTR Desktop connects directly to the Metadata database.
OLTP
2-Tier Architecture
Components of Compound Metrics
File > Email Reports As
43. Tables - Facts - Attributes - Hierarchies
Factors to consider when designing a logical data model
4 basic Schema objects
To edit the appearance of a Graph in a report
Fact Tables
44. Simple - Derived
Facts
2 types of Attribute Expression
Relationship Tables
Types of drilling
45. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
2 methods to creating Facts
MSTR OLAP Services
Relationship Tables
46. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Highest-level attributes
The System
Components of a Metric
47. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Notes
Desktop Designer
Subtotals
48. Reduced number of JOINS in the generated SQL
3 Sections of the MSTR Desktop interface
Advantage of a completely denormalized schema
Data Pivoting
Report Formatting
49. 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 Fact Expressions
4 properties you must know in order to create attributes using the Attribute Editor
Architect Graphical Interface
4 types of Report Filters
50. Formula - Level (Dimensionality) - Conditionality - Transformation
Filter Definition Prompts
Components of a Metric
Table Keys
To drill through User Hierarchies