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. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Required on the report for Outline Model to work
Types of analysis you can perform with OLAP Services
Default Project folder structure
Fact Tables
2. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Derived Metrics
Attribute Forms
2 methods to creating Facts
MSTR Desktop Architect
3. Schema Objects - Application Objects - Configuration Objects
To drill through User Hierarchies
Process for creating the Project Metadata
3 Types of Objects in MSTR Desktop
2-Tier Architecture
4. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
4 tasks of the Attribute Creation Wizard
To qualify a Metric in a Set Qualification
To "drill down" on a report
Types of analysis you can perform with OLAP Services
5. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
4 basic Schema objects
Default Project folder structure
Physical Schema
Using a Search Object
6. Filter definition prompts - Object prompts - Value prompts - Level prompts
By default
3 Types of Objects in MSTR Desktop
2 options for Sorting
4 types of Prompts
7. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Project Source
Desktop Administrative Functions
Attribute Forms
2 types of Fact Expressions
8. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
OLAP
Object Prompts
Attribute Relationships
Notes
9. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
3 functions of Attribute Forms
Components of Compound Metrics
Factors to consider when designing a logical data model
The System
10. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Warehouse Catalog
Attribute Forms
Architect Graphical Interface
11. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
File > Email Reports As
4 parts of the Project Design Process
Shortcut in MSTR Desktop
Unlimited
12. A feature that enables users to delivers reports to the history list - cache or mobile
To create the Project connectivity
File types are allowed for exporting a Report
MSTR Desktop
Report Subscription
13. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
4 parts of the Project Design Process
Components of Compound Metrics
File types are allowed for exporting a Report
Metrics
14. Columns - Tables
Search Object
2 components of a Physical Schema
Project Source
Desktop Administrative Functions
15. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Report Formatting
Rollback your changes
To edit the appearance of a Graph in a report
Different methods for creating Page-by fields
16. Used for - Initially populating the Metadata - Creating schema objects
Configuration Wizard
Heterogeneous Attribute
4 types of Report Filters
MSTR Desktop Architect
17. Enables you to select and display subsets of a report as separate pages.
Project-level options/settings
Page-by
3 Methods of MSTR Desktop navigation
Minimal or none
18. 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
Physical Schema
3 project creation interfaces
OLTP
Simple Metrics
19. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
MSTR Desktop
Reference Report Objects
Limitations of the Attribute Creation Wizard
Lookup Table structure of a moderately denormalized schema
20. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
3 Schema types
3-Tier Architecture
Banding
21. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Components of the Logical Data Model
Cannot create project objects
Schema Object Editor
4 types of Metrics
22. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Desktop Architec
The System
4 types of Report Filters
2 types of Attribute Expression
23. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
'View of a Report'
MSTR Connectivity Wizard
Reports
5 steps to creating a logical data model
24. A user interface for creating and maintaining a BI environment
File types are allowed for exporting a Report
Advantage of a completely denormalized schema
Attribute or its relationship(s)
MSTR Desktop
25. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
Long-term (2 - 5 years)
To create the Project connectivity
Schema Objects
26. More storage - Complex SQL - Simple ETL
Project Source
2 types of Facts
MSTR applications
Characteristics of a Compound Table Key
27. The Attribute Form maps to different column names in multiple tables
MSTR Desktop Architect
Report Filter
File > Email Reports As
Heterogeneous Attribute
28. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
29. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Compound Metric
Derived Attribute Expression
Reports
30. User reporting requirements - Query performance - Data volume - DB Maintenance
3 Types of Objects in MSTR Desktop
4 factors to consider when designing a data-warehouse schema
Report Filter
Attribute Creation Wizard good for
31. View Filters are saved with the _____________.
Architect Graphical Interface
Types of analysis you can perform with OLAP Services
Architect Graphical Interface
Report Definitions
32. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
5 steps to creating a logical data model
Simple Attribute Expression
Stored
Report Filter
33. Level of OLTP integration
Lookup Table structure of a completely normalized schema
Page-by
3 column types of a Physical Schema
Minimal or none
34. Used to "fine-tune" your Project
Physical Schema
3 project creation interfaces
Architect Graphical Interface
Minimal or none
35. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Project-level options/settings
Lookup Tables
Attribute Creation Wizard good for
2 types of Table Keys
36. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Data Pivoting
Application Objects
MSTR applications
MSTR Desktop Architect
37. You can e-mail reports by going to _____
To save a Report Format
Project Source
File > Email Reports As
Level Prompts
38. AND - OR - OR NOT - AND NOT
'View of a Report'
5 steps to creating a logical data model
Report Filter operators
Components of a Derived Metric
39. OLAP retains data ________
Long-term (2 - 5 years)
3 Sections of the MSTR Desktop interface
Thresholding
Default Project folder structure
40. Enables you to format report values based on a condition - such as highlights - font colors - etc.
3 Schema types
Search-based prompts
Simple Attribute Expression
Thresholding
41. An environment in which the MSTR Desktop connects directly to the Metadata database.
Schema Object Editor
Reports
2-Tier Architecture
3 Schema types
42. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Object Prompts
Schema Objects
Objects you are allowed to Page-by
'View of a Report'
43. 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 Prompts
View Filter
4 properties you must know in order to create attributes using the Attribute Editor
Logical Data Model
44. Enables you to rearrange the columns and rows in a report.
Desktop Designer
Table Keys
4 tasks of the Attribute Creation Wizard
Data Pivoting
45. One that uses 2 or more columns as its ID
Compound Attribute
Facts
Long-term (2 - 5 years)
MSTR applications
46. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Components of a Derived Metric
Lookup Table structure of a moderately denormalized schema
Homogeneous Attribute
47. What tool do you use to create the Metadata DSN connection?
Metrics
4 types of Prompts
MSTR Connectivity Wizard
Lookup Table structure of a completely denormalized schema
48. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Homogeneous Fact
Compound Metric
Logical Data Model
'View of a Report'
49. Creating multiple attributes quickly. Used during the initial project creation.
Reference Report Objects
Stored
Project-level options/settings
Attribute Creation Wizard good for
50. Compound - Homogeneous - Heterogeneous
Report Editor
Search Object
Data warehouse characteristics
3 types of Attributes