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. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Desktop Administrative Functions
Fact Tables
Data Pivoting
Physical Schema
2. Used for - Initially populating the Metadata - Creating schema objects
Attribute Relationships
MSTR Desktop Architect
Report Subscription
To "drill down" on a report
3. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
File > Email Reports As
Page-by
Objects you are allowed to Page-by
Report Filter
4. You must select "Other directions" when drilling attributes while viewing a report
4 parts of the Project Design Process
To drill through User Hierarchies
Very high; part of ETL process
Attributes
5. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Default Project folder structure
Report Editor
Stored
Attribute Forms
6. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
4 properties you must know in order to create attributes using the Attribute Editor
Characteristics of a Compound Table Key
Project
Lookup Table structure of a moderately denormalized schema
7. To see data at completely different levels - other than that of the original Grid or Graph
Heterogeneous Fact
Characteristics of a Compound Table Key
Drilling
Search Object
8. All report-level options overwrite ___________.
Application Objects
To create the Project connectivity
Project-level options/settings
5 steps to creating a logical data model
9. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Data Pivoting
2 ways you can configure the Project Source to connect to the Metadata database
Desktop Administrative Functions
Report Formatting
10. Specifies what info to retrieve from a data-warehouse - and how to display it
MSTR Desktop
Report Template
Outline Mode
User Hierarchies
11. OLTP retains data ________
Physical Schema
Short-term (2 - 6 months)
Outline Mode
Thresholding
12. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
ETL process
Source system characteristics
4 types of Report Filters
Tasks when defining a User Hierarchy
13. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Homogeneous Fact
Application Objects
2 types of Table Keys
14. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Shortcut Bar
Filter Definition Prompts
Objects you are allowed to Page-by
Aggregate a Metric
15. Extraction - transformation - loading
Source system characteristics
ETL
3 Methods of MSTR Desktop navigation
Characteristics of a Simple Table Key
16. Grid View - Graph View - Grid/Graph View - SQL View
4 types of Metrics
3 types of Attributes
Display views you can Print by
To drill through User Hierarchies
17. Direct: 2-tier - Server: 3-tier
3 project creation interfaces
Factors to consider when designing a logical data model
Project
2 ways you can configure the Project Source to connect to the Metadata database
18. Enables you to lock column headers so that they always appear when scrolling
Components of the Logical Data Model
Locking and Resizing
Components of a MSTR architecture
Sorting
19. Used to limit a possibly overwhelming set of potential prompt answers
To create the Project connectivity
4 properties you must know in order to create attributes using the Attribute Editor
Characteristics of Nested Metrics
Search-based prompts
20. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Filter
MSTR Desktop
Banding
3 Types of Objects in MSTR Desktop
21. OLAP retains data ________
4 parts of the Project Design Process
Page-by
Long-term (2 - 5 years)
4 properties you must know in order to create attributes using the Attribute Editor
22. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
New SQL
The System
3 Schema types
Fact Expression
23. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
3 functions of Attribute Forms
Characteristics of a Simple Table Key
MSTR OLAP Services
24. 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
Project Source
Notes
Characteristics of Nested Metrics
4 types of Prompts
25. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Project
Schema Objects
4 types of Report Filters
Rollback your changes
26. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Characteristics of a Simple Table Key
Characteristics of a Compound Table Key
2 types of Table Keys
Thresholding
27. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Attribute Creation Wizard good for
Objects you are allowed to Page-by
4 parts of the Project Design Process
Facts
28. Facts associated to different column names in 2 or more tables
Aggregate a Metric
Heterogeneous Fact
Search Object
Banding
29. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
To edit the appearance of a Graph in a report
5 steps to creating a logical data model
2 types of Facts
30. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
File types are allowed for exporting a Report
Aggregate a Metric
Subtotals
MSTR Desktop Architect
31. Facts - Attributes - Hierarchies
2-Tier Architecture
Components of a Derived Metric
Components of the Logical Data Model
Attributes
32. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Using a Search Object
Highest-level attributes
Compound Metric
View Filter
33. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Objects you are allowed to Page-by
Report Subscription
4 types of Report Filters
Components of a Derived Metric
34. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Physical Schema
To edit the appearance of a Graph in a report
Characteristics of a Compound Table Key
Source system characteristics
35. The logical associations between attributes that exist based on a business rule
OLAP
Tasks when defining a User Hierarchy
Attribute Relationships
Search Object
36. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
To create a Report Prompt
View Filter
Stored
Homogeneous Fact
37. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
New SQL
Desktop Architec
Components of Compound Metrics
Attribute or its relationship(s)
38. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Attributes
Attribute Forms
Desktop Designer
39. 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.
User Hierarchies
3 column types of a Physical Schema
Report Definitions
Using a Search Object
40. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
3 components of a Report
Components of Compound Metrics
Attributes
41. View Filters are saved with the _____________.
Attribute Creation Wizard good for
Lookup Table structure of a moderately denormalized schema
Desktop Administrative Functions
Report Definitions
42. Used to modify a Report
Application Objects
3 Methods of MSTR Desktop navigation
Report Editor
Advantage of a completely denormalized schema
43. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Derived Attribute Expression
Attribute Elements
Schema Object Editor
ID form
44. Simple - Derived
Compound Metric
Limitations of the Attribute Creation Wizard
Report Objects
2 types of Attribute Expression
45. Enables you to rearrange the columns and rows in a report.
Search-based prompts
Attribute Relationships
ETL process
Data Pivoting
46. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Attribute Elements
Shortcut in MSTR Desktop
Fact Expression
Process for creating the Project Metadata
47. Create the Project Source - Create the Database Instance
To create the Project connectivity
Heterogeneous Fact
Report Definitions
3 components of a Report
48. Filter definition prompts - Object prompts - Value prompts - Level prompts
Sample Metrics commonly performed on Facts
Heterogeneous Fact
4 types of Prompts
Lookup Tables
49. OLTP data storage measure
4 types of Metrics
Report Filter
Gigabytes (GB)
'View of a Report'
50. AND - OR - OR NOT - AND NOT
Report Filter operators
5 steps to creating a logical data model
Hierarchies
3 Schema types