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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
2 types of Facts
Stored
4 types of Prompts
Physical Schema
2. Compound - Homogeneous - Heterogeneous
Report Editor
Homogeneous Attribute
3 types of Attributes
2 types of Attribute Expression
3. It contains the ID and DESC columns of all higher-level attributes
4 properties you must know in order to create attributes using the Attribute Editor
Facts
Lookup Table structure of a completely denormalized schema
Report Template
4. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Attributes
View Filter
4 factors to consider when designing a data-warehouse schema
5. OLTP data storage measure
Application Objects
Logical Data Model
Gigabytes (GB)
The 3 MSTR Tools
6. More storage - Complex SQL - Simple ETL
Attribute Relationships
Thresholding
File > Email Reports As
Characteristics of a Compound Table Key
7. Used to "fine-tune" your Project
New SQL
Architect Graphical Interface
Components of a MSTR architecture
Outline Mode
8. 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
Report Subscription
OLTP
Logical Data Model
Default Project folder structure
9. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
ETL
Characteristics of a Simple Table Key
Shortcut in MSTR Desktop
Fact Tables
10. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Attribute Relationships
Simple Metrics
To qualify a Metric in a Set Qualification
Facts
11. Less storage - Simple SQL - Complex ETL
4 properties you must know in order to create attributes using the Attribute Editor
Characteristics of a Simple Table Key
Report Objects
Subtotals
12. Homogeneous - Heterogeneous
Search-based prompts
2 types of Facts
Attribute Forms
By default
13. Grid View - Graph View - Grid/Graph View - SQL View
3-Tier Architecture
Display views you can Print by
Using a Search Object
Report Filter operators
14. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Simple Attribute Expression
Attributes
Data Pivoting
2 methods to creating Facts
15. Used to modify a Report
Report Editor
Attributes
Highest-level attributes
Compound Attribute
16. Template - Filter - View of a Report
Search-based prompts
3 components of a Report
View Filter
Characteristics of a Simple Table Key
17. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Reports
Data warehouse characteristics
Compound Attribute
Homogeneous Fact
18. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
To qualify a Metric in a Set Qualification
Heterogeneous Attribute
Characteristics of Nested Metrics
MSTR Desktop Architect
19. A new tool for project design tasks - used for fine-tuning a project after initial creation
Page-by
Limitations of the Attribute Creation Wizard
Subtotals
Architect Graphical Interface
20. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Lookup Tables
3 Schema types
5 steps to creating a logical data model
21. Used to limit a possibly overwhelming set of potential prompt answers
Report Formatting
3 Methods of MSTR Desktop navigation
Search-based prompts
Rollback your changes
22. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Reports
View Filters
2 types of Facts
23. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
2 types of Attribute Relationships
4 types of Metrics
File > Email Reports As
24. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Schema Object Editor
Process for creating the Project Metadata
Warehouse Catalog
Logical Data Model
25. OLAP retains data ________
Long-term (2 - 5 years)
User Hierarchies
Characteristics of Nested Metrics
4 factors to consider when designing a data-warehouse schema
26. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Long-term (2 - 5 years)
4 types of Report Filters
Attribute or its relationship(s)
Sorting
27. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
2 options for Sorting
Methods are there to creating Attributes
ETL process
28. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
To save a Report Format
Rollback your changes
Different methods for creating Page-by fields
Attribute or its relationship(s)
29. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Attribute or its relationship(s)
5 steps to creating a logical data model
Physical Schema
Minimal or none
30. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
OLTP
Desktop Architec
3-Tier Architecture
31. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
By default
To drill through User Hierarchies
Hierarchies
32. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
3 Types of Objects in MSTR Desktop
Unlimited
MSTR Desktop Architect
Long-term (2 - 5 years)
33. 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
34. Facts - Attributes - Hierarchies
Highest-level attributes
3 project creation interfaces
Components of the Logical Data Model
Facts
35. Facts associated to different column names in 2 or more tables
Derived Attribute Expression
Display views you can Print by
Heterogeneous Fact
2 types of Table Keys
36. Groupings of directly related attributes. Also commonly known as "dimensions".
Lookup Table structure of a completely denormalized schema
Hierarchies
3 project creation interfaces
OLAP
37. 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
Lookup Table structure of a completely normalized schema
Schema Object Editor
Notes
38. The Attribute Form maps to different column names in multiple tables
Display views you can Print by
Configuration Wizard
Heterogeneous Attribute
Value Prompts
39. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
5 Report display views
Notes
Schema Objects
40. 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.
Banding
To "drill down" on a report
Short-term (2 - 6 months)
Report Prompts
41. ID columns - Description columns - Fact columns
Notes
3 column types of a Physical Schema
Attributes
Source system characteristics
42. What tool do you use to create the Metadata shell?
Configuration Wizard
Warehouse Catalog
Notes
Project
43. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Lookup Table structure of a completely denormalized schema
Characteristics of a Simple Table Key
View Filter
3-Tier Architecture
44. Must have a one-to-one relationship with all other forms.
3 Sections of the MSTR Desktop interface
3 components of a Report
Report Filter
Attribute Forms
45. Tables - Facts - Attributes - Hierarchies
4 types of Report Filters
Search Object
4 basic Schema objects
Column Aliases
46. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Required on the report for Outline Model to work
Compound Metric
MSTR Connectivity Wizard
OLAP
47. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
3 functions of Attribute Forms
Drilling
Using a Search Object
Report Editor
48. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Gigabytes (GB)
Required on the report for Outline Model to work
Types of drilling
OLTP
49. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Report Subscription
OLTP
Characteristics of a Compound Table Key
Components of a Derived Metric
50. 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.
User Hierarchies
Heterogeneous Attribute
Cannot create project objects
Terabytes (TB)