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. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Aggregate a Metric
Report Definitions
3 Schema types
2. 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
4 factors to consider when designing a data-warehouse schema
Very high; part of ETL process
Application Objects
3. Schema Objects - Application Objects - Configuration Objects
Data warehouse characteristics
Tasks when defining a User Hierarchy
3 Types of Objects in MSTR Desktop
'View of a Report'
4. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
3 types of Attributes
Characteristics of a Compound Table Key
Advantage of a completely denormalized schema
Outline Mode
5. Enables you to select and display subsets of a report as separate pages.
Page-by
Desktop Architec
Highest-level attributes
Compound Metric
6. All Attributes must have an _______.
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of Nested Metrics
Rollback your changes
ID form
7. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Types of analysis you can perform with OLAP Services
To "drill down" on a report
File types are allowed for exporting a Report
Desktop Designer
8. A new tool for project design tasks - used for fine-tuning a project after initial creation
Different methods for creating Page-by fields
Architect Graphical Interface
Report Definitions
Display views you can Print by
9. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
3 Schema types
4 properties you must know in order to create attributes using the Attribute Editor
Search-based prompts
10. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
File > Email Reports As
Compound Attribute
Shortcut in MSTR Desktop
The 3 MSTR Tools
11. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Objects you are allowed to Page-by
4 parts of the Project Design Process
Advantage of a completely denormalized schema
Components of a MSTR architecture
12. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Report Template
To save a Report Format
Metrics
Attribute Creation Wizard good for
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
4 parts of the Project Design Process
4 types of Report Filters
3 Sections of the MSTR Desktop interface
The System
14. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Advantage of a completely denormalized schema
Attribute Forms
Stored
Required on the report for Outline Model to work
15. OLTP retains data ________
Short-term (2 - 6 months)
3 Sections of the MSTR Desktop interface
Attribute Creation Wizard good for
2-Tier Architecture
16. OLAP data storage measure
Types of drilling
Cannot create project objects
Terabytes (TB)
Sorting
17. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Notes
4 basic Schema objects
Attribute Forms
Physical Schema
18. Used to modify a Report
Report Template
Report Editor
MSTR Desktop Architect
Data Pivoting
19. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
20. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
Metrics
Cannot create project objects
Types of drilling
21. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
Components of a Metric
3 Methods of MSTR Desktop navigation
4 factors to consider when designing a data-warehouse schema
22. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
2 types of Facts
Characteristics of Nested Metrics
Project Creation Wizard
Limitations of the Attribute Creation Wizard
23. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Project Source
Desktop Designer
Compound Metric
ETL process
24. The logical associations between attributes that exist based on a business rule
Attribute Relationships
Page-by
Sorting
Physical Schema
25. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Characteristics of Nested Metrics
Fact Tables
2 ways you can configure the Project Source to connect to the Metadata database
MSTR Connectivity Wizard
26. Specifies what info to retrieve from a data-warehouse - and how to display it
Source system characteristics
Gigabytes (GB)
Warehouse Catalog
Report Template
27. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Long-term (2 - 5 years)
Components of Compound Metrics
Derived Attribute Expression
Reports
28. Using the Prompt Generation Wizard - Inside the Report Editor
Data Pivoting
To create a Report Prompt
ID form
4 types of Metrics
29. 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
Advantage of a completely denormalized schema
ETL
Long-term (2 - 5 years)
30. 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
Page-by
Simple Metrics
Table Keys
2 types of Attribute Expression
31. All report-level options overwrite ___________.
Lookup Table structure of a completely normalized schema
Project-level options/settings
Different methods for creating Page-by fields
3 project creation interfaces
32. Facts - Attributes - Hierarchies
Components of the Logical Data Model
To drill through User Hierarchies
Nested Metrics
Desktop Designer
33. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Facts
Attribute Forms
Lookup Tables
2 types of Facts
34. AND - OR - OR NOT - AND NOT
Application Objects
Report Filter operators
Components of Compound Metrics
Reference Report Objects
35. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Components of a MSTR architecture
Lookup Table structure of a completely denormalized schema
Objects you are allowed to Page-by
To drill through User Hierarchies
36. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
3 functions of Attribute Forms
Page-by
Short-term (2 - 6 months)
37. Homogeneous - Heterogeneous
Schema Objects
Data warehouse characteristics
2 types of Facts
5 Report display views
38. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Lookup Table structure of a moderately denormalized schema
4 parts of the Project Design Process
Configuration Wizard
39. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Report Filter operators
Project
Derived Attribute Expression
2 methods to creating Facts
40. View Filters are saved with the _____________.
ID form
2-Tier Architecture
Report Definitions
3 components of a Report
41. 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
Report Subscription
File types are allowed for exporting a Report
To "drill down" on a report
Tasks when defining a User Hierarchy
42. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
4 basic Schema objects
Highest-level attributes
To save a Report Format
43. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Types of analysis you can perform with OLAP Services
Table Keys
Column Aliases
Stored
44. To see data at completely different levels - other than that of the original Grid or Graph
Types of drilling
Components of a Derived Metric
Drilling
Terabytes (TB)
45. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Reports
Fact Tables
File types are allowed for exporting a Report
OLTP
46. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
Unlimited
File > Email Reports As
Desktop Architec
47. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
MSTR Connectivity Wizard
ETL
User Hierarchies
4 properties you must know in order to create attributes using the Attribute Editor
48. Groupings of directly related attributes. Also commonly known as "dimensions".
ETL
Sorting
Hierarchies
Project Source
49. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Tasks when defining a User Hierarchy
Required on the report for Outline Model to work
Long-term (2 - 5 years)
Different methods for creating Page-by fields
50. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Reports
Compound Attribute
Data warehouse characteristics
2 types of Table Keys