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. Schema Objects - Application Objects - Configuration Objects
Attribute Creation Wizard good for
3 Types of Objects in MSTR Desktop
Attribute Relationships
Facts
2. 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
2 types of Fact Expressions
Simple Metrics
ETL process
Report Definitions
3. Specifies what info to retrieve from a data-warehouse - and how to display it
Desktop Architec
2 types of Table Keys
Report Template
MSTR Desktop Architect
4. It contains the ID column of the parent attribute
Display views you can Print by
Reference Report Objects
Thresholding
Lookup Table structure of a completely normalized schema
5. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Project
View Filter
Compound Metric
Warehouse Catalog
6. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Table Keys
Desktop Designer
To "drill down" on a report
'View of a Report'
7. 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
Level Prompts
Derived Attribute Expression
3 Schema types
Reports
8. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
To create a Report Prompt
Level Prompts
Compound Attribute
ETL process
9. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Thresholding
Different methods for creating Page-by fields
Fact Tables
Report Definitions
10. Subtotals reflect accumulations at selected attribute levels
To edit the appearance of a Graph in a report
Subtotals
Attributes
New SQL
11. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
3 Types of Objects in MSTR Desktop
Fact Tables
To drill through User Hierarchies
Rollback your changes
12. Specifies a condition data must meet in order to be included in a report
Attribute Relationships
Report Filter
3 column types of a Physical Schema
4 basic Schema objects
13. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Stored
Types of analysis you can perform with OLAP Services
Report Editor
Report Prompts
14. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Process for creating the Project Metadata
3 Types of Objects in MSTR Desktop
3 Methods of MSTR Desktop navigation
15. The Attribute Form Expression that maps to a single column - no matter the number of tables
Aggregate a Metric
Long-term (2 - 5 years)
Simple Attribute Expression
Banding
16. An environment in which the MSTR Desktop connects directly to the Metadata database.
Types of drilling
Report Objects
Characteristics of a Simple Table Key
2-Tier Architecture
17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
File > Email Reports As
To create a Report Prompt
View Filter
Schema
18. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
ETL
2 types of Attribute Expression
Table Keys
19. 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
Attribute Forms
Page-by
Characteristics of Nested Metrics
20. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
3-Tier Architecture
Project Source
3 types of Attributes
2 components of a Physical Schema
21. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
ETL
To drill through User Hierarchies
Reports
22. Template - Filter - View of a Report
Report Editor
3 components of a Report
ID form
3 types of Attributes
23. The unique values of an attribute obtained from the data-warehouse
Gigabytes (GB)
3 column types of a Physical Schema
Factors to consider when designing a logical data model
Attribute Elements
24. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Notes
4 types of Metrics
Heterogeneous Fact
Compound Metric
25. 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
Logical Data Model
Attributes
OLTP
Default Project folder structure
26. Direct: 2-tier - Server: 3-tier
Limitations of the Attribute Creation Wizard
3 Schema types
2 ways you can configure the Project Source to connect to the Metadata database
Lookup Table structure of a completely normalized schema
27. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
2 types of Table Keys
Heterogeneous Attribute
Desktop Analyst
To save a Report Format
28. Simple - Derived
Filter Definition Prompts
2 types of Attribute Expression
5 Report display views
Homogeneous Attribute
29. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Fact Tables
2 types of Fact Expressions
Cannot create project objects
Report Prompts
30. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
The System
Filter Definition Prompts
Sorting
MSTR OLAP Services
31. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
3 types of Attributes
MSTR Desktop Architect
Report Formatting
Filter Definition Prompts
32. The default entry-points.
MSTR Desktop Architect
Configuration Wizard
Process for creating the Project Metadata
Highest-level attributes
33. To see data at completely different levels - other than that of the original Grid or Graph
Data Pivoting
Drilling
Characteristics of a Compound Table Key
Gigabytes (GB)
34. The Attribute Form maps to different column names in multiple tables
4 parts of the Project Design Process
Heterogeneous Attribute
Value Prompts
Application Objects
35. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Highest-level attributes
MSTR Desktop
The 3 MSTR Tools
Compound Metric
36. A condition data must meet in order to be included in a report. Does affect the SQL.
Factors to consider when designing a logical data model
Report Filter
File > Email Reports As
Using a Search Object
37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
New SQL
Physical Schema
Thresholding
Aggregate a Metric
38. 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
39. 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
Cannot create project objects
Facts
3 functions of Attribute Forms
2 ways you can configure the Project Source to connect to the Metadata database
40. 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
Hierarchies
Attribute Forms
Report Editor
Types of drilling
41. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
Components of a Derived Metric
Logical Data Model
Characteristics of Nested Metrics
42. Top menu/dropdowns - Toolbar - Right-click popup menus
2 methods to creating Facts
3 column types of a Physical Schema
File > Email Reports As
3 Methods of MSTR Desktop navigation
43. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Derived Attribute Expression
'View of a Report'
Sample Metrics commonly performed on Facts
Notes
44. 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.
Level Prompts
Report Prompts
5 Report display views
Components of a Derived Metric
45. All report-level options overwrite ___________.
Project-level options/settings
Report Definitions
Report Subscription
Project Source
46. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Schema
2 types of Attribute Expression
Metrics
47. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
File types are allowed for exporting a Report
Source system characteristics
3 project creation interfaces
48. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
3 Methods of MSTR Desktop navigation
Data Pivoting
Search Object
2 components of a Physical Schema
49. You can e-mail reports by going to _____
File > Email Reports As
2 components of a Physical Schema
Notes
Level Prompts
50. Prompts to select a single value on which to qualify a date - number or text string.
Project Source
Value Prompts
Relationship Tables
3 column types of a Physical Schema