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. Enables you to rearrange the columns and rows in a report.
4 properties you must know in order to create attributes using the Attribute Editor
By default
Reports
Data Pivoting
2. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Banding
Aggregate a Metric
MSTR Desktop
Minimal or none
3. Metrics you create within a report using only those objects in the report.
Tasks when defining a User Hierarchy
2 types of Attribute Expression
Derived Metrics
Attribute Forms
4. Used to "fine-tune" your Project
To qualify a Metric in a Set Qualification
Nested Metrics
Architect Graphical Interface
Components of a MSTR architecture
5. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Compound Attribute
Unlimited
Level Prompts
6. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Subtotals
2 ways you can configure the Project Source to connect to the Metadata database
Shortcut in MSTR Desktop
7. View Filters are saved with the _____________.
MSTR Desktop Architect
Report Definitions
ETL
Filter Definition Prompts
8. The logical associations between attributes that exist based on a business rule
'View of a Report'
Attribute Relationships
Application Objects
Components of a Derived Metric
9. How users can share comments for reports to other users
Architect Graphical Interface
Notes
ETL process
Attribute Relationships
10. The unique values of an attribute obtained from the data-warehouse
Limitations of the Attribute Creation Wizard
Attribute Elements
To create a Report Prompt
5 Report display views
11. OLAP retains data ________
Limitations of the Attribute Creation Wizard
2-Tier Architecture
To drill through User Hierarchies
Long-term (2 - 5 years)
12. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Notes
Sorting
Factors to consider when designing a logical data model
3 components of a Report
13. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
4 basic Schema objects
OLTP
2 types of Attribute Relationships
2 options for Sorting
14. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Report Filter
Simple Metrics
Required on the report for Outline Model to work
Compound Metric
15. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
The 3 MSTR Tools
OLAP
Application Objects
16. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Logical Data Model
Objects you are allowed to Page-by
4 properties you must know in order to create attributes using the Attribute Editor
17. Primary keys
Project-level options/settings
Default Project folder structure
Table Keys
File > Email Reports As
18. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
MSTR Connectivity Wizard
2-Tier Architecture
Search Object
19. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Project Creation Wizard
Characteristics of Nested Metrics
4 types of Metrics
Using a Search Object
20. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
By default
4 properties you must know in order to create attributes using the Attribute Editor
Value Prompts
Attribute Relationships
21. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Methods are there to creating Attributes
Lookup Table structure of a completely normalized schema
Objects you are allowed to Page-by
22. 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
ETL
Lookup Table structure of a completely normalized schema
3 Types of Objects in MSTR Desktop
Default Project folder structure
23. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Reference Report Objects
Derived Attribute Expression
By default
24. The actual column name for a fact. Every fact must have at least 1 expression.
ID form
Fact Expression
2 types of Table Keys
Homogeneous Fact
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
Compound Attribute
Attribute Creation Wizard good for
Components of a Derived Metric
To create a Report Prompt
26. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
ETL
Architect Graphical Interface
Components of a Metric
Desktop Administrative Functions
27. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
2 types of Attribute Expression
4 parts of the Project Design Process
Objects you are allowed to Page-by
2 types of Facts
28. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Default Project folder structure
2 types of Fact Expressions
Different methods for creating Page-by fields
To "drill down" on a report
29. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Value Prompts
Short-term (2 - 6 months)
Attribute Forms
30. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Configuration Wizard
Fact Expression
Required on the report for Outline Model to work
Object Prompts
31. Must have a one-to-one relationship with all other forms.
Banding
OLTP
Attribute Forms
Long-term (2 - 5 years)
32. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
4 tasks of the Attribute Creation Wizard
3 Methods of MSTR Desktop navigation
Column Aliases
33. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
File types are allowed for exporting a Report
Heterogeneous Attribute
OLAP
34. Compound - Homogeneous - Heterogeneous
Notes
Limitations of the Attribute Creation Wizard
2 options for Sorting
3 types of Attributes
35. Tables - Facts - Attributes - Hierarchies
Configuration Wizard
4 basic Schema objects
MSTR Desktop Architect
MSTR Connectivity Wizard
36. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
2 options for Sorting
4 types of Prompts
To save a Report Format
37. Groupings of directly related attributes. Also commonly known as "dimensions".
By default
Hierarchies
Process for creating the Project Metadata
2 methods to creating Facts
38. Template - Filter - View of a Report
Report Objects
Derived Attribute Expression
3 components of a Report
Characteristics of a Compound Table Key
39. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Attribute Elements
Column Aliases
3 Types of Objects in MSTR Desktop
40. OLTP data storage measure
Report Filter
Gigabytes (GB)
Factors to consider when designing a logical data model
Types of analysis you can perform with OLAP Services
41. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
New SQL
Derived Attribute Expression
Data warehouse characteristics
Attribute Relationships
42. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Components of a Metric
Locking and Resizing
Notes
43. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
ETL process
The 3 MSTR Tools
4 tasks of the Attribute Creation Wizard
5 Report display views
44. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Lookup Tables
Subtotals
3-Tier Architecture
To "drill down" on a report
45. Specifies a condition data must meet in order to be included in a report
Report Filter
ETL
Facts
New SQL
46. 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
Rollback your changes
Logical Data Model
Types of drilling
To create the Project connectivity
47. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
3 column types of a Physical Schema
2 types of Table Keys
Compound Attribute
Facts
48. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Derived Attribute Expression
Column Aliases
Report Editor
Page-by
49. You can e-mail reports by going to _____
File > Email Reports As
Tasks when defining a User Hierarchy
4 basic Schema objects
2 types of Attribute Relationships
50. 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 Filter operators
3 functions of Attribute Forms
Desktop Designer
File types are allowed for exporting a Report