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. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Locking and Resizing
3 types of Attributes
To save a Report Format
Attribute Elements
2. The Attribute Form maps to the same column name in multiple tables
Report Definitions
Facts
Derived Metrics
Homogeneous Attribute
3. An environment in which the MSTR Desktop connects directly to the Metadata database.
Filter Definition Prompts
Default Project folder structure
Outline Mode
2-Tier Architecture
4. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
'View of a Report'
Metrics
Attributes
To "drill down" on a report
5. OLTP data storage measure
Characteristics of a Compound Table Key
Components of a Derived Metric
Gigabytes (GB)
Process for creating the Project Metadata
6. 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
3 functions of Attribute Forms
2 ways you can configure the Project Source to connect to the Metadata database
3 project creation interfaces
Homogeneous Fact
7. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
Report Prompts
3 Methods of MSTR Desktop navigation
Limitations of the Attribute Creation Wizard
8. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Attribute Elements
Highest-level attributes
'View of a Report'
Derived Attribute Expression
9. Extraction - transformation - loading
2 types of Table Keys
Configuration Wizard
ETL
Components of a Derived Metric
10. View Filters can only ___________.
Types of drilling
Thresholding
Architect Graphical Interface
Reference Report Objects
11. Enables you to select which tables from the data-warehouse to store in the Metadata database
Level Prompts
Report Filter
Very high; part of ETL process
Warehouse Catalog
12. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Subtotals
Schema Object Editor
Desktop Architec
Stored
13. What tool do you use to create the Metadata shell?
Objects you are allowed to Page-by
Drilling
Configuration Wizard
Attribute Forms
14. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
To edit the appearance of a Graph in a report
Report Definitions
Derived Attribute Expression
15. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Metrics
Report Prompts
Warehouse Catalog
16. View Filters are saved with the _____________.
Report Definitions
Configuration Wizard
4 properties you must know in order to create attributes using the Attribute Editor
Subtotals
17. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Physical Schema
3 project creation interfaces
Components of Compound Metrics
Filter Definition Prompts
18. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Tasks when defining a User Hierarchy
Object Prompts
To qualify a Metric in a Set Qualification
Report Filter
19. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
2 types of Fact Expressions
3 project creation interfaces
ID form
Reference Report Objects
20. 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
Different methods for creating Page-by fields
Search Object
21. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Lookup Table structure of a completely denormalized schema
3-Tier Architecture
4 parts of the Project Design Process
File types are allowed for exporting a Report
22. The actual column name for a fact. Every fact must have at least 1 expression.
3 types of Attributes
Fact Expression
Report Formatting
2 ways you can configure the Project Source to connect to the Metadata database
23. 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
2 options for Sorting
Search-based prompts
Table Keys
24. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
4 factors to consider when designing a data-warehouse schema
User Hierarchies
Fact Expression
2-Tier Architecture
25. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Outline Mode
Desktop Administrative Functions
Project Source
26. Columns - Tables
Project Source
Desktop Architec
2 components of a Physical Schema
Minimal or none
27. Used to limit a possibly overwhelming set of potential prompt answers
Reference Report Objects
Heterogeneous Attribute
Lookup Table structure of a completely normalized schema
Search-based prompts
28. 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
5 Report display views
Terabytes (TB)
Default Project folder structure
The System
29. Using the Prompt Generation Wizard - Inside the Report Editor
Architect Graphical Interface
To create a Report Prompt
2 ways you can configure the Project Source to connect to the Metadata database
3 Types of Objects in MSTR Desktop
30. Groupings of directly related attributes. Also commonly known as "dimensions".
Subtotals
Drilling
To create the Project connectivity
Hierarchies
31. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Table Keys
Search Object
Report Formatting
32. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Stored
ETL process
Schema Object Editor
Sample Metrics commonly performed on Facts
33. 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
To save a Report Format
Level Prompts
Report Template
Simple Metrics
34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Reports
3 Sections of the MSTR Desktop interface
Subtotals
Sorting
35. You must select "Other directions" when drilling attributes while viewing a report
Attribute Forms
New SQL
Fact Tables
To drill through User Hierarchies
36. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
3 Schema types
Project Creation Wizard
2 types of Attribute Relationships
37. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Project
File types are allowed for exporting a Report
Notes
38. A new tool for project design tasks - used for fine-tuning a project after initial creation
ETL
MSTR Desktop
Thresholding
Architect Graphical Interface
39. It contains the ID column of all higher-level attributes
MSTR Desktop Architect
Highest-level attributes
3 Types of Objects in MSTR Desktop
Lookup Table structure of a moderately denormalized schema
40. Metrics you create within a report using only those objects in the report.
Types of drilling
Attribute Forms
Derived Metrics
3 types of Attributes
41. Homogeneous - Heterogeneous
2 types of Facts
Report Subscription
4 types of Prompts
Report Filter operators
42. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Aggregate a Metric
MSTR Desktop
Types of drilling
Components of a Derived Metric
43. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
New SQL
Warehouse Catalog
2 types of Table Keys
3 project creation interfaces
44. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Desktop Analyst
3 Sections of the MSTR Desktop interface
Logical Data Model
To qualify a Metric in a Set Qualification
45. 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
Report Formatting
ETL
Default Project folder structure
3 Schema types
46. You can _____________ in the Architect Graphical Interface.
3 functions of Attribute Forms
Rollback your changes
Architect Graphical Interface
Heterogeneous Fact
47. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
MSTR Connectivity Wizard
Default Project folder structure
Relationship Tables
Report Objects
48. All Attributes must have an _______.
4 tasks of the Attribute Creation Wizard
Attribute Elements
Relationship Tables
ID form
49. 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
Metrics
4 types of Metrics
Shortcut in MSTR Desktop
4 types of Report Filters
50. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Minimal or none
Search Object
Drilling
Filter Definition Prompts