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 data storage measure
View Filter
Gigabytes (GB)
OLTP
Homogeneous Fact
2. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
View Filters
Drilling
Characteristics of a Compound Table Key
Project
3. Metrics aggregate on the lowest-level attribute __________.
3 Schema types
Thresholding
By default
User Hierarchies
4. One that uses 2 or more columns as its ID
Compound Attribute
4 types of Prompts
The 3 MSTR Tools
Metrics
5. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Project Creation Wizard
Metrics
To create a Report Prompt
2 types of Attribute Relationships
6. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Attribute Elements
Reference Report Objects
Simple Metrics
7. OLAP data storage measure
Desktop Administrative Functions
To create the Project connectivity
MSTR Connectivity Wizard
Terabytes (TB)
8. AND - OR - OR NOT - AND NOT
Report Filter operators
Hierarchies
Attribute Creation Wizard good for
Attribute or its relationship(s)
9. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Architect Graphical Interface
ETL
Thresholding
Sorting
10. It contains links to specific folders in the Folder List
Source system characteristics
File > Email Reports As
Shortcut Bar
Default Project folder structure
11. Less storage - Simple SQL - Complex ETL
Project Source
To create a Report Prompt
Characteristics of a Simple Table Key
View Filter
12. Top menu/dropdowns - Toolbar - Right-click popup menus
Report Subscription
3 Methods of MSTR Desktop navigation
Shortcut Bar
Aggregate a Metric
13. 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.
MSTR Connectivity Wizard
Report Prompts
2 types of Facts
Stored
14. Columns - Tables
Report Filter
Sorting
2 components of a Physical Schema
Value Prompts
15. Creating multiple attributes quickly. Used during the initial project creation.
Characteristics of a Compound Table Key
Facts
Desktop Architec
Attribute Creation Wizard good for
16. 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
17. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
2 methods to creating Facts
To "drill down" on a report
To edit the appearance of a Graph in a report
Report Filter operators
18. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
2 types of Fact Expressions
Drilling
3-Tier Architecture
Compound Metric
19. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Report Definitions
Lookup Table structure of a completely normalized schema
Derived Attribute Expression
5 steps to creating a logical data model
20. The logical associations between attributes that exist based on a business rule
New SQL
Architect Graphical Interface
Attribute Relationships
Report Formatting
21. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Thresholding
4 types of Prompts
Project Source
OLAP
22. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
4 basic Schema objects
5 steps to creating a logical data model
Desktop Architec
File types are allowed for exporting a Report
23. 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.
Components of a Metric
Rollback your changes
Schema Object Editor
User Hierarchies
24. The unique values of an attribute obtained from the data-warehouse
Desktop Analyst
Simple Attribute Expression
Attribute Elements
Sorting
25. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 types of Metrics
4 properties you must know in order to create attributes using the Attribute Editor
Report Definitions
5 steps to creating a logical data model
26. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Report Objects
View Filter
Reference Report Objects
The System
27. A shortcut to an existing Object in a Project
Physical Schema
Shortcut in MSTR Desktop
Long-term (2 - 5 years)
Components of a MSTR architecture
28. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3-Tier Architecture
Minimal or none
Characteristics of Nested Metrics
ETL process
29. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Reference Report Objects
Thresholding
Architect Graphical Interface
30. What tool do you use to create the Metadata shell?
MSTR Desktop Architect
Architect Graphical Interface
Project Source
Configuration Wizard
31. Primary keys
Components of a Metric
Table Keys
Gigabytes (GB)
Metrics
32. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Stored
Architect Graphical Interface
To save a Report Format
To create the Project connectivity
33. 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
To create the Project connectivity
3 functions of Attribute Forms
Components of a Metric
5 steps to creating a logical data model
34. Descriptive data that provides context for Facts.
Attribute Forms
Project-level options/settings
3 Types of Objects in MSTR Desktop
Components of a MSTR architecture
35. Specifies a condition data must meet in order to be included in a report
5 Report display views
Process for creating the Project Metadata
Report Filter
Homogeneous Attribute
36. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
3 Methods of MSTR Desktop navigation
Report Objects
Rollback your changes
Desktop Designer
37. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Characteristics of a Compound Table Key
To "drill down" on a report
Compound Attribute
Shortcut Bar
38. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Unlimited
4 parts of the Project Design Process
OLAP
Highest-level attributes
39. Create the Project Source - Create the Database Instance
Data Pivoting
Desktop Architec
4 types of Metrics
To create the Project connectivity
40. The Attribute Form Expression that maps to a single column - no matter the number of tables
2-Tier Architecture
Reports
Homogeneous Fact
Simple Attribute Expression
41. All report-level options overwrite ___________.
Project-level options/settings
Sample Metrics commonly performed on Facts
Gigabytes (GB)
Data Pivoting
42. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Objects you are allowed to Page-by
MSTR OLAP Services
File > Email Reports As
Relationship Tables
43. You can e-mail reports by going to _____
File > Email Reports As
5 steps to creating a logical data model
4 types of Report Filters
Report Definitions
44. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Attribute or its relationship(s)
Value Prompts
Facts
Logical Data Model
45. Compound - Homogeneous - Heterogeneous
3 types of Attributes
3 Sections of the MSTR Desktop interface
4 types of Metrics
Facts
46. Used to modify a Report
Report Editor
To qualify a Metric in a Set Qualification
New SQL
Different methods for creating Page-by fields
47. The System Hierarchy is automatically updated whenever you make a change to an __________________.
To create the Project connectivity
Tasks when defining a User Hierarchy
Attribute or its relationship(s)
Project Source
48. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Stored
Compound Metric
Report Formatting
Attribute Forms
49. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
3 types of Attributes
Attribute Forms
Search Object
5 Report display views
50. Simple - Derived
Hierarchies
4 factors to consider when designing a data-warehouse schema
2 types of Attribute Expression
Derived Metrics