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. 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
Table Keys
Display views you can Print by
Characteristics of Nested Metrics
Sample Metrics commonly performed on Facts
2. Creating multiple attributes quickly. Used during the initial project creation.
Unlimited
Physical Schema
Attribute Creation Wizard good for
Search-based prompts
3. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Column Aliases
Locking and Resizing
Different methods for creating Page-by fields
OLAP
4. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Stored
View Filter
2 types of Table Keys
Compound Metric
5. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Project Source
Long-term (2 - 5 years)
Desktop Analyst
6. User requirements - Existing source data - Technical and performance considerations
Attribute Creation Wizard good for
Schema
Homogeneous Attribute
Factors to consider when designing a logical data model
7. Homogeneous - Heterogeneous
Simple Attribute Expression
2 methods to creating Facts
2 types of Facts
The System
8. How users can share comments for reports to other users
Report Filter
Notes
To qualify a Metric in a Set Qualification
Required on the report for Outline Model to work
9. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
2 components of a Physical Schema
OLTP
'View of a Report'
Aggregate a Metric
10. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Attribute Relationships
Types of analysis you can perform with OLAP Services
Report Editor
Column Aliases
11. Create the Project Source - Create the Database Instance
3 column types of a Physical Schema
Desktop Administrative Functions
To create the Project connectivity
Long-term (2 - 5 years)
12. Schema Objects - Application Objects - Configuration Objects
Report Filter
MSTR Connectivity Wizard
Level Prompts
3 Types of Objects in MSTR Desktop
13. Metrics you create within a report using only those objects in the report.
Data Pivoting
Derived Metrics
Report Editor
Filter Definition Prompts
14. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
2 types of Fact Expressions
3 components of a Report
To edit the appearance of a Graph in a report
Objects you are allowed to Page-by
15. Enables you to rearrange the columns and rows in a report.
Required on the report for Outline Model to work
Components of a Derived Metric
Schema Objects
Data Pivoting
16. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
View Filter
Components of a Metric
Attribute Creation Wizard good for
ETL process
17. Level of OLAP integration
Very high; part of ETL process
The 3 MSTR Tools
OLAP
Source system characteristics
18. Metrics aggregate on the lowest-level attribute __________.
By default
3 Types of Objects in MSTR Desktop
To drill through User Hierarchies
Unlimited
19. Using the Prompt Generation Wizard - Inside the Report Editor
Characteristics of a Simple Table Key
To create a Report Prompt
4 basic Schema objects
Report Definitions
20. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
Default Project folder structure
To save a Report Format
Notes
21. A shortcut to an existing Object in a Project
Attributes
Shortcut in MSTR Desktop
Homogeneous Fact
2 options for Sorting
22. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
3-Tier Architecture
Tasks when defining a User Hierarchy
Table Keys
23. Extraction - transformation - loading
2-Tier Architecture
Metrics
2 types of Table Keys
ETL
24. Used to "fine-tune" your Project
Architect Graphical Interface
Limitations of the Attribute Creation Wizard
4 basic Schema objects
Project-level options/settings
25. Descriptive data that provides context for Facts.
Attribute Forms
Sample Metrics commonly performed on Facts
ID form
Notes
26. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Nested Metrics
Facts
Report Objects
Components of a Derived Metric
27. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
4 properties you must know in order to create attributes using the Attribute Editor
Simple Attribute Expression
5 steps to creating a logical data model
Object Prompts
28. Prompts to select a single value on which to qualify a date - number or text string.
Factors to consider when designing a logical data model
Application Objects
Value Prompts
Highest-level attributes
29. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
To create the Project connectivity
Limitations of the Attribute Creation Wizard
2 types of Attribute Relationships
30. A user interface for creating and maintaining a BI environment
Attribute Forms
MSTR Desktop
3 column types of a Physical Schema
3 functions of Attribute Forms
31. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Project
Components of a MSTR architecture
Characteristics of a Compound Table Key
To save a Report Format
32. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
4 types of Metrics
View Filter
2 types of Table Keys
Components of a Derived Metric
33. Specifies a condition data must meet in order to be included in a report
Report Filter
Characteristics of a Simple Table Key
3 Sections of the MSTR Desktop interface
MSTR Connectivity Wizard
34. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Banding
OLTP
Components of a MSTR architecture
4 types of Prompts
35. View Filters can only ___________.
Long-term (2 - 5 years)
Schema
Reference Report Objects
Level Prompts
36. Enables you to format report values based on a condition - such as highlights - font colors - etc.
3 Types of Objects in MSTR Desktop
Thresholding
OLAP
Derived Attribute Expression
37. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
2 types of Fact Expressions
Physical Schema
User Hierarchies
38. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Attribute Relationships
Attributes
Report Definitions
The 3 MSTR Tools
39. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Terabytes (TB)
Report Formatting
Report Filter
Schema Object Editor
40. 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.
Desktop Architec
Terabytes (TB)
Schema Object Editor
User Hierarchies
41. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
4 types of Metrics
File > Email Reports As
Lookup Tables
Configuration Wizard
42. A development environment to create BI applications - allowing users to edit the Metadata database
2 methods to creating Facts
Desktop Architec
Advantage of a completely denormalized schema
Project
43. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
ETL
Value Prompts
Thresholding
Facts
44. OLAP retains data ________
Long-term (2 - 5 years)
3 functions of Attribute Forms
Report Template
Report Editor
45. One that uses 2 or more columns as its ID
Simple Metrics
Different methods for creating Page-by fields
Compound Attribute
Homogeneous Attribute
46. Less storage - Simple SQL - Complex ETL
3 functions of Attribute Forms
Search Object
ETL
Characteristics of a Simple Table Key
47. Columns - Tables
Sorting
Methods are there to creating Attributes
2 components of a Physical Schema
Types of drilling
48. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Level Prompts
To drill through User Hierarchies
Minimal or none
49. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
ETL
Desktop Administrative Functions
Notes
Characteristics of a Simple Table Key
50. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
MSTR applications
2-Tier Architecture
Aggregate a Metric