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. OLAP retains data ________
Shortcut in MSTR Desktop
Long-term (2 - 5 years)
Fact Expression
Schema Object Editor
2. Creating multiple attributes quickly. Used during the initial project creation.
Default Project folder structure
Required on the report for Outline Model to work
MSTR Connectivity Wizard
Attribute Creation Wizard good for
3. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Filter Definition Prompts
Lookup Tables
Page-by
Logical Data Model
4. The Attribute Form Expression that maps to a single column - no matter the number of tables
4 factors to consider when designing a data-warehouse schema
Report Template
Simple Attribute Expression
2 types of Attribute Expression
5. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
To create the Project connectivity
2 types of Fact Expressions
Stored
Warehouse Catalog
6. It contains links to specific folders in the Folder List
Shortcut Bar
MSTR applications
Data Pivoting
4 types of Metrics
7. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
2 types of Fact Expressions
To qualify a Metric in a Set Qualification
Object Prompts
Schema
8. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
OLAP
Data warehouse characteristics
MSTR Desktop Architect
Fact Expression
9. View Filters are saved with the _____________.
Reports
New SQL
3 project creation interfaces
Report Definitions
10. 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
11. A shortcut to an existing Object in a Project
MSTR OLAP Services
Aggregate a Metric
OLAP
Shortcut in MSTR Desktop
12. The unique values of an attribute obtained from the data-warehouse
Attribute Creation Wizard good for
Project-level options/settings
Derived Metrics
Attribute Elements
13. Facts associated to the same column name in 1 or more tables
2 types of Table Keys
Attributes
Homogeneous Fact
Very high; part of ETL process
14. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Hierarchies
Locking and Resizing
Project Creation Wizard
By default
15. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Report Template
Unlimited
Column Aliases
Advantage of a completely denormalized schema
16. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Report Filter
Derived Attribute Expression
Attribute Forms
OLTP
17. Used to "fine-tune" your Project
Components of a Derived Metric
Architect Graphical Interface
New SQL
Methods are there to creating Attributes
18. View Filters can only ___________.
Object Prompts
Reference Report Objects
View Filter
Report Formatting
19. All Attributes must have an _______.
ID form
Schema
Report Editor
Report Prompts
20. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
New SQL
MSTR OLAP Services
Sample Metrics commonly performed on Facts
Rollback your changes
21. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Facts
ETL process
Stored
Filter Definition Prompts
22. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Drilling
Desktop Administrative Functions
Source system characteristics
2-Tier Architecture
23. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
ID form
Hierarchies
Characteristics of a Compound Table Key
Sample Metrics commonly performed on Facts
24. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Heterogeneous Attribute
Types of analysis you can perform with OLAP Services
To "drill down" on a report
25. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
2 types of Attribute Expression
User Hierarchies
4 tasks of the Attribute Creation Wizard
Heterogeneous Fact
26. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
3 functions of Attribute Forms
Default Project folder structure
Report Filter operators
27. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Drilling
ETL process
Project-level options/settings
28. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
Components of Compound Metrics
Architect Graphical Interface
Facts
29. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
4 factors to consider when designing a data-warehouse schema
File > Email Reports As
3 components of a Report
Report Objects
30. Filter definition prompts - Object prompts - Value prompts - Level prompts
Shortcut in MSTR Desktop
Level Prompts
4 types of Prompts
OLAP
31. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
OLTP
MSTR Connectivity Wizard
Characteristics of a Compound Table Key
32. The default entry-points.
Using a Search Object
Lookup Tables
Highest-level attributes
Process for creating the Project Metadata
33. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Project-level options/settings
View Filter
5 Report display views
34. Reduced number of JOINS in the generated SQL
Attribute Creation Wizard good for
Search Object
Advantage of a completely denormalized schema
Attributes
35. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Simple Attribute Expression
3 project creation interfaces
Attribute Forms
36. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
MSTR applications
Report Editor
Types of analysis you can perform with OLAP Services
Compound Attribute
37. 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
Heterogeneous Attribute
By default
Limitations of the Attribute Creation Wizard
Logical Data Model
38. Extraction - transformation - loading
Terabytes (TB)
Aggregate a Metric
ETL
Object Prompts
39. Specifies a condition data must meet in order to be included in a report
Object Prompts
Unlimited
Metrics
Report Filter
40. Using the Prompt Generation Wizard - Inside the Report Editor
2-Tier Architecture
4 properties you must know in order to create attributes using the Attribute Editor
To create a Report Prompt
3 components of a Report
41. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
3 Sections of the MSTR Desktop interface
Facts
Stored
42. Used to create or edit complex attributes - facts - hierarchies - and logical tables
2 types of Attribute Relationships
MSTR Desktop
Schema Object Editor
Different methods for creating Page-by fields
43. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Aggregate a Metric
Types of drilling
Column Aliases
Stored
44. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Attribute Creation Wizard good for
Heterogeneous Fact
Search-based prompts
Thresholding
45. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
2 types of Attribute Relationships
Simple Metrics
Attribute Relationships
46. 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 Methods of MSTR Desktop navigation
3 functions of Attribute Forms
4 types of Metrics
Using a Search Object
47. To see data at completely different levels - other than that of the original Grid or Graph
User Hierarchies
Drilling
Report Subscription
Heterogeneous Attribute
48. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Search Object
Attribute or its relationship(s)
5 steps to creating a logical data model
Display views you can Print by
49. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Homogeneous Fact
3 Sections of the MSTR Desktop interface
3 types of Attributes
View Filter
50. Tables - Facts - Attributes - Hierarchies
By default
4 basic Schema objects
Subtotals
2 methods to creating Facts