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. Facts associated to the same column name in 1 or more tables
Attribute Forms
Notes
Homogeneous Fact
The 3 MSTR Tools
2. What tool do you use to create the Metadata shell?
2-Tier Architecture
Report Prompts
Configuration Wizard
Project
3. Used to modify a Report
File > Email Reports As
Report Editor
Stored
2 types of Attribute Relationships
4. Compound - Homogeneous - Heterogeneous
Architect Graphical Interface
3 types of Attributes
Fact Expression
Drilling
5. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Attribute Forms
Desktop Designer
Level Prompts
6. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Warehouse Catalog
To save a Report Format
Desktop Administrative Functions
Schema
7. Primary keys
3 functions of Attribute Forms
Table Keys
To edit the appearance of a Graph in a report
Facts
8. More storage - Complex SQL - Simple ETL
MSTR OLAP Services
Derived Attribute Expression
3 project creation interfaces
Characteristics of a Compound Table Key
9. It contains the ID column of all higher-level attributes
2 options for Sorting
Lookup Table structure of a moderately denormalized schema
Search Object
Rollback your changes
10. 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
MSTR Desktop Architect
3 Schema types
Nested Metrics
Attribute Forms
11. Prompts to select a single value on which to qualify a date - number or text string.
Fact Expression
Report Formatting
Value Prompts
4 factors to consider when designing a data-warehouse schema
12. 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
Components of a Metric
2 ways you can configure the Project Source to connect to the Metadata database
Filter Definition Prompts
13. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Configuration Wizard
Types of drilling
Tasks when defining a User Hierarchy
14. Subtotals reflect accumulations at selected attribute levels
Application Objects
Subtotals
Components of a MSTR architecture
Fact Tables
15. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Objects you are allowed to Page-by
2 types of Table Keys
Components of the Logical Data Model
Components of Compound Metrics
16. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Report Filter
Report Formatting
4 tasks of the Attribute Creation Wizard
3-Tier Architecture
17. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Relationship Tables
Components of Compound Metrics
Report Subscription
18. Specifies a condition data must meet in order to be included in a report
Components of Compound Metrics
Notes
Report Filter
ETL process
19. You must select "Other directions" when drilling attributes while viewing a report
Long-term (2 - 5 years)
Report Definitions
Fact Tables
To drill through User Hierarchies
20. The Attribute Form maps to the same column name in multiple tables
Attribute Forms
Facts
2 options for Sorting
Homogeneous Attribute
21. Enables you to select which tables from the data-warehouse to store in the Metadata database
4 types of Metrics
Warehouse Catalog
Architect Graphical Interface
To save a Report Format
22. All report-level options overwrite ___________.
Column Aliases
Notes
Project-level options/settings
Source system characteristics
23. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
The 3 MSTR Tools
Value Prompts
View Filter
Factors to consider when designing a logical data model
24. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
3 types of Attributes
Fact Tables
4 types of Report Filters
Sample Metrics commonly performed on Facts
25. Specifies what info to retrieve from a data-warehouse - and how to display it
Default Project folder structure
Report Template
Hierarchies
Level Prompts
26. Formula - Level (Dimensionality) - Conditionality - Transformation
OLTP
Components of a Metric
Outline Mode
2 options for Sorting
27. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Warehouse Catalog
Filter Definition Prompts
Object Prompts
4 factors to consider when designing a data-warehouse schema
28. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Different methods for creating Page-by fields
MSTR Connectivity Wizard
MSTR OLAP Services
2 components of a Physical Schema
29. 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
Schema Objects
Logical Data Model
Locking and Resizing
2 types of Table Keys
30. 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
Advantage of a completely denormalized schema
Metrics
Heterogeneous Attribute
31. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Notes
Process for creating the Project Metadata
OLAP
Report Filter
32. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Search-based prompts
The 3 MSTR Tools
4 parts of the Project Design Process
Process for creating the Project Metadata
33. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Process for creating the Project Metadata
3 components of a Report
Lookup Table structure of a completely denormalized schema
Project
34. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Filter Definition Prompts
Derived Attribute Expression
4 factors to consider when designing a data-warehouse schema
Stored
35. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Notes
4 types of Metrics
Desktop Analyst
36. A shortcut to an existing Object in a Project
Attribute Forms
Aggregate a Metric
Shortcut in MSTR Desktop
Compound Metric
37. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Hierarchies
Configuration Wizard
Project Creation Wizard
Reports
38. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Simple Metrics
Types of analysis you can perform with OLAP Services
Thresholding
Relationship Tables
39. 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
40. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Relationship Tables
Different methods for creating Page-by fields
Report Subscription
41. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Notes
Schema Object Editor
Lookup Table structure of a moderately denormalized schema
Components of a Metric
42. Simple - Derived
Components of a Metric
3 types of Attributes
2 types of Attribute Expression
Object Prompts
43. One that uses 2 or more columns as its ID
Schema
Characteristics of a Simple Table Key
ID form
Compound Attribute
44. 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
Components of a Derived Metric
Reports
Rollback your changes
3 functions of Attribute Forms
45. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Notes
Sample Metrics commonly performed on Facts
MSTR applications
Types of analysis you can perform with OLAP Services
46. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Simple Metrics
Components of the Logical Data Model
Factors to consider when designing a logical data model
5 Report display views
47. A method of organizing the appearance of report results in a Grid report based on a criteria
ETL
Fact Expression
To create the Project connectivity
Banding
48. It contains the ID and DESC columns of all higher-level attributes
2 components of a Physical Schema
Report Formatting
Lookup Table structure of a completely denormalized schema
Attribute Elements
49. The logical associations between attributes that exist based on a business rule
Thresholding
Attribute Relationships
To create the Project connectivity
Simple Metrics
50. Level of OLAP integration
Banding
3-Tier Architecture
Cannot create project objects
Very high; part of ETL process