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. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Types of drilling
5 Report display views
Report Editor
2. One that uses 2 or more columns as its ID
Lookup Table structure of a completely normalized schema
Schema
Compound Attribute
Attribute Forms
3. Columns - Tables
Report Filter
Schema Object Editor
2 components of a Physical Schema
Limitations of the Attribute Creation Wizard
4. 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
Report Formatting
3 functions of Attribute Forms
Components of a MSTR architecture
4 parts of the Project Design Process
5. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
View Filters
File > Email Reports As
Subtotals
6. 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.
By default
Components of Compound Metrics
5 steps to creating a logical data model
User Hierarchies
7. 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
Characteristics of Nested Metrics
Report Prompts
ID form
Different methods for creating Page-by fields
8. Attribute Creation Wizard - Attribute Editor
Attribute Forms
Report Formatting
Methods are there to creating Attributes
View Filter
9. Used to "fine-tune" your Project
Drilling
Architect Graphical Interface
Terabytes (TB)
3 Methods of MSTR Desktop navigation
10. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Minimal or none
ETL process
5 steps to creating a logical data model
Components of the Logical Data Model
11. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Architect Graphical Interface
Report Template
Using a Search Object
View Filters
12. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Thresholding
Rollback your changes
Derived Attribute Expression
13. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
4 tasks of the Attribute Creation Wizard
Methods are there to creating Attributes
Objects you are allowed to Page-by
14. Prompts to select a single value on which to qualify a date - number or text string.
Desktop Administrative Functions
4 tasks of the Attribute Creation Wizard
ETL
Value Prompts
15. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Value Prompts
Process for creating the Project Metadata
Factors to consider when designing a logical data model
Notes
16. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Characteristics of a Compound Table Key
Components of Compound Metrics
Attribute Elements
Report Definitions
17. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Different methods for creating Page-by fields
Fact Tables
Default Project folder structure
4 basic Schema objects
18. 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
5 Report display views
Rollback your changes
4 factors to consider when designing a data-warehouse schema
Simple Metrics
19. A new tool for project design tasks - used for fine-tuning a project after initial creation
Report Objects
To create the Project connectivity
Architect Graphical Interface
View Filter
20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Using a Search Object
'View of a Report'
4 parts of the Project Design Process
Aggregate a Metric
21. Used to limit a possibly overwhelming set of potential prompt answers
4 properties you must know in order to create attributes using the Attribute Editor
'View of a Report'
Objects you are allowed to Page-by
Search-based prompts
22. User requirements - Existing source data - Technical and performance considerations
Application Objects
3 components of a Report
Factors to consider when designing a logical data model
3-Tier Architecture
23. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
To save a Report Format
Project Source
Desktop Analyst
3 components of a Report
24. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
3 types of Attributes
Components of a MSTR architecture
The 3 MSTR Tools
2 types of Facts
25. 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
Logical Data Model
Default Project folder structure
3 Schema types
26. Level of OLAP integration
3 components of a Report
Lookup Table structure of a completely denormalized schema
Very high; part of ETL process
Project Source
27. The Attribute Form Expression that maps to a single column - no matter the number of tables
Lookup Table structure of a completely normalized schema
Gigabytes (GB)
Simple Attribute Expression
Sample Metrics commonly performed on Facts
28. A user interface for creating and maintaining a BI environment
Hierarchies
MSTR Desktop
4 basic Schema objects
3 Methods of MSTR Desktop navigation
29. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Level Prompts
Source system characteristics
3 Sections of the MSTR Desktop interface
Report Definitions
30. Template - Filter - View of a Report
To create a Report Prompt
Report Filter operators
3 components of a Report
Sorting
31. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project Source
Column Aliases
Schema
Project
32. The unique values of an attribute obtained from the data-warehouse
Desktop Analyst
Lookup Table structure of a completely denormalized schema
Report Filter
Attribute Elements
33. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
File types are allowed for exporting a Report
To "drill down" on a report
2 types of Attribute Relationships
34. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Very high; part of ETL process
Desktop Analyst
3 components of a Report
3 project creation interfaces
35. 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
'View of a Report'
Fact Expression
Report Prompts
Types of drilling
36. Metrics aggregate on the lowest-level attribute __________.
Unlimited
By default
Facts
OLTP
37. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Report Definitions
Metrics
Characteristics of a Compound Table Key
Source system characteristics
38. Groupings of directly related attributes. Also commonly known as "dimensions".
Methods are there to creating Attributes
Column Aliases
Hierarchies
4 parts of the Project Design Process
39. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
ID form
4 types of Report Filters
Components of a Metric
Value Prompts
40. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Outline Mode
Types of analysis you can perform with OLAP Services
Application Objects
Table Keys
41. Schema Objects - Application Objects - Configuration Objects
Table Keys
Logical Data Model
3 Types of Objects in MSTR Desktop
MSTR Desktop Architect
42. 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
Attribute Forms
The 3 MSTR Tools
New SQL
Default Project folder structure
43. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Aggregate a Metric
Schema Objects
Report Filter
44. OLAP retains data ________
Source system characteristics
Long-term (2 - 5 years)
Schema Object Editor
Types of drilling
45. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Page-by
Project-level options/settings
The 3 MSTR Tools
Report Prompts
46. Specifies a condition data must meet in order to be included in a report
2-Tier Architecture
Attribute Creation Wizard good for
3 Types of Objects in MSTR Desktop
Report Filter
47. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Report Filter operators
ID form
3 Schema types
5 Report display views
48. Less storage - Simple SQL - Complex ETL
Aggregate a Metric
2 methods to creating Facts
Characteristics of a Simple Table Key
Limitations of the Attribute Creation Wizard
49. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
2 types of Attribute Relationships
Advantage of a completely denormalized schema
Heterogeneous Fact
50. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
The 3 MSTR Tools
To create the Project connectivity
Compound Metric
File types are allowed for exporting a Report