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. Extraction - transformation - loading
ETL
Simple Metrics
2 types of Facts
Reference Report Objects
2. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
MSTR OLAP Services
Metrics
2 types of Attribute Expression
3. How users can share comments for reports to other users
5 steps to creating a logical data model
Components of a Derived Metric
Facts
Notes
4. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Rollback your changes
Search Object
2-Tier Architecture
To edit the appearance of a Graph in a report
5. Used for - Initially populating the Metadata - Creating schema objects
Rollback your changes
MSTR Desktop Architect
MSTR Desktop
3 Methods of MSTR Desktop navigation
6. 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
Data Pivoting
2 options for Sorting
The 3 MSTR Tools
7. All report-level options overwrite ___________.
Components of a Derived Metric
The 3 MSTR Tools
Logical Data Model
Project-level options/settings
8. 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
To "drill down" on a report
Architect Graphical Interface
3 functions of Attribute Forms
MSTR Connectivity Wizard
9. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Types of analysis you can perform with OLAP Services
Level Prompts
Locking and Resizing
ETL process
10. Metrics aggregate on the lowest-level attribute __________.
Minimal or none
Characteristics of Nested Metrics
2 components of a Physical Schema
By default
11. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Types of analysis you can perform with OLAP Services
3 types of Attributes
2 options for Sorting
4 types of Prompts
12. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Sample Metrics commonly performed on Facts
To create the Project connectivity
Gigabytes (GB)
13. Specifies a condition data must meet in order to be included in a report
To drill through User Hierarchies
Report Filter
Report Subscription
Advantage of a completely denormalized schema
14. Used to limit a possibly overwhelming set of potential prompt answers
Factors to consider when designing a logical data model
Search-based prompts
ID form
Report Formatting
15. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Attribute or its relationship(s)
3 components of a Report
Different methods for creating Page-by fields
16. Metrics you create within a report using only those objects in the report.
Report Definitions
Factors to consider when designing a logical data model
Data Pivoting
Derived Metrics
17. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Different methods for creating Page-by fields
3 Sections of the MSTR Desktop interface
Filter Definition Prompts
Attribute Forms
18. To define the level of aggregation for a specific metric - Used for qualifications
Gigabytes (GB)
Default Project folder structure
Attributes
Objects you are allowed to Page-by
19. Facts associated to different column names in 2 or more tables
Object Prompts
Heterogeneous Fact
4 factors to consider when designing a data-warehouse schema
View Filter
20. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Locking and Resizing
Components of a Metric
2 components of a Physical Schema
Desktop Designer
21. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Prompts
Report Formatting
Facts
2 types of Table Keys
22. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Project Creation Wizard
MSTR applications
Sample Metrics commonly performed on Facts
5 steps to creating a logical data model
23. Must have a one-to-one relationship with all other forms.
Attribute Forms
ETL
Factors to consider when designing a logical data model
Desktop Analyst
24. Level of OLAP integration
5 Report display views
Notes
Project Creation Wizard
Very high; part of ETL process
25. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Required on the report for Outline Model to work
Cannot create project objects
Desktop Analyst
2 types of Attribute Expression
26. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Components of a MSTR architecture
4 parts of the Project Design Process
Report Filter operators
Hierarchies
27. Schema Objects - Application Objects - Configuration Objects
Logical Data Model
3 Types of Objects in MSTR Desktop
Derived Metrics
Search Object
28. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Table Keys
Process for creating the Project Metadata
3 Methods of MSTR Desktop navigation
4 parts of the Project Design Process
29. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Schema
3-Tier Architecture
Highest-level attributes
ETL process
30. 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
MSTR Desktop
Lookup Table structure of a moderately denormalized schema
Limitations of the Attribute Creation Wizard
Simple Metrics
31. To see data at completely different levels - other than that of the original Grid or Graph
Locking and Resizing
Heterogeneous Attribute
Drilling
Homogeneous Fact
32. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Long-term (2 - 5 years)
2 methods to creating Facts
2 types of Table Keys
33. It contains the ID column of all higher-level attributes
Derived Metrics
Report Filter operators
Lookup Table structure of a moderately denormalized schema
MSTR OLAP Services
34. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Drilling
2-Tier Architecture
View Filters
View Filter
35. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
To "drill down" on a report
Warehouse Catalog
ETL process
Column Aliases
36. What tool do you use to create the Metadata shell?
Types of analysis you can perform with OLAP Services
Configuration Wizard
Lookup Table structure of a completely denormalized schema
Objects you are allowed to Page-by
37. View Filters can only ___________.
Desktop Architec
To edit the appearance of a Graph in a report
Reference Report Objects
Short-term (2 - 6 months)
38. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
The System
To save a Report Format
File types are allowed for exporting a Report
4 basic Schema objects
39. Enables you to select which tables from the data-warehouse to store in the Metadata database
Highest-level attributes
2 components of a Physical Schema
Derived Metrics
Warehouse Catalog
40. Direct: 2-tier - Server: 3-tier
Tasks when defining a User Hierarchy
Relationship Tables
Source system characteristics
2 ways you can configure the Project Source to connect to the Metadata database
41. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Locking and Resizing
2 types of Attribute Relationships
Homogeneous Fact
2 components of a Physical Schema
42. 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
Components of a Metric
3 Schema types
Architect Graphical Interface
Report Editor
43. Formula - Level (Dimensionality) - Conditionality - Transformation
Report Subscription
2 ways you can configure the Project Source to connect to the Metadata database
Components of a Metric
Nested Metrics
44. The Attribute Form maps to the same column name in multiple tables
Project
Desktop Administrative Functions
Attribute or its relationship(s)
Homogeneous Attribute
45. A condition data must meet in order to be included in a report. Does affect the SQL.
Process for creating the Project Metadata
To save a Report Format
Report Filter
Simple Metrics
46. 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.
Report Filter operators
Report Prompts
Report Editor
3 column types of a Physical Schema
47. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 types of Facts
Reference Report Objects
2 methods to creating Facts
Derived Metrics
48. It contains links to specific folders in the Folder List
To save a Report Format
Shortcut Bar
Highest-level attributes
Report Formatting
49. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Locking and Resizing
3 project creation interfaces
Display views you can Print by
50. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Long-term (2 - 5 years)
Desktop Designer
Limitations of the Attribute Creation Wizard