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. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Report Formatting
Objects you are allowed to Page-by
Methods are there to creating Attributes
2. 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
Aggregate a Metric
3-Tier Architecture
Derived Attribute Expression
Types of drilling
3. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Reference Report Objects
To "drill down" on a report
Methods are there to creating Attributes
Value Prompts
4. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Simple Attribute Expression
4 properties you must know in order to create attributes using the Attribute Editor
Attribute or its relationship(s)
To create the Project connectivity
5. Tables - Facts - Attributes - Hierarchies
Column Aliases
Gigabytes (GB)
Schema
4 basic Schema objects
6. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
4 types of Metrics
Architect Graphical Interface
Outline Mode
Report Prompts
7. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Physical Schema
3 types of Attributes
MSTR applications
Desktop Designer
8. OLTP retains data ________
Notes
Short-term (2 - 6 months)
Facts
To edit the appearance of a Graph in a report
9. All report-level options overwrite ___________.
Project-level options/settings
2 ways you can configure the Project Source to connect to the Metadata database
4 basic Schema objects
Short-term (2 - 6 months)
10. Top menu/dropdowns - Toolbar - Right-click popup menus
MSTR Desktop Architect
3 Methods of MSTR Desktop navigation
4 types of Report Filters
Report Formatting
11. OLAP retains data ________
Outline Mode
Object Prompts
Default Project folder structure
Long-term (2 - 5 years)
12. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
View Filters
Attribute Elements
Desktop Designer
Project Source
13. The Attribute Form maps to the same column name in multiple tables
Unlimited
Warehouse Catalog
Schema Objects
Homogeneous Attribute
14. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
3 Types of Objects in MSTR Desktop
4 factors to consider when designing a data-warehouse schema
Factors to consider when designing a logical data model
15. Metrics that perform multiple aggregations; one calculation inside of another.
To edit the appearance of a Graph in a report
2 types of Attribute Expression
Project
Nested Metrics
16. Less storage - Simple SQL - Complex ETL
2 types of Facts
Project
Characteristics of a Simple Table Key
Cannot create project objects
17. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Architect Graphical Interface
4 tasks of the Attribute Creation Wizard
5 steps to creating a logical data model
Aggregate a Metric
18. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Lookup Table structure of a completely denormalized schema
Long-term (2 - 5 years)
Characteristics of a Compound Table Key
Schema Object Editor
19. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Search-based prompts
Locking and Resizing
Characteristics of a Compound Table Key
Object Prompts
20. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
To save a Report Format
Process for creating the Project Metadata
Nested Metrics
Reports
21. Primary keys
5 Report display views
Table Keys
Report Definitions
Characteristics of a Simple Table Key
22. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
2 types of Attribute Expression
File types are allowed for exporting a Report
MSTR Desktop
OLAP
23. Metrics aggregate on the lowest-level attribute __________.
By default
MSTR Desktop Architect
Drilling
OLAP
24. Used to modify a Report
Report Editor
MSTR applications
Search Object
Locking and Resizing
25. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Attribute or its relationship(s)
File types are allowed for exporting a Report
Desktop Administrative Functions
3 Types of Objects in MSTR Desktop
26. View Filters are saved with the _____________.
Objects you are allowed to Page-by
Report Definitions
To qualify a Metric in a Set Qualification
Attribute Relationships
27. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Stored
Attribute Forms
Lookup Table structure of a moderately denormalized schema
28. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Nested Metrics
2 methods to creating Facts
Heterogeneous Fact
3 components of a Report
29. Compound - Homogeneous - Heterogeneous
2 types of Attribute Relationships
Shortcut in MSTR Desktop
Thresholding
3 types of Attributes
30. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
3 project creation interfaces
3 types of Attributes
Source system characteristics
Short-term (2 - 6 months)
31. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Hierarchies
Simple Metrics
2 types of Attribute Relationships
3-Tier Architecture
32. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Process for creating the Project Metadata
Stored
By default
Heterogeneous Attribute
33. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Long-term (2 - 5 years)
Components of a Metric
Lookup Table structure of a completely normalized schema
34. 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
Desktop Analyst
Thresholding
View Filters
Default Project folder structure
35. Level of OLTP integration
Architect Graphical Interface
Report Definitions
Minimal or none
4 types of Metrics
36. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
3 column types of a Physical Schema
Metrics
Attribute Creation Wizard good for
Objects you are allowed to Page-by
37. Enables you to select and display subsets of a report as separate pages.
Schema Object Editor
4 types of Report Filters
Page-by
Cannot create project objects
38. Used to "fine-tune" your Project
Tasks when defining a User Hierarchy
Minimal or none
Report Template
Architect Graphical Interface
39. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Default Project folder structure
Facts
4 basic Schema objects
Data Pivoting
40. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Thresholding
Shortcut Bar
4 properties you must know in order to create attributes using the Attribute Editor
41. Descriptive data that provides context for Facts.
MSTR Connectivity Wizard
Attribute Forms
Long-term (2 - 5 years)
Fact Tables
42. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Attribute Forms
Reports
Fact Expression
43. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Characteristics of a Simple Table Key
4 parts of the Project Design Process
Components of a Derived Metric
MSTR Connectivity Wizard
44. Simple - Compound - Nested - Derived
View Filters
4 types of Metrics
Minimal or none
Schema
45. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Search Object
2 types of Table Keys
Data warehouse characteristics
46. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Column Aliases
3 project creation interfaces
3 functions of Attribute Forms
Search Object
47. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Shortcut in MSTR Desktop
Search Object
Homogeneous Attribute
48. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
2 ways you can configure the Project Source to connect to the Metadata database
Attribute or its relationship(s)
Report Prompts
49. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Highest-level attributes
Rollback your changes
Facts
Report Objects
50. Creating multiple attributes quickly. Used during the initial project creation.
Desktop Architec
Unlimited
Components of the Logical Data Model
Attribute Creation Wizard good for