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. Compound - Homogeneous - Heterogeneous
Attributes
Schema
3 types of Attributes
Highest-level attributes
2. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Types of analysis you can perform with OLAP Services
4 tasks of the Attribute Creation Wizard
Lookup Table structure of a completely denormalized schema
2 ways you can configure the Project Source to connect to the Metadata database
3. 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
Highest-level attributes
View Filter
Report Prompts
To qualify a Metric in a Set Qualification
4. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Drilling
To create a Report Prompt
Short-term (2 - 6 months)
5. 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
6. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Value Prompts
2-Tier Architecture
Column Aliases
Attribute or its relationship(s)
7. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
2 types of Facts
To save a Report Format
3 project creation interfaces
4 properties you must know in order to create attributes using the Attribute Editor
8. OLTP retains data ________
User Hierarchies
Components of a Metric
3 column types of a Physical Schema
Short-term (2 - 6 months)
9. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
3 Sections of the MSTR Desktop interface
Project Creation Wizard
Report Filter operators
10. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Unlimited
Report Filter
Report Prompts
11. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
2-Tier Architecture
Project Creation Wizard
Unlimited
12. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Report Definitions
3 project creation interfaces
Characteristics of Nested Metrics
Unlimited
13. Creating multiple attributes quickly. Used during the initial project creation.
Components of a Derived Metric
By default
Attribute Creation Wizard good for
3 Methods of MSTR Desktop navigation
14. A condition data must meet in order to be included in a report. Does affect the SQL.
3 functions of Attribute Forms
2-Tier Architecture
Report Filter
Metrics
15. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Locking and Resizing
File > Email Reports As
Characteristics of Nested Metrics
Report Template
16. 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
Logical Data Model
Project
Facts
Unlimited
17. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Warehouse Catalog
Configuration Wizard
Sorting
Report Definitions
18. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
ETL process
Highest-level attributes
Report Objects
5 steps to creating a logical data model
19. OLAP data storage measure
Attribute Creation Wizard good for
2 types of Attribute Expression
Terabytes (TB)
Warehouse Catalog
20. 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.
Report Prompts
Display views you can Print by
2 types of Facts
Limitations of the Attribute Creation Wizard
21. Filter definition prompts - Object prompts - Value prompts - Level prompts
Cannot create project objects
MSTR Desktop Architect
4 types of Prompts
Attribute Relationships
22. Grid View - Graph View - Grid/Graph View - SQL View
Shortcut in MSTR Desktop
Simple Metrics
Display views you can Print by
Schema Objects
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.
Required on the report for Outline Model to work
User Hierarchies
Components of Compound Metrics
OLTP
24. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Types of analysis you can perform with OLAP Services
Required on the report for Outline Model to work
Level Prompts
Thresholding
25. How users can share comments for reports to other users
Attributes
Unlimited
Notes
Minimal or none
26. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
3 components of a Report
Schema Objects
Subtotals
27. 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
Default Project folder structure
Report Filter operators
Application Objects
Attribute or its relationship(s)
28. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Fact Tables
Report Editor
MSTR OLAP Services
To edit the appearance of a Graph in a report
29. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Relationship Tables
3 types of Attributes
Factors to consider when designing a logical data model
30. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Nested Metrics
Highest-level attributes
Process for creating the Project Metadata
Using a Search Object
31. A user interface for creating and maintaining a BI environment
Logical Data Model
Project-level options/settings
Display views you can Print by
MSTR Desktop
32. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Compound Metric
4 factors to consider when designing a data-warehouse schema
ETL process
View Filter
33. The logical associations between attributes that exist based on a business rule
5 steps to creating a logical data model
2 methods to creating Facts
Attribute Relationships
Minimal or none
34. Used to create or edit complex attributes - facts - hierarchies - and logical tables
2 types of Attribute Expression
Sorting
By default
Schema Object Editor
35. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
4 types of Report Filters
Report Prompts
Desktop Analyst
Aggregate a Metric
36. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Project Creation Wizard
Facts
2 options for Sorting
2 types of Attribute Relationships
37. OLTP data storage measure
Display views you can Print by
To save a Report Format
Gigabytes (GB)
ID form
38. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
2 components of a Physical Schema
Report Editor
The System
Metrics
39. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Components of a Derived Metric
Display views you can Print by
Table Keys
40. 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
2 methods to creating Facts
Advantage of a completely denormalized schema
MSTR Connectivity Wizard
41. 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
Highest-level attributes
Sample Metrics commonly performed on Facts
Column Aliases
42. All report-level options overwrite ___________.
Data warehouse characteristics
Lookup Table structure of a completely normalized schema
Fact Expression
Project-level options/settings
43. Top menu/dropdowns - Toolbar - Right-click popup menus
Architect Graphical Interface
3 Methods of MSTR Desktop navigation
Simple Attribute Expression
5 Report display views
44. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Search-based prompts
Column Aliases
MSTR Desktop Architect
45. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Limitations of the Attribute Creation Wizard
3 Methods of MSTR Desktop navigation
Default Project folder structure
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Types of drilling
MSTR applications
Relationship Tables
ETL
47. What tool do you use to create the Metadata shell?
Report Editor
Configuration Wizard
3 components of a Report
Project-level options/settings
48. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Compound Attribute
Lookup Table structure of a moderately denormalized schema
Using a Search Object
49. Used to limit a possibly overwhelming set of potential prompt answers
Default Project folder structure
Required on the report for Outline Model to work
Search-based prompts
MSTR Connectivity Wizard
50. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Data Pivoting
Schema
2 types of Table Keys
Application Objects