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. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
5 Report display views
View Filters
Stored
2. Create the Project Source - Create the Database Instance
To create the Project connectivity
Simple Metrics
MSTR applications
Tasks when defining a User Hierarchy
3. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Terabytes (TB)
Physical Schema
To drill through User Hierarchies
Architect Graphical Interface
4. Metrics you create within a report using only those objects in the report.
Derived Metrics
To create a Report Prompt
Highest-level attributes
Data Pivoting
5. Tables - Facts - Attributes - Hierarchies
To save a Report Format
Homogeneous Attribute
Rollback your changes
4 basic Schema objects
6. What tool do you use to create the Metadata DSN connection?
Methods are there to creating Attributes
Data Pivoting
Compound Metric
MSTR Connectivity Wizard
7. Groupings of directly related attributes. Also commonly known as "dimensions".
File types are allowed for exporting a Report
Hierarchies
Display views you can Print by
Report Filter operators
8. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Required on the report for Outline Model to work
3 types of Attributes
Thresholding
9. Subtotals reflect accumulations at selected attribute levels
Subtotals
Components of a MSTR architecture
Physical Schema
Lookup Tables
10. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Page-by
MSTR OLAP Services
Attribute Creation Wizard good for
Hierarchies
11. Enables you to rearrange the columns and rows in a report.
Components of a Metric
Relationship Tables
Data Pivoting
Attributes
12. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Facts
Drilling
Desktop Administrative Functions
13. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Reports
Search Object
3-Tier Architecture
Schema Objects
14. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
ID form
4 basic Schema objects
Source system characteristics
To qualify a Metric in a Set Qualification
15. The unique values of an attribute obtained from the data-warehouse
Project Source
Attribute Elements
Types of analysis you can perform with OLAP Services
Attributes
16. 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
Using a Search Object
2 types of Facts
Data warehouse characteristics
17. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Thresholding
Locking and Resizing
Report Filter
18. OLAP Services does not add any ______ to the report query.
Terabytes (TB)
New SQL
Relationship Tables
MSTR Desktop Architect
19. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Data warehouse characteristics
Relationship Tables
File types are allowed for exporting a Report
New SQL
20. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
New SQL
Limitations of the Attribute Creation Wizard
View Filters
Methods are there to creating Attributes
21. Top menu/dropdowns - Toolbar - Right-click popup menus
Gigabytes (GB)
5 steps to creating a logical data model
3 Methods of MSTR Desktop navigation
Attributes
22. Simple - Compound - Nested - Derived
Fact Expression
2 types of Facts
Report Definitions
4 types of Metrics
23. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Types of analysis you can perform with OLAP Services
Cannot create project objects
4 properties you must know in order to create attributes using the Attribute Editor
Level Prompts
24. OLTP data storage measure
Gigabytes (GB)
2 options for Sorting
4 tasks of the Attribute Creation Wizard
'View of a Report'
25. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
4 factors to consider when designing a data-warehouse schema
4 types of Report Filters
2-Tier Architecture
26. OLAP retains data ________
Cannot create project objects
Components of a Derived Metric
Long-term (2 - 5 years)
4 types of Report Filters
27. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Lookup Tables
Characteristics of a Compound Table Key
2 methods to creating Facts
Aggregate a Metric
28. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
Derived Attribute Expression
View Filters
Derived Metrics
29. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
4 types of Metrics
View Filter
3 Sections of the MSTR Desktop interface
30. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Filter Definition Prompts
Rollback your changes
Project-level options/settings
31. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
2 types of Attribute Relationships
4 tasks of the Attribute Creation Wizard
Warehouse Catalog
Relationship Tables
32. 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.
Schema
Report Prompts
Simple Metrics
Types of analysis you can perform with OLAP Services
33. What tool do you use to create the Metadata shell?
Configuration Wizard
2 types of Facts
To "drill down" on a report
2 types of Attribute Relationships
34. Formula - Level (Dimensionality) - Conditionality - Transformation
3 Types of Objects in MSTR Desktop
Components of a Metric
Attributes
Desktop Administrative Functions
35. A method of organizing the appearance of report results in a Grid report based on a criteria
MSTR Connectivity Wizard
Desktop Analyst
Data Pivoting
Banding
36. 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
Source system characteristics
Column Aliases
MSTR Connectivity Wizard
3 Schema types
37. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Value Prompts
Project Source
Highest-level attributes
3 project creation interfaces
38. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Stored
Characteristics of a Compound Table Key
Types of analysis you can perform with OLAP Services
39. To see data at completely different levels - other than that of the original Grid or Graph
3 Methods of MSTR Desktop navigation
Homogeneous Attribute
Using a Search Object
Drilling
40. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Characteristics of a Simple Table Key
Project Creation Wizard
Desktop Administrative Functions
41. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
ID form
Value Prompts
Project Source
42. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
3 project creation interfaces
Using a Search Object
Types of drilling
43. It contains links to specific folders in the Folder List
Desktop Administrative Functions
Limitations of the Attribute Creation Wizard
Lookup Table structure of a moderately denormalized schema
Shortcut Bar
44. Facts - Attributes - Hierarchies
Components of the Logical Data Model
4 basic Schema objects
To qualify a Metric in a Set Qualification
File types are allowed for exporting a Report
45. 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
Types of drilling
Simple Metrics
Factors to consider when designing a logical data model
Short-term (2 - 6 months)
46. It contains the ID column of the parent attribute
Attribute Forms
OLTP
Lookup Table structure of a completely normalized schema
Schema Objects
47. OLTP retains data ________
Short-term (2 - 6 months)
Default Project folder structure
Schema Objects
To qualify a Metric in a Set Qualification
48. Used for - Initially populating the Metadata - Creating schema objects
Lookup Table structure of a moderately denormalized schema
MSTR Desktop Architect
Factors to consider when designing a logical data model
Warehouse Catalog
49. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Report Objects
Report Filter
Shortcut in MSTR Desktop
Required on the report for Outline Model to work
50. Specifies a condition data must meet in order to be included in a report
Types of analysis you can perform with OLAP Services
3 project creation interfaces
Report Filter
MSTR applications