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. A condition data must meet in order to be included in a report. Does affect the SQL.
MSTR Desktop Architect
Report Filter
Warehouse Catalog
Homogeneous Attribute
2. It contains links to specific folders in the Folder List
Project-level options/settings
Required on the report for Outline Model to work
Components of Compound Metrics
Shortcut Bar
3. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
File > Email Reports As
4 properties you must know in order to create attributes using the Attribute Editor
Desktop Architec
2 ways you can configure the Project Source to connect to the Metadata database
4. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Search Object
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
5. Facts associated to the same column name in 1 or more tables
Value Prompts
Metrics
Components of a Metric
Homogeneous Fact
6. Direct: 2-tier - Server: 3-tier
File types are allowed for exporting a Report
2 ways you can configure the Project Source to connect to the Metadata database
Homogeneous Fact
Application Objects
7. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
File > Email Reports As
MSTR OLAP Services
Schema
View Filters
8. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Facts
OLTP
The System
'View of a Report'
9. User reporting requirements - Query performance - Data volume - DB Maintenance
Gigabytes (GB)
Using a Search Object
4 factors to consider when designing a data-warehouse schema
Attribute Creation Wizard good for
10. Used to limit a possibly overwhelming set of potential prompt answers
Report Prompts
Derived Attribute Expression
Search-based prompts
Sample Metrics commonly performed on Facts
11. The Attribute Form Expression that maps to a single column - no matter the number of tables
Project Creation Wizard
Simple Attribute Expression
Reference Report Objects
Unlimited
12. Groupings of directly related attributes. Also commonly known as "dimensions".
View Filter
3 functions of Attribute Forms
To create a Report Prompt
Hierarchies
13. Enables you to lock column headers so that they always appear when scrolling
3 Sections of the MSTR Desktop interface
Sorting
Locking and Resizing
4 basic Schema objects
14. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Required on the report for Outline Model to work
Table Keys
Desktop Architec
Different methods for creating Page-by fields
15. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Process for creating the Project Metadata
2 types of Attribute Expression
MSTR OLAP Services
16. Primary keys
Table Keys
Characteristics of a Compound Table Key
Desktop Architec
5 Report display views
17. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
5 steps to creating a logical data model
Heterogeneous Attribute
Cannot create project objects
Desktop Administrative Functions
18. OLTP data storage measure
Gigabytes (GB)
Project-level options/settings
4 properties you must know in order to create attributes using the Attribute Editor
Data warehouse characteristics
19. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Data Pivoting
Homogeneous Attribute
Outline Mode
20. To define the level of aggregation for a specific metric - Used for qualifications
File types are allowed for exporting a Report
Display views you can Print by
Derived Metrics
Attributes
21. Facts associated to different column names in 2 or more tables
Notes
Heterogeneous Fact
Filter Definition Prompts
Report Template
22. Used to modify a Report
Report Editor
Derived Attribute Expression
Thresholding
2 types of Attribute Relationships
23. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
3 project creation interfaces
Desktop Analyst
Types of drilling
Report Definitions
24. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
To edit the appearance of a Graph in a report
Tasks when defining a User Hierarchy
Project
Attributes
25. A subset of a report that users can manipulate without altering the SQL
26. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
Aggregate a Metric
Lookup Table structure of a moderately denormalized schema
Gigabytes (GB)
27. 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.
Banding
View Filters
Homogeneous Fact
File types are allowed for exporting a Report
28. OLAP retains data ________
Desktop Analyst
Limitations of the Attribute Creation Wizard
4 types of Metrics
Long-term (2 - 5 years)
29. Facts - Attributes - Hierarchies
Stored
Components of a Derived Metric
Components of the Logical Data Model
To create the Project connectivity
30. User requirements - Existing source data - Technical and performance considerations
ETL process
5 Report display views
Factors to consider when designing a logical data model
Search Object
31. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
2 options for Sorting
OLTP
Attribute Relationships
ETL
32. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Schema Object Editor
2 components of a Physical Schema
Using a Search Object
33. 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
Nested Metrics
3 column types of a Physical Schema
Data Pivoting
Default Project folder structure
34. A method of organizing the appearance of report results in a Grid report based on a criteria
Facts
Banding
Components of a Metric
Architect Graphical Interface
35. Simple - Derived
The System
Report Subscription
2 types of Attribute Expression
Default Project folder structure
36. How users can share comments for reports to other users
Simple Attribute Expression
Limitations of the Attribute Creation Wizard
Column Aliases
Notes
37. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
3-Tier Architecture
Column Aliases
Data warehouse characteristics
Reports
38. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Application Objects
Column Aliases
Heterogeneous Fact
Report Editor
39. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
Logical Data Model
3 Schema types
4 basic Schema objects
MSTR Desktop
40. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Derived Attribute Expression
Minimal or none
Aggregate a Metric
41. 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
ID form
2 options for Sorting
Level Prompts
Characteristics of Nested Metrics
42. Formula - Level (Dimensionality) - Conditionality - Transformation
Display views you can Print by
Components of a Metric
MSTR Desktop Architect
MSTR Connectivity Wizard
43. Descriptive data that provides context for Facts.
3 components of a Report
Attribute Forms
View Filter
Characteristics of a Simple Table Key
44. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
To edit the appearance of a Graph in a report
ETL process
Physical Schema
2 options for Sorting
45. Used to "fine-tune" your Project
Level Prompts
Compound Metric
Architect Graphical Interface
Report Template
46. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
The 3 MSTR Tools
Level Prompts
'View of a Report'
Long-term (2 - 5 years)
47. You can e-mail reports by going to _____
Compound Attribute
Long-term (2 - 5 years)
File > Email Reports As
Advantage of a completely denormalized schema
48. Prompts to select a single value on which to qualify a date - number or text string.
MSTR Connectivity Wizard
Characteristics of Nested Metrics
Value Prompts
OLTP
49. Subtotals reflect accumulations at selected attribute levels
Data warehouse characteristics
Subtotals
Page-by
ETL
50. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
Schema Objects
To create a Report Prompt
Derived Metrics