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. Facts associated to the same column name in 1 or more tables
4 basic Schema objects
Schema Object Editor
Homogeneous Fact
Column Aliases
2. It contains links to specific folders in the Folder List
5 Report display views
3 Sections of the MSTR Desktop interface
Shortcut Bar
Compound Attribute
3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 types of Attribute Relationships
4 types of Metrics
4 types of Report Filters
Search Object
4. How users can share comments for reports to other users
Project
Notes
Architect Graphical Interface
Search Object
5. Enables you to select and display subsets of a report as separate pages.
Page-by
Logical Data Model
Attribute Forms
Derived Metrics
6. More storage - Complex SQL - Simple ETL
Shortcut Bar
Characteristics of a Compound Table Key
Default Project folder structure
2 methods to creating Facts
7. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Search Object
Attribute Forms
Rollback your changes
8. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Desktop Architec
4 basic Schema objects
Fact Expression
Sample Metrics commonly performed on Facts
9. Simple - Derived
2 types of Attribute Expression
5 Report display views
2 options for Sorting
Schema
10. 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
Attribute Forms
4 types of Report Filters
2 types of Facts
2 ways you can configure the Project Source to connect to the Metadata database
11. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
MSTR OLAP Services
Components of a MSTR architecture
OLTP
Components of a Metric
12. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Schema
Components of Compound Metrics
3 column types of a Physical Schema
Tasks when defining a User Hierarchy
13. View Filters are saved with the _____________.
Configuration Wizard
Project Source
Report Definitions
Fact Tables
14. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Minimal or none
MSTR Connectivity Wizard
Lookup Table structure of a completely denormalized schema
15. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
3 types of Attributes
Drilling
Logical Data Model
16. Used to create or edit complex attributes - facts - hierarchies - and logical tables
MSTR applications
3 functions of Attribute Forms
Drilling
Schema Object Editor
17. OLAP Services does not add any ______ to the report query.
3 project creation interfaces
Long-term (2 - 5 years)
New SQL
Methods are there to creating Attributes
18. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
3 types of Attributes
Heterogeneous Fact
2 options for Sorting
Hierarchies
19. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Fact Tables
Homogeneous Attribute
To create a Report Prompt
20. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Objects you are allowed to Page-by
Physical Schema
Shortcut Bar
Desktop Administrative Functions
21. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Table Keys
2 types of Fact Expressions
4 types of Metrics
Required on the report for Outline Model to work
22. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Shortcut in MSTR Desktop
Column Aliases
Notes
23. Used to "fine-tune" your Project
Factors to consider when designing a logical data model
Types of drilling
Characteristics of a Simple Table Key
Architect Graphical Interface
24. You must select "Other directions" when drilling attributes while viewing a report
Gigabytes (GB)
Warehouse Catalog
View Filter
To drill through User Hierarchies
25. Primary keys
4 types of Report Filters
Simple Attribute Expression
Table Keys
Heterogeneous Attribute
26. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Report Editor
Cannot create project objects
To create a Report Prompt
Methods are there to creating Attributes
27. Compound - Homogeneous - Heterogeneous
Filter Definition Prompts
3 types of Attributes
2 ways you can configure the Project Source to connect to the Metadata database
Sorting
28. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
To create a Report Prompt
Filter Definition Prompts
Project Source
Report Definitions
29. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Locking and Resizing
Facts
Report Definitions
30. Using the Prompt Generation Wizard - Inside the Report Editor
Sample Metrics commonly performed on Facts
OLTP
To create a Report Prompt
Compound Metric
31. It contains the ID column of the parent attribute
Objects you are allowed to Page-by
3 Schema types
Lookup Table structure of a completely normalized schema
MSTR applications
32. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Fact Expression
Compound Attribute
Level Prompts
33. To define the level of aggregation for a specific metric - Used for qualifications
3 Schema types
Project-level options/settings
Attributes
ETL
34. The Attribute Form maps to different column names in multiple tables
Stored
User Hierarchies
Heterogeneous Attribute
Report Formatting
35. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Fact Expression
5 Report display views
Desktop Designer
Outline Mode
36. OLTP data storage measure
Factors to consider when designing a logical data model
Compound Metric
Gigabytes (GB)
Display views you can Print by
37. What tool do you use to create the Metadata shell?
Process for creating the Project Metadata
2 types of Attribute Expression
Schema
Configuration Wizard
38. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Derived Attribute Expression
MSTR OLAP Services
Desktop Analyst
Different methods for creating Page-by fields
39. Formula - Level (Dimensionality) - Conditionality - Transformation
3 Types of Objects in MSTR Desktop
Search-based prompts
Components of the Logical Data Model
Components of a Metric
40. ID columns - Description columns - Fact columns
Project Creation Wizard
3 column types of a Physical Schema
Components of a Derived Metric
Report Formatting
41. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
User Hierarchies
Lookup Table structure of a moderately denormalized schema
Derived Attribute Expression
Schema
42. Enables you to rearrange the columns and rows in a report.
Heterogeneous Attribute
Lookup Table structure of a completely denormalized schema
3 Types of Objects in MSTR Desktop
Data Pivoting
43. 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
Outline Mode
5 Report display views
Factors to consider when designing a logical data model
3 functions of Attribute Forms
44. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
4 factors to consider when designing a data-warehouse schema
3 functions of Attribute Forms
MSTR applications
45. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Objects you are allowed to Page-by
Homogeneous Attribute
2 methods to creating Facts
Very high; part of ETL process
46. Used to limit a possibly overwhelming set of potential prompt answers
Lookup Table structure of a completely denormalized schema
4 factors to consider when designing a data-warehouse schema
Search-based prompts
Report Subscription
47. Enables you to lock column headers so that they always appear when scrolling
Report Objects
Locking and Resizing
By default
Attribute Forms
48. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
4 properties you must know in order to create attributes using the Attribute Editor
Facts
Heterogeneous Attribute
49. Tables - Facts - Attributes - Hierarchies
2 ways you can configure the Project Source to connect to the Metadata database
Unlimited
4 basic Schema objects
Types of analysis you can perform with OLAP Services
50. Homogeneous - Heterogeneous
Attribute Forms
Schema Object Editor
2 types of Facts
Gigabytes (GB)