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. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Object Prompts
3 project creation interfaces
Different methods for creating Page-by fields
Notes
2. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Rollback your changes
3 Methods of MSTR Desktop navigation
MSTR Desktop
3. 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
3 Schema types
Factors to consider when designing a logical data model
Minimal or none
Banding
4. Used to "fine-tune" your Project
Architect Graphical Interface
Compound Metric
Report Formatting
4 factors to consider when designing a data-warehouse schema
5. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Shortcut Bar
MSTR Connectivity Wizard
Report Prompts
Object Prompts
6. Create the Project Source - Create the Database Instance
Facts
3 components of a Report
To create the Project connectivity
Report Filter
7. Less storage - Simple SQL - Complex ETL
Long-term (2 - 5 years)
Report Filter
Characteristics of a Simple Table Key
Terabytes (TB)
8. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Tasks when defining a User Hierarchy
Components of a MSTR architecture
ID form
Attribute or its relationship(s)
9. User reporting requirements - Query performance - Data volume - DB Maintenance
Components of a Metric
4 factors to consider when designing a data-warehouse schema
Report Definitions
New SQL
10. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Locking and Resizing
Attribute Elements
Notes
11. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 options for Sorting
2 types of Attribute Relationships
Value Prompts
Table Keys
12. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
2 options for Sorting
View Filters
MSTR applications
13. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Lookup Table structure of a completely normalized schema
To qualify a Metric in a Set Qualification
4 types of Prompts
Short-term (2 - 6 months)
14. Facts associated to the same column name in 1 or more tables
4 tasks of the Attribute Creation Wizard
Limitations of the Attribute Creation Wizard
ID form
Homogeneous Fact
15. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Process for creating the Project Metadata
Desktop Designer
Attribute or its relationship(s)
16. 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
Configuration Wizard
Reference Report Objects
Types of drilling
Attribute Forms
17. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
To qualify a Metric in a Set Qualification
5 Report display views
Homogeneous Attribute
Characteristics of a Simple Table Key
18. Reduced number of JOINS in the generated SQL
Gigabytes (GB)
4 tasks of the Attribute Creation Wizard
Advantage of a completely denormalized schema
Report Template
19. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Logical Data Model
Desktop Analyst
Data warehouse characteristics
Factors to consider when designing a logical data model
20. You can e-mail reports by going to _____
To save a Report Format
Attribute Elements
File > Email Reports As
ETL process
21. Tables - Facts - Attributes - Hierarchies
Notes
2 options for Sorting
4 basic Schema objects
Filter Definition Prompts
22. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Simple Metrics
Derived Metrics
Report Template
23. ID columns - Description columns - Fact columns
Project Creation Wizard
Using a Search Object
4 types of Report Filters
3 column types of a Physical Schema
24. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Heterogeneous Attribute
By default
3 project creation interfaces
OLAP
25. Must have a one-to-one relationship with all other forms.
Gigabytes (GB)
Factors to consider when designing a logical data model
Different methods for creating Page-by fields
Attribute Forms
26. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Characteristics of a Compound Table Key
4 parts of the Project Design Process
MSTR Desktop
Project Creation Wizard
27. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Report Definitions
Project Creation Wizard
Sorting
4 properties you must know in order to create attributes using the Attribute Editor
28. It contains the ID column of the parent attribute
ETL
Report Template
Lookup Table structure of a completely normalized schema
Derived Attribute Expression
29. Used for - Initially populating the Metadata - Creating schema objects
Homogeneous Attribute
Physical Schema
Minimal or none
MSTR Desktop Architect
30. Attribute Creation Wizard - Attribute Editor
Data Pivoting
To "drill down" on a report
ETL
Methods are there to creating Attributes
31. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Subscription
MSTR Connectivity Wizard
2 types of Table Keys
Banding
32. Direct: 2-tier - Server: 3-tier
Page-by
Schema Object Editor
Terabytes (TB)
2 ways you can configure the Project Source to connect to the Metadata database
33. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Stored
Level Prompts
Minimal or none
Report Template
34. Enables you to select and display subsets of a report as separate pages.
Report Formatting
Page-by
4 properties you must know in order to create attributes using the Attribute Editor
Nested Metrics
35. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Schema Objects
Characteristics of Nested Metrics
The 3 MSTR Tools
36. User requirements - Existing source data - Technical and performance considerations
Unlimited
To create a Report Prompt
Attribute Relationships
Factors to consider when designing a logical data model
37. Specifies what info to retrieve from a data-warehouse - and how to display it
Homogeneous Fact
2 types of Facts
Report Template
Level Prompts
38. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Short-term (2 - 6 months)
New SQL
4 parts of the Project Design Process
39. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
4 tasks of the Attribute Creation Wizard
Rollback your changes
Fact Tables
40. Top menu/dropdowns - Toolbar - Right-click popup menus
2 types of Fact Expressions
Architect Graphical Interface
3 Methods of MSTR Desktop navigation
Project-level options/settings
41. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Report Formatting
The 3 MSTR Tools
Locking and Resizing
42. To define the level of aggregation for a specific metric - Used for qualifications
The 3 MSTR Tools
Drilling
Attributes
3 components of a Report
43. It contains links to specific folders in the Folder List
Subtotals
Attributes
OLAP
Shortcut Bar
44. Primary keys
Table Keys
5 Report display views
User Hierarchies
Short-term (2 - 6 months)
45. Filter definition prompts - Object prompts - Value prompts - Level prompts
3 Sections of the MSTR Desktop interface
4 types of Prompts
Long-term (2 - 5 years)
Report Objects
46. Prompts to select a single value on which to qualify a date - number or text string.
3 Types of Objects in MSTR Desktop
Report Filter
Value Prompts
To save a Report Format
47. Specifies a condition data must meet in order to be included in a report
Search Object
Report Filter
Desktop Designer
MSTR Connectivity Wizard
48. OLAP retains data ________
Lookup Tables
View Filters
Long-term (2 - 5 years)
Filter Definition Prompts
49. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Fact Expression
3 functions of Attribute Forms
Object Prompts
Lookup Tables
50. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
File > Email Reports As
Fact Tables
Attribute Elements
OLAP