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. More storage - Complex SQL - Simple ETL
Report Subscription
The System
Characteristics of a Compound Table Key
Short-term (2 - 6 months)
2. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Report Filter
2 options for Sorting
Sorting
Characteristics of Nested Metrics
3. 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
Lookup Table structure of a moderately denormalized schema
Report Filter operators
Simple Metrics
Report Definitions
4. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Desktop Architec
The System
Sorting
Default Project folder structure
5. Metrics aggregate on the lowest-level attribute __________.
Source system characteristics
By default
Derived Metrics
Components of a MSTR architecture
6. You can e-mail reports by going to _____
Report Template
Compound Attribute
MSTR Connectivity Wizard
File > Email Reports As
7. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
2 types of Attribute Relationships
Limitations of the Attribute Creation Wizard
4 types of Metrics
Simple Attribute Expression
8. 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
Compound Attribute
Tasks when defining a User Hierarchy
Search-based prompts
Cannot create project objects
9. 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
Desktop Analyst
Components of the Logical Data Model
5 Report display views
10. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
4 basic Schema objects
Configuration Wizard
Metrics
Lookup Table structure of a completely normalized schema
11. The logical associations between attributes that exist based on a business rule
Attribute Relationships
Data warehouse characteristics
Simple Metrics
Components of the Logical Data Model
12. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
To "drill down" on a report
3 column types of a Physical Schema
Report Filter operators
13. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Report Editor
Display views you can Print by
Physical Schema
Unlimited
14. 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
To edit the appearance of a Graph in a report
View Filter
Nested Metrics
15. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Heterogeneous Attribute
The System
Project Source
MSTR Connectivity Wizard
16. Facts associated to the same column name in 1 or more tables
Heterogeneous Attribute
Metrics
Homogeneous Fact
Report Objects
17. Specifies what info to retrieve from a data-warehouse - and how to display it
Characteristics of a Compound Table Key
Report Template
To drill through User Hierarchies
Thresholding
18. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
2 ways you can configure the Project Source to connect to the Metadata database
The 3 MSTR Tools
Components of the Logical Data Model
19. Metrics you create within a report using only those objects in the report.
Value Prompts
Cannot create project objects
Locking and Resizing
Derived Metrics
20. View Filters are saved with the _____________.
Report Definitions
Characteristics of a Simple Table Key
Required on the report for Outline Model to work
Characteristics of Nested Metrics
21. Filter definition prompts - Object prompts - Value prompts - Level prompts
Short-term (2 - 6 months)
4 types of Prompts
New SQL
Compound Attribute
22. ID columns - Description columns - Fact columns
Advantage of a completely denormalized schema
Fact Tables
Report Objects
3 column types of a Physical Schema
23. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Lookup Table structure of a moderately denormalized schema
Attribute Elements
Homogeneous Attribute
Stored
24. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
2 types of Table Keys
ETL process
Unlimited
Components of Compound Metrics
25. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
To edit the appearance of a Graph in a report
Types of analysis you can perform with OLAP Services
Object Prompts
26. The Attribute Form Expression that maps to a single column - no matter the number of tables
The 3 MSTR Tools
MSTR Desktop Architect
Simple Attribute Expression
Project Creation Wizard
27. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
MSTR Desktop
4 properties you must know in order to create attributes using the Attribute Editor
Search-based prompts
Desktop Administrative Functions
28. A new tool for project design tasks - used for fine-tuning a project after initial creation
Fact Tables
Hierarchies
Architect Graphical Interface
ID form
29. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
Compound Attribute
Unlimited
Minimal or none
30. It contains the ID column of all higher-level attributes
OLAP
To create a Report Prompt
Lookup Table structure of a moderately denormalized schema
Default Project folder structure
31. All report-level options overwrite ___________.
Components of Compound Metrics
Project-level options/settings
Terabytes (TB)
Components of a MSTR architecture
32. 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
33. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Gigabytes (GB)
Level Prompts
Display views you can Print by
34. Schema Objects - Application Objects - Configuration Objects
To edit the appearance of a Graph in a report
Derived Metrics
Outline Mode
3 Types of Objects in MSTR Desktop
35. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Different methods for creating Page-by fields
MSTR applications
Aggregate a Metric
Report Editor
36. 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
Logical Data Model
Default Project folder structure
Types of drilling
2 types of Fact Expressions
37. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Characteristics of a Compound Table Key
Facts
Components of Compound Metrics
2-Tier Architecture
38. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Attribute Forms
The 3 MSTR Tools
Warehouse Catalog
39. Attribute Creation Wizard - Attribute Editor
4 factors to consider when designing a data-warehouse schema
Methods are there to creating Attributes
2 types of Facts
Reports
40. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Different methods for creating Page-by fields
Fact Tables
File types are allowed for exporting a Report
ETL
41. Subtotals reflect accumulations at selected attribute levels
Schema Object Editor
Subtotals
To edit the appearance of a Graph in a report
Homogeneous Attribute
42. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
2 methods to creating Facts
Notes
Source system characteristics
43. The default entry-points.
Default Project folder structure
Highest-level attributes
Characteristics of a Simple Table Key
Application Objects
44. It contains links to specific folders in the Folder List
Homogeneous Fact
3-Tier Architecture
Shortcut Bar
2 ways you can configure the Project Source to connect to the Metadata database
45. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Sorting
Report Filter operators
Page-by
46. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Desktop Administrative Functions
Simple Metrics
2 types of Fact Expressions
3 Schema types
47. OLTP data storage measure
3 project creation interfaces
4 parts of the Project Design Process
Gigabytes (GB)
MSTR Connectivity Wizard
48. Level of OLAP integration
3 column types of a Physical Schema
Characteristics of a Compound Table Key
Very high; part of ETL process
User Hierarchies
49. A user interface for creating and maintaining a BI environment
Object Prompts
Desktop Analyst
MSTR Desktop
Long-term (2 - 5 years)
50. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
2 methods to creating Facts
Report Objects
Object Prompts
Compound Metric