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. User reporting requirements - Query performance - Data volume - DB Maintenance
Limitations of the Attribute Creation Wizard
4 factors to consider when designing a data-warehouse schema
OLTP
Report Template
2. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Gigabytes (GB)
Attribute Elements
3 types of Attributes
Sample Metrics commonly performed on Facts
3. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
3 Sections of the MSTR Desktop interface
Search-based prompts
Unlimited
Process for creating the Project Metadata
4. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Filter operators
Homogeneous Attribute
Banding
2 types of Table Keys
5. 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
Project-level options/settings
Report Subscription
Tasks when defining a User Hierarchy
Simple Metrics
6. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Report Subscription
Physical Schema
Tasks when defining a User Hierarchy
7. Enables you to lock column headers so that they always appear when scrolling
3 Methods of MSTR Desktop navigation
Locking and Resizing
2 types of Fact Expressions
Drilling
8. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Fact Tables
Architect Graphical Interface
3 Sections of the MSTR Desktop interface
9. Primary keys
To drill through User Hierarchies
Cannot create project objects
MSTR applications
Table Keys
10. 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
Simple Attribute Expression
Default Project folder structure
The 3 MSTR Tools
Architect Graphical Interface
11. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Schema
Physical Schema
3-Tier Architecture
4 tasks of the Attribute Creation Wizard
12. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Architect Graphical Interface
2 methods to creating Facts
Physical Schema
Table Keys
13. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Derived Metrics
Project Source
Limitations of the Attribute Creation Wizard
Process for creating the Project Metadata
14. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Using a Search Object
Cannot create project objects
2-Tier Architecture
To edit the appearance of a Graph in a report
15. Formula - Level (Dimensionality) - Conditionality - Transformation
Facts
Process for creating the Project Metadata
Attribute Relationships
Components of a Metric
16. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Cannot create project objects
Long-term (2 - 5 years)
By default
17. Used to "fine-tune" your Project
Page-by
Architect Graphical Interface
Attribute or its relationship(s)
Methods are there to creating Attributes
18. Simple - Compound - Nested - Derived
OLTP
4 types of Metrics
Schema Object Editor
5 Report display views
19. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
3-Tier Architecture
MSTR Desktop
Short-term (2 - 6 months)
20. Subtotals reflect accumulations at selected attribute levels
Subtotals
Types of drilling
Level Prompts
Notes
21. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
3 functions of Attribute Forms
Lookup Table structure of a completely denormalized schema
2 options for Sorting
4 basic Schema objects
22. Columns - Tables
Objects you are allowed to Page-by
2 components of a Physical Schema
Lookup Table structure of a completely denormalized schema
Shortcut Bar
23. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
2 types of Table Keys
Report Formatting
Components of the Logical Data Model
24. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Report Formatting
Attribute Forms
Project-level options/settings
25. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
2 types of Attribute Relationships
Search-based prompts
File types are allowed for exporting a Report
26. Create the Project Source - Create the Database Instance
Aggregate a Metric
To create the Project connectivity
Highest-level attributes
5 steps to creating a logical data model
27. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
View Filters
Short-term (2 - 6 months)
Attribute Elements
Cannot create project objects
28. You must select "Other directions" when drilling attributes while viewing a report
Report Filter
To drill through User Hierarchies
3 Schema types
Compound Metric
29. The default entry-points.
Reference Report Objects
To drill through User Hierarchies
4 parts of the Project Design Process
Highest-level attributes
30. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
Terabytes (TB)
MSTR applications
4 parts of the Project Design Process
31. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Heterogeneous Attribute
Source system characteristics
Facts
Limitations of the Attribute Creation Wizard
32. Prompts to select a single value on which to qualify a date - number or text string.
Required on the report for Outline Model to work
Value Prompts
3 column types of a Physical Schema
Hierarchies
33. A user interface for creating and maintaining a BI environment
The System
Notes
'View of a Report'
MSTR Desktop
34. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Display views you can Print by
Search-based prompts
MSTR OLAP Services
35. Enables you to select and display subsets of a report as separate pages.
Default Project folder structure
Derived Metrics
Page-by
Report Filter operators
36. OLTP retains data ________
Lookup Table structure of a moderately denormalized schema
Level Prompts
MSTR applications
Short-term (2 - 6 months)
37. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Short-term (2 - 6 months)
Simple Metrics
To "drill down" on a report
Report Prompts
38. Using the Prompt Generation Wizard - Inside the Report Editor
Architect Graphical Interface
To create a Report Prompt
Relationship Tables
By default
39. It contains the ID column of all higher-level attributes
Attribute Creation Wizard good for
Lookup Table structure of a moderately denormalized schema
Default Project folder structure
Project-level options/settings
40. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
Reference Report Objects
Using a Search Object
View Filter
41. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Logical Data Model
Derived Attribute Expression
Reference Report Objects
Attribute Creation Wizard good for
42. Specifies a condition data must meet in order to be included in a report
Report Filter
Components of Compound Metrics
To create the Project connectivity
Fact Tables
43. OLAP Services does not add any ______ to the report query.
User Hierarchies
4 parts of the Project Design Process
MSTR Connectivity Wizard
New SQL
44. One that uses 2 or more columns as its ID
Object Prompts
Fact Expression
Compound Attribute
Display views you can Print by
45. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Locking and Resizing
Project
Types of drilling
46. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
4 properties you must know in order to create attributes using the Attribute Editor
Data warehouse characteristics
Homogeneous Fact
Shortcut Bar
47. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Locking and Resizing
Application Objects
Short-term (2 - 6 months)
ETL process
48. It contains links to specific folders in the Folder List
Value Prompts
Desktop Administrative Functions
2 ways you can configure the Project Source to connect to the Metadata database
Shortcut Bar
49. 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.
3 Methods of MSTR Desktop navigation
Report Prompts
Shortcut in MSTR Desktop
Report Objects
50. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
3 types of Attributes
Aggregate a Metric
MSTR Connectivity Wizard