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. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Report Filter operators
Level Prompts
3 Schema types
Data Pivoting
2. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Relationship Tables
To create a Report Prompt
Aggregate a Metric
3. Used to modify a Report
Components of Compound Metrics
The System
Lookup Table structure of a completely normalized schema
Report Editor
4. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Components of a MSTR architecture
4 tasks of the Attribute Creation Wizard
Column Aliases
Data warehouse characteristics
5. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
To save a Report Format
OLAP
Schema Object Editor
New SQL
6. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
2 options for Sorting
Hierarchies
4 properties you must know in order to create attributes using the Attribute Editor
Very high; part of ETL process
7. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Derived Attribute Expression
Architect Graphical Interface
3 types of Attributes
8. An environment in which the MSTR Desktop connects directly to the Metadata database.
4 parts of the Project Design Process
Schema
Very high; part of ETL process
2-Tier Architecture
9. A development environment to create BI applications - allowing users to edit the Metadata database
Data Pivoting
2 types of Table Keys
Locking and Resizing
Desktop Architec
10. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To save a Report Format
Components of a MSTR architecture
2-Tier Architecture
Types of analysis you can perform with OLAP Services
11. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
5 steps to creating a logical data model
Project
2 methods to creating Facts
Data Pivoting
12. Compound - Homogeneous - Heterogeneous
Desktop Architec
3 types of Attributes
Search Object
Architect Graphical Interface
13. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
2 types of Fact Expressions
Simple Attribute Expression
Sample Metrics commonly performed on Facts
The System
14. Metrics aggregate on the lowest-level attribute __________.
Objects you are allowed to Page-by
The System
By default
MSTR Connectivity Wizard
15. The Attribute Form maps to the same column name in multiple tables
Default Project folder structure
Homogeneous Attribute
By default
Characteristics of a Simple Table Key
16. How users can share comments for reports to other users
3 Schema types
Project Source
Notes
Report Editor
17. You can e-mail reports by going to _____
5 steps to creating a logical data model
Report Filter
Heterogeneous Fact
File > Email Reports As
18. OLAP data storage measure
2 components of a Physical Schema
Components of the Logical Data Model
User Hierarchies
Terabytes (TB)
19. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Architect Graphical Interface
Page-by
2 types of Fact Expressions
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 Objects
Reference Report Objects
Report Prompts
To create the Project connectivity
21. Simple - Derived
Shortcut Bar
2 types of Attribute Expression
Column Aliases
Compound Attribute
22. Direct: 2-tier - Server: 3-tier
Components of a MSTR architecture
2 types of Fact Expressions
2 ways you can configure the Project Source to connect to the Metadata database
Search-based prompts
23. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
To edit the appearance of a Graph in a report
Desktop Analyst
Attribute or its relationship(s)
24. More storage - Complex SQL - Simple ETL
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Compound Table Key
Architect Graphical Interface
Table Keys
25. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Fact Tables
3 Methods of MSTR Desktop navigation
Components of a Derived Metric
ETL
26. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Process for creating the Project Metadata
Stored
2-Tier Architecture
Attribute or its relationship(s)
27. It contains links to specific folders in the Folder List
Limitations of the Attribute Creation Wizard
ETL
Shortcut Bar
2 types of Fact Expressions
28. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Subtotals
Column Aliases
Components of a Derived Metric
4 types of Metrics
29. Create the Project Source - Create the Database Instance
Value Prompts
2 types of Attribute Relationships
To create the Project connectivity
Heterogeneous Attribute
30. Enables you to lock column headers so that they always appear when scrolling
Tasks when defining a User Hierarchy
Minimal or none
Derived Metrics
Locking and Resizing
31. Less storage - Simple SQL - Complex ETL
Project Source
Characteristics of a Simple Table Key
Relationship Tables
Object Prompts
32. Must have a one-to-one relationship with all other forms.
Drilling
Attribute Forms
Components of the Logical Data Model
Homogeneous Attribute
33. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Components of a Derived Metric
Drilling
To "drill down" on a report
Column Aliases
34. 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
Project Creation Wizard
To edit the appearance of a Graph in a report
Report Definitions
35. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
By default
New SQL
Application Objects
Project-level options/settings
36. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Configuration Wizard
Schema
Report Definitions
37. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
3 Sections of the MSTR Desktop interface
Schema Objects
Sorting
Schema
38. Filter definition prompts - Object prompts - Value prompts - Level prompts
Methods are there to creating Attributes
Search Object
Components of Compound Metrics
4 types of Prompts
39. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
4 basic Schema objects
Long-term (2 - 5 years)
2 components of a Physical Schema
OLTP
40. Facts associated to the same column name in 1 or more tables
OLTP
Short-term (2 - 6 months)
Schema Object Editor
Homogeneous Fact
41. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Application Objects
Desktop Designer
By default
42. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Banding
Using a Search Object
Locking and Resizing
43. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
2 options for Sorting
Different methods for creating Page-by fields
2 types of Fact Expressions
Filter Definition Prompts
44. Primary keys
Report Filter operators
4 factors to consider when designing a data-warehouse schema
To edit the appearance of a Graph in a report
Table Keys
45. Enables you to select which tables from the data-warehouse to store in the Metadata database
Subtotals
Warehouse Catalog
4 factors to consider when designing a data-warehouse schema
Data Pivoting
46. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
ID form
Default Project folder structure
To edit the appearance of a Graph in a report
Physical Schema
47. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
ETL
Report Subscription
New SQL
48. Subtotals reflect accumulations at selected attribute levels
Report Prompts
2 types of Attribute Expression
To edit the appearance of a Graph in a report
Subtotals
49. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Desktop Analyst
To create a Report Prompt
4 types of Prompts
50. 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
Heterogeneous Attribute
View Filters
New SQL
4 types of Report Filters