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. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Shortcut in MSTR Desktop
Object Prompts
Configuration Wizard
Search-based prompts
2. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Facts
Application Objects
Project Source
Desktop Administrative Functions
3. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Administrative Functions
User Hierarchies
4 parts of the Project Design Process
Desktop Analyst
4. The logical associations between attributes that exist based on a business rule
Subtotals
Attribute Relationships
To drill through User Hierarchies
4 basic Schema objects
5. Enables you to format report values based on a condition - such as highlights - font colors - etc.
2-Tier Architecture
Shortcut Bar
Thresholding
Homogeneous Fact
6. 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
Desktop Administrative Functions
Attribute Elements
Derived Metrics
4 types of Report Filters
7. 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
4 types of Prompts
Simple Metrics
2 types of Attribute Relationships
Warehouse Catalog
8. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Simple Attribute Expression
Thresholding
Components of a Derived Metric
ETL process
9. What tool do you use to create the Metadata shell?
Filter Definition Prompts
2 ways you can configure the Project Source to connect to the Metadata database
Configuration Wizard
Simple Metrics
10. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Compound Metric
Hierarchies
Objects you are allowed to Page-by
Stored
11. You must select "Other directions" when drilling attributes while viewing a report
Objects you are allowed to Page-by
Highest-level attributes
Rollback your changes
To drill through User Hierarchies
12. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Required on the report for Outline Model to work
Schema Objects
3 project creation interfaces
Homogeneous Fact
13. Metrics you create within a report using only those objects in the report.
4 types of Prompts
Application Objects
Derived Metrics
Report Editor
14. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
To create the Project connectivity
ETL process
Advantage of a completely denormalized schema
Report Objects
15. Prompts to select a single value on which to qualify a date - number or text string.
4 properties you must know in order to create attributes using the Attribute Editor
Gigabytes (GB)
Value Prompts
Short-term (2 - 6 months)
16. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Display views you can Print by
Report Formatting
Relationship Tables
Schema Objects
17. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
2 components of a Physical Schema
Report Formatting
Simple Attribute Expression
18. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Advantage of a completely denormalized schema
Lookup Table structure of a moderately denormalized schema
To drill through User Hierarchies
Column Aliases
19. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Report Definitions
Shortcut in MSTR Desktop
File > Email Reports As
20. Subtotals reflect accumulations at selected attribute levels
Attribute Forms
Gigabytes (GB)
Long-term (2 - 5 years)
Subtotals
21. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Notes
Relationship Tables
Homogeneous Attribute
3-Tier Architecture
22. A condition data must meet in order to be included in a report. Does affect the SQL.
3 column types of a Physical Schema
Report Filter
Schema Object Editor
Table Keys
23. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Object Prompts
Fact Tables
To create a Report Prompt
Sorting
24. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
MSTR applications
Architect Graphical Interface
Object Prompts
Lookup Tables
25. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Default Project folder structure
Different methods for creating Page-by fields
To create the Project connectivity
Rollback your changes
26. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 options for Sorting
Outline Mode
Attribute Forms
Search Object
27. Grid View - Graph View - Grid/Graph View - SQL View
Compound Metric
To "drill down" on a report
Display views you can Print by
Stored
28. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Unlimited
2 ways you can configure the Project Source to connect to the Metadata database
'View of a Report'
29. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Data Pivoting
Default Project folder structure
Aggregate a Metric
30. Creating multiple attributes quickly. Used during the initial project creation.
Components of Compound Metrics
2 types of Attribute Expression
Attribute Creation Wizard good for
4 tasks of the Attribute Creation Wizard
31. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Minimal or none
OLAP
User Hierarchies
32. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Schema Object Editor
Using a Search Object
Nested Metrics
4 tasks of the Attribute Creation Wizard
33. Used to "fine-tune" your Project
4 types of Report Filters
3-Tier Architecture
Architect Graphical Interface
Compound Metric
34. Metrics aggregate on the lowest-level attribute __________.
Fact Expression
By default
3 Methods of MSTR Desktop navigation
Report Formatting
35. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
2 ways you can configure the Project Source to connect to the Metadata database
Locking and Resizing
Configuration Wizard
Components of a MSTR architecture
36. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Outline Mode
Page-by
Compound Attribute
2 methods to creating Facts
37. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Using a Search Object
2 options for Sorting
Simple Attribute Expression
File > Email Reports As
38. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
MSTR OLAP Services
File types are allowed for exporting a Report
ETL
4 properties you must know in order to create attributes using the Attribute 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
Schema Object Editor
Types of analysis you can perform with OLAP Services
3 Schema types
5 Report display views
40. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Data warehouse characteristics
'View of a Report'
MSTR OLAP Services
41. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Display views you can Print by
Configuration Wizard
2 types of Attribute Relationships
42. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
2 types of Table Keys
Types of analysis you can perform with OLAP Services
Schema Objects
4 types of Metrics
43. You can e-mail reports by going to _____
3 functions of Attribute Forms
2 types of Facts
File > Email Reports As
Lookup Table structure of a moderately denormalized schema
44. Homogeneous - Heterogeneous
2 types of Facts
Attribute Forms
Compound Metric
Simple Metrics
45. 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
Rollback your changes
Unlimited
Report Filter
3 functions of Attribute Forms
46. ID columns - Description columns - Fact columns
Lookup Table structure of a completely denormalized schema
3 column types of a Physical Schema
Report Prompts
Components of Compound Metrics
47. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Stored
3 Methods of MSTR Desktop navigation
OLAP
2 types of Attribute Relationships
48. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
3 Sections of the MSTR Desktop interface
Architect Graphical Interface
Methods are there to creating Attributes
49. Used for - Initially populating the Metadata - Creating schema objects
Heterogeneous Fact
To drill through User Hierarchies
MSTR Desktop Architect
Using a Search Object
50. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Source system characteristics
Level Prompts
Tasks when defining a User Hierarchy
Stored