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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
To drill through User Hierarchies
Hierarchies
2-Tier Architecture
Aggregate a Metric
2. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
File > Email Reports As
2 types of Attribute Relationships
Nested Metrics
3. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Short-term (2 - 6 months)
Compound Metric
Report Formatting
Homogeneous Fact
4. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
View Filter
ID form
Using a Search Object
2 types of Attribute Relationships
5. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Report Prompts
Simple Metrics
4 parts of the Project Design Process
Lookup Tables
6. Formula - Level (Dimensionality) - Conditionality - Transformation
To save a Report Format
Search Object
Project
Components of a Metric
7. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
To edit the appearance of a Graph in a report
3 types of Attributes
Column Aliases
Attribute Relationships
8. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
5 Report display views
4 types of Metrics
Minimal or none
9. 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
Desktop Designer
Cannot create project objects
2 types of Attribute Expression
Default Project folder structure
10. Homogeneous - Heterogeneous
Schema Objects
2 types of Facts
Architect Graphical Interface
3-Tier Architecture
11. Descriptive data that provides context for Facts.
Subtotals
Attribute Forms
Physical Schema
Homogeneous Attribute
12. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Schema
3 Schema types
View Filter
Gigabytes (GB)
13. 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.
Column Aliases
3 components of a Report
User Hierarchies
4 basic Schema objects
14. All Attributes must have an _______.
ID form
To drill through User Hierarchies
Search-based prompts
Report Objects
15. A feature that enables users to delivers reports to the history list - cache or mobile
Long-term (2 - 5 years)
4 types of Prompts
Lookup Tables
Report Subscription
16. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
MSTR Desktop
Report Objects
2-Tier Architecture
Objects you are allowed to Page-by
17. Facts associated to the same column name in 1 or more tables
View Filter
Homogeneous Fact
2 types of Attribute Relationships
Desktop Analyst
18. A method of organizing the appearance of report results in a Grid report based on a criteria
Lookup Table structure of a completely normalized schema
Fact Expression
Attribute Forms
Banding
19. 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.
4 parts of the Project Design Process
Object Prompts
View Filters
Attribute or its relationship(s)
20. Simple - Derived
2 types of Attribute Expression
Gigabytes (GB)
To create the Project connectivity
MSTR applications
21. 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
Report Editor
4 types of Report Filters
Terabytes (TB)
3 functions of Attribute Forms
22. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Level Prompts
New SQL
MSTR applications
Filter Definition Prompts
23. Grid View - Graph View - Grid/Graph View - SQL View
Components of a Metric
Display views you can Print by
Using a Search Object
Thresholding
24. ID columns - Description columns - Fact columns
Logical Data Model
Search Object
Fact Tables
3 column types of a Physical Schema
25. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Architect Graphical Interface
Components of a Derived Metric
To "drill down" on a report
Unlimited
26. The Attribute Form Expression that maps to a single column - no matter the number of tables
Components of Compound Metrics
Column Aliases
ETL
Simple Attribute Expression
27. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
Rollback your changes
Subtotals
Fact Tables
28. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
3 Methods of MSTR Desktop navigation
Metrics
Nested Metrics
Table Keys
29. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
'View of a Report'
Locking and Resizing
Project Creation Wizard
30. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Long-term (2 - 5 years)
Filter Definition Prompts
Data Pivoting
Application Objects
31. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
3 Methods of MSTR Desktop navigation
Aggregate a Metric
4 parts of the Project Design Process
Warehouse Catalog
32. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Aggregate a Metric
OLTP
'View of a Report'
Attribute Forms
33. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
By default
Facts
Components of the Logical Data Model
Sorting
34. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Sorting
Attribute Forms
Physical Schema
To qualify a Metric in a Set Qualification
35. Template - Filter - View of a Report
2 types of Table Keys
3 components of a Report
Process for creating the Project Metadata
Short-term (2 - 6 months)
36. Used to limit a possibly overwhelming set of potential prompt answers
Stored
Search-based prompts
Compound Metric
Architect Graphical Interface
37. 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
Types of drilling
Banding
Simple Attribute Expression
MSTR Connectivity Wizard
38. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
MSTR Desktop Architect
MSTR Desktop
2 types of Fact Expressions
39. Subtotals reflect accumulations at selected attribute levels
To create the Project connectivity
Required on the report for Outline Model to work
Subtotals
3 functions of Attribute Forms
40. Direct: 2-tier - Server: 3-tier
View Filter
Thresholding
Report Template
2 ways you can configure the Project Source to connect to the Metadata database
41. One that uses 2 or more columns as its ID
Compound Attribute
Filter Definition Prompts
Methods are there to creating Attributes
Warehouse Catalog
42. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Search Object
Process for creating the Project Metadata
Lookup Tables
Terabytes (TB)
43. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Components of a Derived Metric
ETL process
2 options for Sorting
Derived Metrics
44. It contains the ID column of the parent attribute
New SQL
Lookup Table structure of a completely normalized schema
Architect Graphical Interface
Cannot create project objects
45. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
3 components of a Report
Schema Objects
Data Pivoting
46. 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
Report Editor
3 Schema types
Desktop Designer
47. Schema Objects - Application Objects - Configuration Objects
2 components of a Physical Schema
2 types of Fact Expressions
Project
3 Types of Objects in MSTR Desktop
48. Top menu/dropdowns - Toolbar - Right-click popup menus
Types of drilling
3 Methods of MSTR Desktop navigation
MSTR applications
Long-term (2 - 5 years)
49. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Highest-level attributes
Limitations of the Attribute Creation Wizard
Project-level options/settings
50. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Outline Mode
The System
3 column types of a Physical Schema
Desktop Administrative Functions