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. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
New SQL
Schema
2 methods to creating Facts
5 Report display views
2. A development environment to create BI applications - allowing users to edit the Metadata database
Compound Attribute
Metrics
Value Prompts
Desktop Architec
3. Enables you to format report values based on a condition - such as highlights - font colors - etc.
4 types of Metrics
Homogeneous Attribute
Thresholding
To create a Report Prompt
4. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
5 steps to creating a logical data model
4 parts of the Project Design Process
Report Objects
Metrics
5. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
MSTR applications
Required on the report for Outline Model to work
Source system characteristics
Fact Tables
6. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of Nested Metrics
File > Email Reports As
Reports
Desktop Designer
7. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Nested Metrics
To drill through User Hierarchies
Cannot create project objects
Architect Graphical Interface
8. ID columns - Description columns - Fact columns
Shortcut in MSTR Desktop
3 column types of a Physical Schema
Attribute or its relationship(s)
Architect Graphical Interface
9. User requirements - Existing source data - Technical and performance considerations
ETL
Factors to consider when designing a logical data model
Metrics
3 types of Attributes
10. Direct: 2-tier - Server: 3-tier
Configuration Wizard
Physical Schema
2 ways you can configure the Project Source to connect to the Metadata database
ID form
11. Metrics aggregate on the lowest-level attribute __________.
Components of a Derived Metric
By default
Attribute Forms
Derived Attribute Expression
12. To define the level of aggregation for a specific metric - Used for qualifications
MSTR Desktop Architect
Types of drilling
Attributes
The System
13. All Attributes must have an _______.
To drill through User Hierarchies
Advantage of a completely denormalized schema
MSTR applications
ID form
14. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Factors to consider when designing a logical data model
Column Aliases
Sorting
Derived Metrics
15. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Different methods for creating Page-by fields
Report Subscription
Process for creating the Project Metadata
The System
16. 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
Report Filter
3 Schema types
Reference Report Objects
Locking and Resizing
17. Primary keys
Fact Expression
Table Keys
Object Prompts
Simple Attribute Expression
18. Groupings of directly related attributes. Also commonly known as "dimensions".
Limitations of the Attribute Creation Wizard
3 project creation interfaces
Desktop Architec
Hierarchies
19. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Tasks when defining a User Hierarchy
Report Prompts
Schema Objects
3 Types of Objects in MSTR Desktop
20. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Display views you can Print by
Value Prompts
4 properties you must know in order to create attributes using the Attribute Editor
Components of a Derived Metric
21. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Derived Metrics
Short-term (2 - 6 months)
Hierarchies
2 methods to creating Facts
22. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Stored
2 ways you can configure the Project Source to connect to the Metadata database
Components of the Logical Data Model
23. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
ETL
Lookup Table structure of a completely denormalized schema
3 Methods of MSTR Desktop navigation
24. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Lookup Table structure of a moderately denormalized schema
Schema Objects
Stored
ETL process
25. OLAP Services does not add any ______ to the report query.
Data Pivoting
Schema Object Editor
New SQL
Relationship Tables
26. More storage - Complex SQL - Simple ETL
Characteristics of a Simple Table Key
Characteristics of a Compound Table Key
2 components of a Physical Schema
Architect Graphical Interface
27. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Process for creating the Project Metadata
Subtotals
Report Objects
Aggregate a Metric
28. All report-level options overwrite ___________.
Fact Expression
Project-level options/settings
MSTR applications
Architect Graphical Interface
29. Must have a one-to-one relationship with all other forms.
By default
3 components of a Report
Physical Schema
Attribute Forms
30. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
ETL process
Project Creation Wizard
Search-based prompts
Aggregate a Metric
31. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Homogeneous Fact
3 Schema types
Schema Object Editor
32. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Banding
2 types of Attribute Relationships
Sample Metrics commonly performed on Facts
Facts
33. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Source system characteristics
Report Objects
Aggregate a Metric
Compound Metric
34. OLTP retains data ________
Attribute Creation Wizard good for
Schema Object Editor
Report Objects
Short-term (2 - 6 months)
35. Simple - Derived
Architect Graphical Interface
2 types of Attribute Expression
Report Editor
4 types of Prompts
36. View Filters can only ___________.
Reference Report Objects
Attribute or its relationship(s)
Homogeneous Fact
Report Formatting
37. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
Banding
View Filters
Report Objects
38. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Characteristics of Nested Metrics
Aggregate a Metric
To edit the appearance of a Graph in a report
View Filters
39. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Different methods for creating Page-by fields
Components of a MSTR architecture
Data warehouse characteristics
MSTR Desktop Architect
40. OLAP retains data ________
Reference Report Objects
4 types of Report Filters
Long-term (2 - 5 years)
Report Editor
41. 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
Facts
To create a Report Prompt
Characteristics of a Simple Table Key
Simple Metrics
42. Level of OLAP integration
Very high; part of ETL process
Schema Object Editor
Methods are there to creating Attributes
Gigabytes (GB)
43. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Lookup Table structure of a completely denormalized schema
Components of Compound Metrics
Stored
4 basic Schema objects
44. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
MSTR Connectivity Wizard
Fact Expression
Desktop Architec
45. A user interface for creating and maintaining a BI environment
MSTR Desktop
Object Prompts
To qualify a Metric in a Set Qualification
2 types of Table Keys
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Stored
Architect Graphical Interface
MSTR applications
The 3 MSTR Tools
47. Metrics you create within a report using only those objects in the report.
Rollback your changes
Report Subscription
Data warehouse characteristics
Derived Metrics
48. To see data at completely different levels - other than that of the original Grid or Graph
Heterogeneous Attribute
Process for creating the Project Metadata
Drilling
4 basic Schema objects
49. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Level Prompts
To "drill down" on a report
Relationship Tables
Lookup Tables
50. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Application Objects
Display views you can Print by
Simple Metrics