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. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
The System
Schema Objects
Shortcut Bar
To drill through User Hierarchies
2. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Cannot create project objects
Desktop Designer
3 column types of a Physical Schema
Sample Metrics commonly performed on Facts
3. It contains the ID and DESC columns of all higher-level attributes
Attribute Forms
Gigabytes (GB)
Lookup Table structure of a completely denormalized schema
To save a Report Format
4. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Heterogeneous Fact
Facts
Factors to consider when designing a logical data model
5. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Tasks when defining a User Hierarchy
Schema
New SQL
To create the Project connectivity
6. You can e-mail reports by going to _____
File > Email Reports As
5 steps to creating a logical data model
2 types of Fact Expressions
Report Editor
7. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Heterogeneous Fact
Architect Graphical Interface
Components of a Metric
Process for creating the Project Metadata
8. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
New SQL
2 options for Sorting
Project Source
Default Project folder structure
9. An environment in which the MSTR Desktop connects directly to the Metadata database.
Drilling
Terabytes (TB)
MSTR Desktop Architect
2-Tier Architecture
10. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Different methods for creating Page-by fields
Reports
Reference Report Objects
Report Filter operators
11. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Report Filter operators
3 Types of Objects in MSTR Desktop
Advantage of a completely denormalized schema
12. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Fact Expression
Derived Metrics
Configuration Wizard
View Filters
13. Facts associated to different column names in 2 or more tables
2 types of Fact Expressions
View Filters
Shortcut Bar
Heterogeneous Fact
14. 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
2 types of Facts
3 Methods of MSTR Desktop navigation
Project-level options/settings
15. Prompts to select a single value on which to qualify a date - number or text string.
2 types of Fact Expressions
Value Prompts
Page-by
Report Filter
16. The Attribute Form maps to different column names in multiple tables
Schema Object Editor
Reference Report Objects
Table Keys
Heterogeneous Attribute
17. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
3 components of a Report
Cannot create project objects
4 properties you must know in order to create attributes using the Attribute Editor
Highest-level attributes
18. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Tasks when defining a User Hierarchy
Application Objects
3 Sections of the MSTR Desktop interface
3-Tier Architecture
19. Creating multiple attributes quickly. Used during the initial project creation.
Compound Attribute
Attribute Creation Wizard good for
3 project creation interfaces
3 types of Attributes
20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
To save a Report Format
4 properties you must know in order to create attributes using the Attribute Editor
Level Prompts
21. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Desktop Administrative Functions
Report Template
Search-based prompts
22. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Report Filter
5 Report display views
Types of drilling
Derived Metrics
23. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Project
Fact Tables
Data warehouse characteristics
Minimal or none
24. 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
2 types of Attribute Expression
By default
Outline Mode
4 types of Report Filters
25. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
2 types of Fact Expressions
Derived Attribute Expression
Sorting
Search Object
26. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Attribute Forms
Architect Graphical Interface
Thresholding
27. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Lookup Table structure of a completely normalized schema
View Filter
Physical Schema
Metrics
28. Level of OLAP integration
Attribute or its relationship(s)
Report Filter
4 types of Report Filters
Very high; part of ETL process
29. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
Attribute Forms
Short-term (2 - 6 months)
Hierarchies
3 functions of Attribute Forms
30. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Attribute Elements
Lookup Tables
Project Creation Wizard
Facts
31. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Architect Graphical Interface
3-Tier Architecture
Report Filter operators
OLAP
32. The logical associations between attributes that exist based on a business rule
User Hierarchies
Attribute Relationships
Report Prompts
Data warehouse characteristics
33. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Characteristics of Nested Metrics
Project
Report Editor
ID form
34. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Attribute Creation Wizard good for
4 basic Schema objects
4 types of Report Filters
3 project creation interfaces
35. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Schema
Desktop Designer
ETL process
Thresholding
36. A feature that enables users to delivers reports to the history list - cache or mobile
Column Aliases
Sorting
Report Subscription
MSTR OLAP Services
37. Template - Filter - View of a Report
The 3 MSTR Tools
3 components of a Report
4 basic Schema objects
The System
38. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
3 project creation interfaces
Level Prompts
Lookup Table structure of a completely normalized schema
Attribute Elements
39. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Desktop Architec
The System
To edit the appearance of a Graph in a report
Report Filter operators
40. What tool do you use to create the Metadata DSN connection?
Factors to consider when designing a logical data model
OLTP
MSTR Connectivity Wizard
Stored
41. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
To "drill down" on a report
Relationship Tables
Lookup Tables
Report Editor
42. Schema Objects - Application Objects - Configuration Objects
Search-based prompts
Shortcut in MSTR Desktop
2 types of Attribute Expression
3 Types of Objects in MSTR Desktop
43. Extraction - transformation - loading
Shortcut in MSTR Desktop
Architect Graphical Interface
ETL
Search-based prompts
44. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Shortcut in MSTR Desktop
Project Source
Warehouse Catalog
2-Tier Architecture
45. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Application Objects
Facts
Components of a Derived Metric
46. Grid View - Graph View - Grid/Graph View - SQL View
2 types of Attribute Expression
Minimal or none
View Filter
Display views you can Print by
47. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Characteristics of Nested Metrics
Minimal or none
Configuration Wizard
48. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
To qualify a Metric in a Set Qualification
2 types of Table Keys
Using a Search Object
Attribute Creation Wizard good for
49. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Search-based prompts
To qualify a Metric in a Set Qualification
Project-level options/settings
Components of Compound Metrics
50. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Table Keys
MSTR OLAP Services
Components of a MSTR architecture