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. Extraction - transformation - loading
Report Definitions
Gigabytes (GB)
ETL
Lookup Tables
2. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Derived Attribute Expression
Facts
ETL
Using a Search Object
3. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
To create the Project connectivity
Report Template
Level Prompts
Advantage of a completely denormalized schema
4. 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
Search-based prompts
Facts
Minimal or none
Types of drilling
5. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
MSTR Connectivity Wizard
Highest-level attributes
Stored
6. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Project
Types of drilling
MSTR applications
Compound Metric
7. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Lookup Tables
Lookup Table structure of a moderately denormalized schema
File > Email Reports As
8. Enables you to format report values based on a condition - such as highlights - font colors - etc.
User Hierarchies
To drill through User Hierarchies
Thresholding
Tasks when defining a User Hierarchy
9. It contains the ID column of all higher-level attributes
Report Definitions
Lookup Table structure of a moderately denormalized schema
Shortcut in MSTR Desktop
Homogeneous Fact
10. All report-level options overwrite ___________.
Project-level options/settings
Warehouse Catalog
4 tasks of the Attribute Creation Wizard
4 types of Metrics
11. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Compound Attribute
Physical Schema
To save a Report Format
Factors to consider when designing a logical data model
12. OLTP data storage measure
3 Schema types
Application Objects
MSTR Desktop Architect
Gigabytes (GB)
13. Metrics aggregate on the lowest-level attribute __________.
To edit the appearance of a Graph in a report
3 Schema types
By default
OLTP
14. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Components of a Metric
The 3 MSTR Tools
Attribute Forms
Search Object
15. Enables you to lock column headers so that they always appear when scrolling
Reports
Characteristics of Nested Metrics
Locking and Resizing
4 tasks of the Attribute Creation Wizard
16. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
MSTR Desktop
Methods are there to creating Attributes
MSTR Connectivity Wizard
Components of a MSTR architecture
17. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Compound Attribute
Project
Shortcut Bar
18. What tool do you use to create the Metadata DSN connection?
Short-term (2 - 6 months)
4 factors to consider when designing a data-warehouse schema
MSTR Connectivity Wizard
2 types of Facts
19. Used to "fine-tune" your Project
2 types of Table Keys
Architect Graphical Interface
To edit the appearance of a Graph in a report
Limitations of the Attribute Creation Wizard
20. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Attribute Forms
Metrics
Search-based prompts
Lookup Table structure of a moderately denormalized schema
21. OLAP Services does not add any ______ to the report query.
2 types of Table Keys
2 types of Attribute Relationships
New SQL
Desktop Architec
22. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Architect Graphical Interface
Attribute Elements
Attribute Relationships
23. Metrics you create within a report using only those objects in the report.
MSTR applications
2 types of Table Keys
Derived Metrics
OLAP
24. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Minimal or none
Components of Compound Metrics
Required on the report for Outline Model to work
The 3 MSTR Tools
25. You can e-mail reports by going to _____
File > Email Reports As
Reports
Limitations of the Attribute Creation Wizard
Lookup Table structure of a moderately denormalized schema
26. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Types of drilling
Object Prompts
Attribute Forms
Advantage of a completely denormalized schema
27. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Derived Attribute Expression
Notes
Configuration Wizard
3-Tier Architecture
28. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Terabytes (TB)
2-Tier Architecture
Sorting
Data warehouse characteristics
29. Descriptive data that provides context for Facts.
3 Schema types
3 column types of a Physical Schema
Characteristics of a Compound Table Key
Attribute Forms
30. Tables - Facts - Attributes - Hierarchies
Source system characteristics
4 basic Schema objects
To save a Report Format
Limitations of the Attribute Creation Wizard
31. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Logical Data Model
Advantage of a completely denormalized schema
Data Pivoting
32. Used to modify a Report
Shortcut in MSTR Desktop
Short-term (2 - 6 months)
Report Editor
Lookup Table structure of a completely normalized schema
33. 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
MSTR applications
Desktop Analyst
3 Schema types
2 types of Attribute Expression
34. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Aggregate a Metric
Fact Tables
2 components of a Physical Schema
To create a Report Prompt
35. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
File > Email Reports As
'View of a Report'
5 steps to creating a logical data model
To create a Report Prompt
36. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Components of a Metric
Tasks when defining a User Hierarchy
Unlimited
3 project creation interfaces
37. Enables you to select and display subsets of a report as separate pages.
Required on the report for Outline Model to work
Highest-level attributes
Characteristics of Nested Metrics
Page-by
38. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
4 tasks of the Attribute Creation Wizard
Gigabytes (GB)
Derived Attribute Expression
Drilling
39. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Object Prompts
2 options for Sorting
Attribute Creation Wizard good for
40. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Facts
Lookup Tables
3 Methods of MSTR Desktop navigation
The 3 MSTR Tools
41. A user interface for creating and maintaining a BI environment
To create a Report Prompt
Reference Report Objects
MSTR Desktop
The System
42. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Search Object
Unlimited
Report Filter operators
Lookup Table structure of a completely normalized schema
43. How users can share comments for reports to other users
Metrics
Notes
File types are allowed for exporting a Report
Architect Graphical Interface
44. All Attributes must have an _______.
ID form
Very high; part of ETL process
Attribute Forms
The System
45. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
MSTR Desktop
Fact Expression
3 Methods of MSTR Desktop navigation
File types are allowed for exporting a Report
46. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Report Prompts
Attribute or its relationship(s)
Report Template
Simple Attribute Expression
47. Homogeneous - Heterogeneous
Characteristics of Nested Metrics
Using a Search Object
2 types of Facts
Outline Mode
48. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
4 factors to consider when designing a data-warehouse schema
Search Object
Components of a Derived Metric
49. Using the Prompt Generation Wizard - Inside the Report Editor
Application Objects
To create a Report Prompt
Lookup Tables
Limitations of the Attribute Creation Wizard
50. Level of OLAP integration
Very high; part of ETL process
Shortcut Bar
Level Prompts
Methods are there to creating Attributes