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. OLTP retains data ________
Architect Graphical Interface
Short-term (2 - 6 months)
3 Schema types
Limitations of the Attribute Creation Wizard
2. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Fact Tables
Attribute Forms
Nested Metrics
Schema Objects
3. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Display views you can Print by
5 steps to creating a logical data model
Stored
Outline Mode
4. 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.
3 Methods of MSTR Desktop navigation
Filter Definition Prompts
User Hierarchies
Desktop Designer
5. Must have a one-to-one relationship with all other forms.
Heterogeneous Fact
Thresholding
Attribute Forms
3 Schema types
6. Level of OLTP integration
View Filter
Report Definitions
Minimal or none
Components of a Derived Metric
7. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Tasks when defining a User Hierarchy
ETL process
Long-term (2 - 5 years)
2 types of Attribute Relationships
8. A shortcut to an existing Object in a Project
Compound Attribute
Shortcut in MSTR Desktop
Characteristics of a Compound Table Key
Report Filter
9. Used to modify a Report
Methods are there to creating Attributes
Shortcut Bar
2 ways you can configure the Project Source to connect to the Metadata database
Report Editor
10. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Report Objects
Sample Metrics commonly performed on Facts
Characteristics of Nested Metrics
Desktop Analyst
11. What tool do you use to create the Metadata DSN connection?
MSTR Desktop
Advantage of a completely denormalized schema
3 components of a Report
MSTR Connectivity Wizard
12. Formula - Level (Dimensionality) - Conditionality - Transformation
Heterogeneous Attribute
Components of a Metric
Report Prompts
Homogeneous Fact
13. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2-Tier Architecture
Homogeneous Attribute
To qualify a Metric in a Set Qualification
2 options for Sorting
14. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Components of a Derived Metric
2 options for Sorting
2-Tier Architecture
Report Formatting
15. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLAP
4 factors to consider when designing a data-warehouse schema
Logical Data Model
Terabytes (TB)
16. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Very high; part of ETL process
4 types of Report Filters
Heterogeneous Fact
Process for creating the Project Metadata
17. View Filters are saved with the _____________.
Page-by
Characteristics of a Compound Table Key
Compound Metric
Report Definitions
18. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Lookup Table structure of a completely denormalized schema
MSTR Desktop Architect
Attribute Forms
Components of Compound Metrics
19. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Attribute Relationships
Objects you are allowed to Page-by
2 types of Table Keys
Very high; part of ETL process
20. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Cannot create project objects
To edit the appearance of a Graph in a report
Simple Metrics
Report Subscription
21. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
To save a Report Format
Derived Attribute Expression
Attribute or its relationship(s)
Lookup Table structure of a completely normalized schema
22. 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.
Lookup Table structure of a moderately denormalized schema
Report Prompts
2 methods to creating Facts
To edit the appearance of a Graph in a report
23. User reporting requirements - Query performance - Data volume - DB Maintenance
2 components of a Physical Schema
To drill through User Hierarchies
4 factors to consider when designing a data-warehouse schema
Shortcut in MSTR Desktop
24. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Components of a MSTR architecture
3 components of a Report
Tasks when defining a User Hierarchy
25. Prompts to select a single value on which to qualify a date - number or text string.
Report Filter
Value Prompts
View Filters
2 options for Sorting
26. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Heterogeneous Fact
Metrics
Project
27. Must have Subtotals enabled - or you won't see any data for higher-level attributes
MSTR applications
Required on the report for Outline Model to work
Heterogeneous Fact
Lookup Table structure of a completely normalized schema
28. All report-level options overwrite ___________.
Notes
Project-level options/settings
Data Pivoting
New SQL
29. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
View Filters
2 ways you can configure the Project Source to connect to the Metadata database
Project
3 project creation interfaces
30. It contains links to specific folders in the Folder List
To "drill down" on a report
Desktop Administrative Functions
Facts
Shortcut Bar
31. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Source system characteristics
Metrics
MSTR OLAP Services
2 methods to creating Facts
32. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
To edit the appearance of a Graph in a report
Highest-level attributes
Default Project folder structure
33. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
ETL process
Simple Metrics
Components of a Derived Metric
34. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Relationship Tables
Architect Graphical Interface
Using a Search Object
35. Extraction - transformation - loading
To save a Report Format
ETL
Report Prompts
Logical Data Model
36. Descriptive data that provides context for Facts.
Thresholding
Display views you can Print by
Attribute Forms
MSTR OLAP Services
37. You can e-mail reports by going to _____
2 types of Fact Expressions
File > Email Reports As
Types of drilling
Application Objects
38. Compound - Homogeneous - Heterogeneous
View Filter
Advantage of a completely denormalized schema
Reports
3 types of Attributes
39. How users can share comments for reports to other users
Notes
Different methods for creating Page-by fields
Sorting
Components of a Derived Metric
40. Simple - Compound - Nested - Derived
4 types of Metrics
Sample Metrics commonly performed on Facts
Report Filter
3 Sections of the MSTR Desktop interface
41. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
4 parts of the Project Design Process
Search-based prompts
Project Creation Wizard
MSTR OLAP Services
42. 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
To qualify a Metric in a Set Qualification
2 types of Facts
Types of analysis you can perform with OLAP Services
Report Formatting
43. It contains the ID and DESC columns of all higher-level attributes
MSTR Connectivity Wizard
Lookup Table structure of a completely denormalized schema
Subtotals
Factors to consider when designing a logical data model
44. A method of organizing the appearance of report results in a Grid report based on a criteria
Subtotals
Banding
Very high; part of ETL process
Source system characteristics
45. Used to "fine-tune" your Project
Lookup Table structure of a moderately denormalized schema
Attribute or its relationship(s)
Architect Graphical Interface
Terabytes (TB)
46. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Lookup Table structure of a completely normalized schema
Attribute Relationships
2-Tier Architecture
Aggregate a Metric
47. One that uses 2 or more columns as its ID
Compound Attribute
Filter Definition Prompts
3-Tier Architecture
Attribute Forms
48. Attribute Creation Wizard - Attribute Editor
Components of a Metric
To "drill down" on a report
Methods are there to creating Attributes
Report Filter
49. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Short-term (2 - 6 months)
Page-by
Project Source
50. Facts associated to different column names in 2 or more tables
Fact Expression
Report Objects
Schema
Heterogeneous Fact