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. Simple - Derived
Process for creating the Project Metadata
2 types of Attribute Expression
3 Schema types
4 types of Report Filters
2. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
4 parts of the Project Design Process
2 components of a Physical Schema
Aggregate a Metric
3. User requirements - Existing source data - Technical and performance considerations
Facts
MSTR OLAP Services
Factors to consider when designing a logical data model
Fact Tables
4. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Minimal or none
2 types of Attribute Relationships
The System
MSTR applications
5. View Filters are saved with the _____________.
MSTR applications
Configuration Wizard
Report Definitions
Cannot create project objects
6. It contains links to specific folders in the Folder List
Fact Tables
Shortcut Bar
Relationship Tables
Desktop Analyst
7. Used to limit a possibly overwhelming set of potential prompt answers
4 basic Schema objects
Locking and Resizing
Lookup Table structure of a completely denormalized schema
Search-based prompts
8. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Display views you can Print by
Homogeneous Fact
4 tasks of the Attribute Creation Wizard
The System
9. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Limitations of the Attribute Creation Wizard
Data warehouse characteristics
2 options for Sorting
10. It contains the ID and DESC columns of all higher-level attributes
Sample Metrics commonly performed on Facts
Process for creating the Project Metadata
Lookup Table structure of a completely denormalized schema
3 column types of a Physical Schema
11. Columns - Tables
Architect Graphical Interface
2 components of a Physical Schema
Reference Report Objects
Hierarchies
12. OLTP retains data ________
Short-term (2 - 6 months)
Reports
5 steps to creating a logical data model
MSTR Desktop
13. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Components of a Metric
Components of a Derived Metric
OLTP
2 options for Sorting
14. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
3 Methods of MSTR Desktop navigation
2 types of Fact Expressions
Report Formatting
15. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Search-based prompts
Physical Schema
Value Prompts
16. It contains the ID column of the parent attribute
Derived Metrics
Lookup Table structure of a completely normalized schema
Lookup Table structure of a completely denormalized schema
Schema Object Editor
17. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Attribute or its relationship(s)
Methods are there to creating Attributes
Homogeneous Fact
18. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Components of a MSTR architecture
Objects you are allowed to Page-by
Configuration Wizard
3 Sections of the MSTR Desktop interface
19. 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.
4 tasks of the Attribute Creation Wizard
3 Schema types
User Hierarchies
Report Prompts
20. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
Report Definitions
Outline Mode
Report Filter
21. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
2 ways you can configure the Project Source to connect to the Metadata database
Limitations of the Attribute Creation Wizard
Shortcut Bar
2 types of Facts
22. To define the level of aggregation for a specific metric - Used for qualifications
Using a Search Object
Homogeneous Attribute
Long-term (2 - 5 years)
Attributes
23. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Display views you can Print by
View Filter
Physical Schema
The System
24. Level of OLAP integration
3 Methods of MSTR Desktop navigation
Very high; part of ETL process
Page-by
To create a Report Prompt
25. A condition data must meet in order to be included in a report. Does affect the SQL.
View Filter
Report Filter
Using a Search Object
Project
26. Facts associated to different column names in 2 or more tables
MSTR applications
'View of a Report'
4 types of Report Filters
Heterogeneous Fact
27. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Value Prompts
4 tasks of the Attribute Creation Wizard
Metrics
28. An environment in which the MSTR Desktop connects directly to the Metadata database.
Homogeneous Attribute
ID form
2-Tier Architecture
Thresholding
29. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Advantage of a completely denormalized schema
Attribute Forms
Characteristics of a Compound Table Key
30. Tables - Facts - Attributes - Hierarchies
2 types of Attribute Expression
2 types of Facts
4 basic Schema objects
By default
31. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
3 Sections of the MSTR Desktop interface
Desktop Administrative Functions
Characteristics of Nested Metrics
Column Aliases
32. Template - Filter - View of a Report
Report Definitions
'View of a Report'
3 components of a Report
Attribute or its relationship(s)
33. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Types of analysis you can perform with OLAP Services
Compound Attribute
Advantage of a completely denormalized schema
Desktop Designer
34. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Configuration Wizard
Locking and Resizing
Report Formatting
3 Types of Objects in MSTR Desktop
35. View Filters can only ___________.
Reference Report Objects
Locking and Resizing
Simple Attribute Expression
Report Filter operators
36. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Types of drilling
Logical Data Model
Very high; part of ETL process
Subtotals
37. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
3-Tier Architecture
Minimal or none
Schema Objects
38. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Value Prompts
Level Prompts
Sample Metrics commonly performed on Facts
Desktop Architec
39. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project
Warehouse Catalog
Application Objects
Project Source
40. What tool do you use to create the Metadata DSN connection?
Report Editor
View Filters
Limitations of the Attribute Creation Wizard
MSTR Connectivity Wizard
41. The unique values of an attribute obtained from the data-warehouse
Fact Expression
Attribute Elements
File types are allowed for exporting a Report
Report Filter
42. You can e-mail reports by going to _____
Components of a Derived Metric
Using a Search Object
File > Email Reports As
Logical Data Model
43. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
To qualify a Metric in a Set Qualification
Thresholding
Report Template
44. Folder List - Object Viewer - Shortcut Bar
3 functions of Attribute Forms
3 Sections of the MSTR Desktop interface
Hierarchies
3 components of a Report
45. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3 Methods of MSTR Desktop navigation
3-Tier Architecture
Attribute or its relationship(s)
2 ways you can configure the Project Source to connect to the Metadata database
46. A development environment to create BI applications - allowing users to edit the Metadata database
Subtotals
ETL
2 types of Attribute Relationships
Desktop Architec
47. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
OLTP
Column Aliases
Using a Search Object
5 steps to creating a logical data model
48. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
2 components of a Physical Schema
Characteristics of a Compound Table Key
Warehouse Catalog
49. Used for - Initially populating the Metadata - Creating schema objects
3 Sections of the MSTR Desktop interface
MSTR Desktop Architect
2 types of Table Keys
Unlimited
50. 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
Project Creation Wizard
Types of drilling
Report Formatting
Objects you are allowed to Page-by