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. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
2 methods to creating Facts
Project
Search-based prompts
2. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Column Aliases
Unlimited
2-Tier Architecture
3 Types of Objects in MSTR Desktop
3. Create the Project Source - Create the Database Instance
Project Creation Wizard
To create the Project connectivity
3 Methods of MSTR Desktop navigation
2 types of Attribute Relationships
4. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
ETL process
Report Filter
Simple Metrics
5. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Attribute Creation Wizard good for
2 types of Attribute Expression
Desktop Analyst
Project
6. OLAP data storage measure
Terabytes (TB)
4 types of Prompts
Characteristics of Nested Metrics
2-Tier Architecture
7. User requirements - Existing source data - Technical and performance considerations
Fact Tables
4 basic Schema objects
Relationship Tables
Factors to consider when designing a logical data model
8. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Different methods for creating Page-by fields
2 types of Table Keys
Sorting
Page-by
9. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
4 types of Report Filters
Components of a Metric
4 types of Metrics
10. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
To edit the appearance of a Graph in a report
OLTP
2 methods to creating Facts
Lookup Table structure of a moderately denormalized schema
11. Formula - Level (Dimensionality) - Conditionality - Transformation
2 types of Table Keys
'View of a Report'
2 types of Attribute Expression
Components of a Metric
12. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Tasks when defining a User Hierarchy
Column Aliases
Reports
OLAP
13. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Objects you are allowed to Page-by
Derived Attribute Expression
ETL process
Reference Report Objects
14. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
4 properties you must know in order to create attributes using the Attribute Editor
3 types of Attributes
Desktop Architec
15. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Aggregate a Metric
Using a Search Object
By default
Search Object
16. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
4 parts of the Project Design Process
4 tasks of the Attribute Creation Wizard
Warehouse Catalog
Report Formatting
17. The unique values of an attribute obtained from the data-warehouse
The 3 MSTR Tools
Search Object
Project Creation Wizard
Attribute Elements
18. A shortcut to an existing Object in a Project
Process for creating the Project Metadata
To create a Report Prompt
Shortcut in MSTR Desktop
Report Filter
19. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
Rollback your changes
Sample Metrics commonly performed on Facts
File > Email Reports As
20. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Characteristics of a Compound Table Key
Simple Attribute Expression
Project Source
MSTR applications
21. It contains the ID column of all higher-level attributes
Objects you are allowed to Page-by
Heterogeneous Attribute
Thresholding
Lookup Table structure of a moderately denormalized schema
22. One that uses 2 or more columns as its ID
Compound Attribute
4 types of Prompts
MSTR OLAP Services
4 types of Report Filters
23. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Report Definitions
Required on the report for Outline Model to work
3 functions of Attribute Forms
Relationship Tables
24. The default entry-points.
Project Creation Wizard
The 3 MSTR Tools
Highest-level attributes
2 options for Sorting
25. OLAP Services does not add any ______ to the report query.
New SQL
Locking and Resizing
Notes
Cannot create project objects
26. OLTP data storage measure
MSTR Desktop Architect
Object Prompts
Gigabytes (GB)
Limitations of the Attribute Creation Wizard
27. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Unlimited
To "drill down" on a report
Search Object
28. It contains links to specific folders in the Folder List
2 options for Sorting
The System
Architect Graphical Interface
Shortcut Bar
29. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
4 basic Schema objects
View Filter
Configuration Wizard
Sorting
30. User reporting requirements - Query performance - Data volume - DB Maintenance
ETL
4 basic Schema objects
4 factors to consider when designing a data-warehouse schema
Attribute Creation Wizard good for
31. Enables you to lock column headers so that they always appear when scrolling
Report Subscription
Locking and Resizing
2 types of Fact Expressions
The 3 MSTR Tools
32. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Project
Aggregate a Metric
New SQL
MSTR OLAP Services
33. OLAP retains data ________
Subtotals
Derived Metrics
To "drill down" on a report
Long-term (2 - 5 years)
34. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
View Filters
Types of drilling
2 methods to creating Facts
5 Report display views
35. Less storage - Simple SQL - Complex ETL
OLTP
2 methods to creating Facts
3 Methods of MSTR Desktop navigation
Characteristics of a Simple Table Key
36. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Required on the report for Outline Model to work
Source system characteristics
The 3 MSTR Tools
2 types of Table Keys
37. Used to modify a Report
3 column types of a Physical Schema
Report Editor
Components of the Logical Data Model
Nested Metrics
38. Facts - Attributes - Hierarchies
Report Definitions
Components of the Logical Data Model
User Hierarchies
2 components of a Physical Schema
39. 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
2 components of a Physical Schema
Simple Metrics
Short-term (2 - 6 months)
Characteristics of a Compound Table Key
40. To see data at completely different levels - other than that of the original Grid or Graph
Rollback your changes
New SQL
Desktop Administrative Functions
Drilling
41. Simple - Compound - Nested - Derived
4 types of Metrics
Search Object
Sorting
Minimal or none
42. The actual column name for a fact. Every fact must have at least 1 expression.
2 options for Sorting
Metrics
Page-by
Fact Expression
43. ID columns - Description columns - Fact columns
Schema
2 methods to creating Facts
3 column types of a Physical Schema
Default Project folder structure
44. Level of OLAP integration
Tasks when defining a User Hierarchy
View Filters
User Hierarchies
Very high; part of ETL process
45. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
Using a Search Object
Desktop Administrative Functions
Locking and Resizing
46. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Characteristics of a Simple Table Key
3 components of a Report
Using a Search Object
47. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Homogeneous Attribute
Types of analysis you can perform with OLAP Services
Fact Tables
View Filters
48. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Components of a Metric
Sorting
Report Template
49. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Terabytes (TB)
Lookup Table structure of a completely normalized schema
Objects you are allowed to Page-by
Source system characteristics
50. 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.
Gigabytes (GB)
View Filters
To "drill down" on a report
Facts