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. You can e-mail reports by going to _____
File > Email Reports As
Desktop Architec
To create a Report Prompt
Reference Report Objects
2. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Page-by
3 column types of a Physical Schema
Notes
3. What tool do you use to create the Metadata shell?
Simple Attribute Expression
Configuration Wizard
Hierarchies
Highest-level attributes
4. Metrics that perform multiple aggregations; one calculation inside of another.
4 properties you must know in order to create attributes using the Attribute Editor
Nested Metrics
Report Filter
MSTR Desktop
5. Metrics you create within a report using only those objects in the report.
To "drill down" on a report
Desktop Administrative Functions
'View of a Report'
Derived Metrics
6. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Outline Mode
Warehouse Catalog
Components of a Derived Metric
To create the Project connectivity
7. OLTP retains data ________
Different methods for creating Page-by fields
Short-term (2 - 6 months)
Lookup Table structure of a completely normalized schema
2 types of Attribute Expression
8. Template - Filter - View of a Report
Reports
4 parts of the Project Design Process
Schema
3 components of a Report
9. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Locking and Resizing
Schema
MSTR Connectivity Wizard
10. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Attribute Forms
Terabytes (TB)
Schema
Unlimited
11. Reduced number of JOINS in the generated SQL
Relationship Tables
Advantage of a completely denormalized schema
Components of a Metric
4 factors to consider when designing a data-warehouse schema
12. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Report Formatting
Unlimited
ETL
Types of analysis you can perform with OLAP Services
13. You must select "Other directions" when drilling attributes while viewing a report
Tasks when defining a User Hierarchy
To drill through User Hierarchies
Limitations of the Attribute Creation Wizard
Relationship Tables
14. 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
ETL
Default Project folder structure
Report Formatting
Project Source
15. 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
2 types of Attribute Relationships
Long-term (2 - 5 years)
User Hierarchies
16. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
MSTR OLAP Services
Desktop Architec
Outline Mode
2 types of Fact Expressions
17. Allow you to interact with the BI system - logically organize data to analyze complex relationships
2 types of Fact Expressions
Report Filter
MSTR applications
Attribute Elements
18. How users can share comments for reports to other users
Desktop Architec
Notes
Derived Attribute Expression
Short-term (2 - 6 months)
19. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
3 Schema types
Report Filter operators
To edit the appearance of a Graph in a report
20. 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 Fact Expressions
4 types of Report Filters
Rollback your changes
Stored
21. A user interface for creating and maintaining a BI environment
Cannot create project objects
MSTR Desktop
3 components of a Report
Attribute Forms
22. A method of organizing the appearance of report results in a Grid report based on a criteria
Attribute or its relationship(s)
The 3 MSTR Tools
Banding
2 components of a Physical Schema
23. The Attribute Form Expression that maps to a single column - no matter the number of tables
Attribute Creation Wizard good for
Report Filter operators
3 project creation interfaces
Simple Attribute Expression
24. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
3-Tier Architecture
2 types of Facts
Project
25. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Sample Metrics commonly performed on Facts
2 components of a Physical Schema
Report Template
26. Folder List - Object Viewer - Shortcut Bar
Report Filter operators
ETL process
3 functions of Attribute Forms
3 Sections of the MSTR Desktop interface
27. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Report Template
Using a Search Object
Data Pivoting
28. Create the Project Source - Create the Database Instance
2 types of Attribute Expression
To create the Project connectivity
4 properties you must know in order to create attributes using the Attribute Editor
Types of drilling
29. A condition data must meet in order to be included in a report. Does affect the SQL.
Sorting
Report Filter
3 Types of Objects in MSTR Desktop
The System
30. OLAP data storage measure
Terabytes (TB)
5 steps to creating a logical data model
Search-based prompts
The System
31. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of a Simple Table Key
3 functions of Attribute Forms
Desktop Designer
Report Filter
32. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Attribute Forms
Architect Graphical Interface
5 steps to creating a logical data model
Report Objects
33. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Facts
Column Aliases
'View of a Report'
34. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Compound Attribute
2 types of Attribute Relationships
Project Creation Wizard
ETL process
35. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
To create a Report Prompt
Fact Expression
3 project creation interfaces
Data warehouse characteristics
36. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
Data Pivoting
Drilling
Sorting
37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
OLAP
Thresholding
ETL
Limitations of the Attribute Creation Wizard
38. Level of OLAP integration
Very high; part of ETL process
Data warehouse characteristics
ETL process
Characteristics of a Compound Table Key
39. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Using a Search Object
Report Formatting
'View of a Report'
40. Homogeneous - Heterogeneous
2 types of Facts
User Hierarchies
Outline Mode
Project Creation Wizard
41. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Schema
Heterogeneous Fact
2 options for Sorting
Report Formatting
42. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Sample Metrics commonly performed on Facts
Compound Metric
3-Tier Architecture
Components of a Derived Metric
43. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Schema Object Editor
Nested Metrics
Data warehouse characteristics
Sample Metrics commonly performed on Facts
44. Used to "fine-tune" your Project
Architect Graphical Interface
Attribute Elements
Physical Schema
Aggregate a Metric
45. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Cannot create project objects
Required on the report for Outline Model to work
Desktop Administrative Functions
4 factors to consider when designing a data-warehouse schema
46. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
4 types of Metrics
Schema
2 methods to creating Facts
Attribute Forms
47. Enables you to select which tables from the data-warehouse to store in the Metadata database
Types of analysis you can perform with OLAP Services
Sorting
Configuration Wizard
Warehouse Catalog
48. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Facts
MSTR OLAP Services
Attribute Creation Wizard good for
5 steps to creating a logical data model
49. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
MSTR Connectivity Wizard
Tasks when defining a User Hierarchy
5 Report display views
50. A shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
4 types of Report Filters
MSTR Desktop
Data Pivoting