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 user interface for creating and maintaining a BI environment
Column Aliases
Hierarchies
MSTR Desktop
Types of analysis you can perform with OLAP Services
2. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Lookup Tables
Reference Report Objects
Attribute Elements
Compound Metric
3. 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
Metrics
Derived Metrics
Simple Attribute Expression
4. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
4 tasks of the Attribute Creation Wizard
Object Prompts
Types of drilling
Desktop Architec
5. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
2 components of a Physical Schema
OLAP
The System
Reports
6. 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
Attribute Forms
Default Project folder structure
Report Filter
Fact Expression
7. Facts associated to the same column name in 1 or more tables
Gigabytes (GB)
Homogeneous Fact
Schema Objects
4 properties you must know in order to create attributes using the Attribute Editor
8. To define the level of aggregation for a specific metric - Used for qualifications
Attribute Forms
Attributes
2 types of Attribute Expression
MSTR OLAP Services
9. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Attribute Forms
Fact Tables
Lookup Table structure of a completely denormalized schema
MSTR applications
10. Used to "fine-tune" your Project
Different methods for creating Page-by fields
Architect Graphical Interface
Simple Attribute Expression
Methods are there to creating Attributes
11. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Fact Tables
Characteristics of a Compound Table Key
Cannot create project objects
2 options for Sorting
12. Specifies a condition data must meet in order to be included in a report
Report Filter
File types are allowed for exporting a Report
2 options for Sorting
Components of the Logical Data Model
13. 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
Advantage of a completely denormalized schema
Limitations of the Attribute Creation Wizard
4 types of Report Filters
To qualify a Metric in a Set Qualification
14. Used to limit a possibly overwhelming set of potential prompt answers
Gigabytes (GB)
Search-based prompts
Page-by
Desktop Analyst
15. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Attribute Forms
Facts
Reports
Components of a Derived Metric
16. Metrics aggregate on the lowest-level attribute __________.
Components of a Derived Metric
By default
Level Prompts
Derived Attribute Expression
17. It contains the ID and DESC columns of all higher-level attributes
Heterogeneous Attribute
3 types of Attributes
3 Schema types
Lookup Table structure of a completely denormalized schema
18. Filter definition prompts - Object prompts - Value prompts - Level prompts
Gigabytes (GB)
4 types of Prompts
Project
Reports
19. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Report Prompts
File > Email Reports As
Using a Search Object
To drill through User Hierarchies
20. It contains the ID column of the parent attribute
Table Keys
Lookup Table structure of a completely normalized schema
Process for creating the Project Metadata
To edit the appearance of a Graph in a report
21. AND - OR - OR NOT - AND NOT
Configuration Wizard
2 options for Sorting
Report Filter operators
ETL process
22. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Homogeneous Fact
Unlimited
3 Sections of the MSTR Desktop interface
23. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
4 tasks of the Attribute Creation Wizard
Project
Facts
Lookup Tables
24. Simple - Compound - Nested - Derived
Derived Metrics
Limitations of the Attribute Creation Wizard
Schema Object Editor
4 types of Metrics
25. 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
4 parts of the Project Design Process
Attribute Forms
Types of drilling
Project
26. The logical associations between attributes that exist based on a business rule
Advantage of a completely denormalized schema
Report Objects
Unlimited
Attribute Relationships
27. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
3 Methods of MSTR Desktop navigation
4 basic Schema objects
Attribute Creation Wizard good for
28. Level of OLAP integration
Characteristics of a Compound Table Key
Very high; part of ETL process
Compound Metric
4 basic Schema objects
29. View Filters are saved with the _____________.
Minimal or none
Report Editor
Report Definitions
Nested Metrics
30. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Report Template
Report Definitions
4 properties you must know in order to create attributes using the Attribute Editor
31. Specifies what info to retrieve from a data-warehouse - and how to display it
Short-term (2 - 6 months)
3 Sections of the MSTR Desktop interface
Report Template
Minimal or none
32. One that uses 2 or more columns as its ID
Display views you can Print by
Compound Attribute
Components of Compound Metrics
Short-term (2 - 6 months)
33. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
The System
Project Source
5 steps to creating a logical data model
Characteristics of a Compound Table Key
34. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Compound Metric
Banding
3 project creation interfaces
To save a Report Format
35. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
New SQL
Lookup Tables
Project
36. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Attribute Elements
Desktop Administrative Functions
Desktop Designer
Using a Search Object
37. Enables you to rearrange the columns and rows in a report.
'View of a Report'
Data Pivoting
To "drill down" on a report
Heterogeneous Fact
38. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Required on the report for Outline Model to work
Aggregate a Metric
3 Sections of the MSTR Desktop interface
Lookup Tables
39. The actual column name for a fact. Every fact must have at least 1 expression.
Report Subscription
Fact Expression
4 factors to consider when designing a data-warehouse schema
5 steps to creating a logical data model
40. All report-level options overwrite ___________.
Project-level options/settings
Simple Attribute Expression
Page-by
The 3 MSTR Tools
41. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Components of a MSTR architecture
Level Prompts
MSTR OLAP Services
Column Aliases
42. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Nested Metrics
2 components of a Physical Schema
Report Formatting
43. 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.
2 types of Attribute Expression
Notes
To "drill down" on a report
User Hierarchies
44. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Page-by
Derived Metrics
4 parts of the Project Design Process
45. Columns - Tables
Attribute Elements
2 components of a Physical Schema
2 types of Attribute Expression
User Hierarchies
46. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Data Pivoting
2 types of Facts
Different methods for creating Page-by fields
47. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
4 parts of the Project Design Process
2 methods to creating Facts
Reports
Column Aliases
48. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
4 factors to consider when designing a data-warehouse schema
Minimal or none
ID form
49. Simple - Derived
Derived Attribute Expression
MSTR Desktop
Attribute Forms
2 types of Attribute Expression
50. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Very high; part of ETL process
Outline Mode
Derived Metrics
Fact Tables