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. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
3 types of Attributes
Desktop Analyst
Different methods for creating Page-by fields
Required on the report for Outline Model to work
2. Used to modify a Report
User Hierarchies
Fact Expression
Report Editor
Components of a Metric
3. 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
3 Schema types
Attribute Creation Wizard good for
Lookup Tables
Table Keys
4. Extraction - transformation - loading
Characteristics of a Compound Table Key
Warehouse Catalog
3 project creation interfaces
ETL
5. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
User Hierarchies
Characteristics of Nested Metrics
Very high; part of ETL process
Components of Compound Metrics
6. Create the Project Source - Create the Database Instance
2 ways you can configure the Project Source to connect to the Metadata database
Search-based prompts
To create the Project connectivity
Report Subscription
7. Primary keys
Table Keys
Aggregate a Metric
Lookup Table structure of a completely normalized schema
Components of Compound Metrics
8. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
3 column types of a Physical Schema
Page-by
Limitations of the Attribute Creation Wizard
2 methods to creating Facts
9. Creating multiple attributes quickly. Used during the initial project creation.
ETL process
Attribute Creation Wizard good for
Report Prompts
2 types of Facts
10. ID columns - Description columns - Fact columns
OLAP
3 column types of a Physical Schema
Lookup Table structure of a completely normalized schema
To create the Project connectivity
11. View Filters can only ___________.
OLTP
Reference Report Objects
5 steps to creating a logical data model
Project-level options/settings
12. Columns - Tables
2 methods to creating Facts
Shortcut Bar
Warehouse Catalog
2 components of a Physical Schema
13. Simple - Derived
Search Object
Derived Metrics
Table Keys
2 types of Attribute Expression
14. Must have Subtotals enabled - or you won't see any data for higher-level attributes
2 types of Fact Expressions
Data warehouse characteristics
Attribute Relationships
Required on the report for Outline Model to work
15. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Heterogeneous Attribute
2 types of Table Keys
Report Filter operators
Attribute or its relationship(s)
16. The Attribute Form maps to the same column name in multiple tables
Application Objects
By default
Homogeneous Attribute
Different methods for creating Page-by fields
17. User reporting requirements - Query performance - Data volume - DB Maintenance
Desktop Administrative Functions
Attribute Elements
4 factors to consider when designing a data-warehouse schema
Factors to consider when designing a logical data model
18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Shortcut in MSTR Desktop
3 functions of Attribute Forms
Unlimited
Components of a MSTR architecture
19. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Components of the Logical Data Model
Warehouse Catalog
Components of a MSTR architecture
20. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Locking and Resizing
Report Prompts
2 options for Sorting
Stored
21. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Physical Schema
File > Email Reports As
Project Source
User Hierarchies
22. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
4 properties you must know in order to create attributes using the Attribute Editor
MSTR OLAP Services
Sample Metrics commonly performed on Facts
To edit the appearance of a Graph in a report
23. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
3 Sections of the MSTR Desktop interface
Cannot create project objects
3 Methods of MSTR Desktop navigation
24. A user interface for creating and maintaining a BI environment
Process for creating the Project Metadata
MSTR Desktop
Logical Data Model
OLAP
25. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
3 functions of Attribute Forms
Heterogeneous Attribute
Limitations of the Attribute Creation Wizard
Process for creating the Project Metadata
26. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Fact Expression
4 types of Metrics
Schema Object Editor
Default Project folder structure
27. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Data warehouse characteristics
Reference Report Objects
Using a Search Object
Methods are there to creating Attributes
28. A feature that enables users to delivers reports to the history list - cache or mobile
Attribute Forms
To create a Report Prompt
MSTR Desktop
Report Subscription
29. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Long-term (2 - 5 years)
Application Objects
To edit the appearance of a Graph in a report
Short-term (2 - 6 months)
30. An environment in which the MSTR Desktop connects directly to the Metadata database.
Report Filter
Level Prompts
2-Tier Architecture
Gigabytes (GB)
31. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Subtotals
Objects you are allowed to Page-by
Components of Compound Metrics
Report Filter
32. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Components of the Logical Data Model
4 types of Report Filters
OLAP
4 parts of the Project Design Process
33. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Schema Objects
Report Definitions
The 3 MSTR Tools
OLAP
34. You can _____________ in the Architect Graphical Interface.
ETL process
Report Definitions
Architect Graphical Interface
Rollback your changes
35. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Search-based prompts
Architect Graphical Interface
Outline Mode
36. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Report Editor
Components of a MSTR architecture
Column Aliases
Facts
37. Metrics that perform multiple aggregations; one calculation inside of another.
Components of the Logical Data Model
Nested Metrics
Process for creating the Project Metadata
Architect Graphical Interface
38. Facts - Attributes - Hierarchies
Notes
Components of the Logical Data Model
Table Keys
5 Report display views
39. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
MSTR OLAP Services
Compound Metric
3 Schema types
Attribute Forms
40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Characteristics of Nested Metrics
Metrics
Schema
41. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Limitations of the Attribute Creation Wizard
Derived Metrics
2 components of a Physical Schema
42. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Components of Compound Metrics
Project Creation Wizard
5 Report display views
Report Template
43. Template - Filter - View of a Report
Table Keys
3 components of a Report
Report Filter operators
3 Types of Objects in MSTR Desktop
44. OLTP retains data ________
3 components of a Report
Short-term (2 - 6 months)
Report Subscription
Project-level options/settings
45. Folder List - Object Viewer - Shortcut Bar
Desktop Analyst
User Hierarchies
3 Sections of the MSTR Desktop interface
Reports
46. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Attribute Relationships
Search Object
Minimal or none
47. It contains links to specific folders in the Folder List
Heterogeneous Fact
Components of a Metric
Default Project folder structure
Shortcut Bar
48. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Desktop Architec
Derived Metrics
Simple Metrics
49. 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
2 methods to creating Facts
Default Project folder structure
Reference Report Objects
ETL process
50. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Level Prompts
Attribute Elements
Components of a Derived Metric