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. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Advantage of a completely denormalized schema
Display views you can Print by
Reference Report Objects
2. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
5 steps to creating a logical data model
The 3 MSTR Tools
Characteristics of a Simple Table Key
Derived Attribute Expression
3. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
Fact Tables
To drill through User Hierarchies
Types of analysis you can perform with OLAP Services
4. Simple - Compound - Nested - Derived
4 types of Metrics
Simple Attribute Expression
Reports
Terabytes (TB)
5. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
4 types of Prompts
Hierarchies
Project-level options/settings
6. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Derived Attribute Expression
Outline Mode
Homogeneous Fact
File types are allowed for exporting a Report
7. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Sorting
2 types of Table Keys
Rollback your changes
Table Keys
8. All report-level options overwrite ___________.
Project-level options/settings
Characteristics of Nested Metrics
2 types of Table Keys
MSTR Desktop
9. Formula - Level (Dimensionality) - Conditionality - Transformation
Desktop Architec
View Filters
2 types of Fact Expressions
Components of a Metric
10. Enables you to select which tables from the data-warehouse to store in the Metadata database
Report Formatting
Report Filter
Unlimited
Warehouse Catalog
11. What tool do you use to create the Metadata DSN connection?
Simple Attribute Expression
Using a Search Object
Metrics
MSTR Connectivity Wizard
12. A user interface for creating and maintaining a BI environment
Notes
Advantage of a completely denormalized schema
MSTR Desktop
Data Pivoting
13. Groupings of directly related attributes. Also commonly known as "dimensions".
MSTR Desktop Architect
Hierarchies
To "drill down" on a report
Report Template
14. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Fact Expression
Aggregate a Metric
2 types of Attribute Relationships
Data warehouse characteristics
15. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
To "drill down" on a report
Characteristics of a Simple Table Key
Report Filter
16. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Thresholding
Facts
Project Creation Wizard
Schema Objects
17. Facts - Attributes - Hierarchies
Homogeneous Attribute
Simple Metrics
Components of the Logical Data Model
Table Keys
18. OLAP retains data ________
Long-term (2 - 5 years)
Architect Graphical Interface
2 types of Attribute Relationships
To save a Report Format
19. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
MSTR Connectivity Wizard
Types of analysis you can perform with OLAP Services
Homogeneous Fact
20. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
5 Report display views
2 components of a Physical Schema
By default
21. Specifies a condition data must meet in order to be included in a report
File types are allowed for exporting a Report
Report Filter
ETL
Hierarchies
22. OLAP data storage measure
Terabytes (TB)
Outline Mode
View Filter
Report Subscription
23. Template - Filter - View of a Report
4 basic Schema objects
3 components of a Report
Locking and Resizing
Report Formatting
24. More storage - Complex SQL - Simple ETL
3-Tier Architecture
Components of the Logical Data Model
Table Keys
Characteristics of a Compound Table Key
25. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
3 Schema types
Search-based prompts
OLAP
Schema
26. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3 Methods of MSTR Desktop navigation
3-Tier Architecture
4 parts of the Project Design Process
Homogeneous Fact
27. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
4 properties you must know in order to create attributes using the Attribute Editor
Sample Metrics commonly performed on Facts
2 types of Table Keys
Process for creating the Project Metadata
28. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
3-Tier Architecture
Default Project folder structure
Application Objects
Gigabytes (GB)
29. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Sample Metrics commonly performed on Facts
Simple Metrics
OLTP
OLAP
30. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
'View of a Report'
2 ways you can configure the Project Source to connect to the Metadata database
Heterogeneous Attribute
31. Simple - Derived
User Hierarchies
2 types of Attribute Expression
Required on the report for Outline Model to work
Fact Expression
32. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Architect Graphical Interface
2 components of a Physical Schema
Logical Data Model
2 types of Attribute Relationships
33. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Default Project folder structure
Level Prompts
View Filters
Components of the Logical Data Model
34. 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
Sorting
Report Prompts
Default Project folder structure
Shortcut in MSTR Desktop
35. You must select "Other directions" when drilling attributes while viewing a report
Cannot create project objects
Lookup Table structure of a completely normalized schema
To drill through User Hierarchies
Long-term (2 - 5 years)
36. A feature that enables users to delivers reports to the history list - cache or mobile
3 Types of Objects in MSTR Desktop
Facts
Report Subscription
OLTP
37. The unique values of an attribute obtained from the data-warehouse
3 components of a Report
Schema
Factors to consider when designing a logical data model
Attribute Elements
38. Columns - Tables
Tasks when defining a User Hierarchy
2 components of a Physical Schema
Report Definitions
4 basic Schema objects
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)
Desktop Designer
OLAP
Components of Compound Metrics
Compound Metric
40. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Components of a MSTR architecture
Thresholding
Desktop Analyst
Sorting
41. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
Fact Expression
2 methods to creating Facts
Aggregate a Metric
42. Create the Project Source - Create the Database Instance
5 steps to creating a logical data model
To edit the appearance of a Graph in a report
By default
To create the Project connectivity
43. 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.
Architect Graphical Interface
Homogeneous Fact
View Filters
Limitations of the Attribute Creation Wizard
44. Must have a one-to-one relationship with all other forms.
3 Types of Objects in MSTR Desktop
Attribute Forms
Shortcut in MSTR Desktop
'View of a Report'
45. Used to modify a Report
To create a Report Prompt
Different methods for creating Page-by fields
Limitations of the Attribute Creation Wizard
Report Editor
46. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Aggregate a Metric
Using a Search Object
4 types of Metrics
3 column types of a Physical Schema
47. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
ETL process
Simple Attribute Expression
Display views you can Print by
48. 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
Project Creation Wizard
The System
3 Schema types
Lookup Table structure of a completely denormalized schema
49. 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
Table Keys
Level Prompts
Attributes
Characteristics of Nested Metrics
50. A shortcut to an existing Object in a Project
Compound Metric
Shortcut in MSTR Desktop
Types of analysis you can perform with OLAP Services
Attribute Creation Wizard good for