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. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Report Prompts
Table Keys
Desktop Architec
2. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Reports
Desktop Designer
MSTR applications
Schema Objects
3. More storage - Complex SQL - Simple ETL
To save a Report Format
Limitations of the Attribute Creation Wizard
Short-term (2 - 6 months)
Characteristics of a Compound Table Key
4. To see data at completely different levels - other than that of the original Grid or Graph
To drill through User Hierarchies
Short-term (2 - 6 months)
Source system characteristics
Drilling
5. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLAP
Lookup Tables
Report Filter operators
2 types of Attribute Expression
6. Facts associated to different column names in 2 or more tables
4 properties you must know in order to create attributes using the Attribute Editor
Heterogeneous Fact
User Hierarchies
Characteristics of Nested Metrics
7. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Schema Objects
Desktop Administrative Functions
3 types of Attributes
8. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
To edit the appearance of a Graph in a report
Components of a Metric
Reports
Source system characteristics
9. 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
Column Aliases
3 components of a Report
Default Project folder structure
Tasks when defining a User Hierarchy
10. A condition data must meet in order to be included in a report. Does affect the SQL.
3 types of Attributes
Report Filter
3 Schema types
4 types of Prompts
11. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Default Project folder structure
Reference Report Objects
3 Schema types
12. 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
Components of a Derived Metric
Schema
3 Methods of MSTR Desktop navigation
13. Primary keys
Process for creating the Project Metadata
Table Keys
Object Prompts
Metrics
14. OLTP data storage measure
To save a Report Format
Gigabytes (GB)
Object Prompts
Methods are there to creating Attributes
15. You can _____________ in the Architect Graphical Interface.
Highest-level attributes
Rollback your changes
4 properties you must know in order to create attributes using the Attribute Editor
4 factors to consider when designing a data-warehouse schema
16. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Fact Tables
2 components of a Physical Schema
Desktop Administrative Functions
Required on the report for Outline Model to work
17. The default entry-points.
Highest-level attributes
Metrics
OLAP
Types of drilling
18. 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
Facts
4 types of Report Filters
To save a Report Format
Thresholding
19. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Report Definitions
Simple Attribute Expression
Components of a MSTR architecture
20. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Methods are there to creating Attributes
Column Aliases
Aggregate a Metric
21. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Tasks when defining a User Hierarchy
Architect Graphical Interface
OLTP
22. 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
Drilling
Highest-level attributes
Desktop Analyst
23. View Filters are saved with the _____________.
Nested Metrics
Report Definitions
Report Filter
Project Source
24. AND - OR - OR NOT - AND NOT
To "drill down" on a report
Minimal or none
Report Filter operators
Report Template
25. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Limitations of the Attribute Creation Wizard
Attributes
Project Source
Components of a Derived Metric
26. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Components of the Logical Data Model
Schema Object Editor
Default Project folder structure
Characteristics of a Simple Table Key
27. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Reports
4 tasks of the Attribute Creation Wizard
Architect Graphical Interface
28. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Heterogeneous Fact
Gigabytes (GB)
Report Prompts
ETL process
29. A shortcut to an existing Object in a Project
To drill through User Hierarchies
View Filters
Shortcut in MSTR Desktop
Tasks when defining a User Hierarchy
30. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Attribute Relationships
Thresholding
Fact Tables
Architect Graphical Interface
31. Enables you to select which tables from the data-warehouse to store in the Metadata database
Configuration Wizard
Highest-level attributes
Warehouse Catalog
Report Filter
32. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
ID form
Using a Search Object
2-Tier Architecture
33. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
3 Methods of MSTR Desktop navigation
5 steps to creating a logical data model
2 types of Table Keys
34. 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
Reports
3 functions of Attribute Forms
Aggregate a Metric
4 parts of the Project Design Process
35. The Attribute Form Expression that maps to a single column - no matter the number of tables
Terabytes (TB)
Using a Search Object
Report Filter operators
Simple Attribute Expression
36. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
5 steps to creating a logical data model
Reports
2-Tier Architecture
Metrics
37. Enables you to lock column headers so that they always appear when scrolling
Lookup Table structure of a moderately denormalized schema
Locking and Resizing
3 functions of Attribute Forms
Physical Schema
38. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Facts
The 3 MSTR Tools
Project Source
39. ID columns - Description columns - Fact columns
Cannot create project objects
Required on the report for Outline Model to work
3 column types of a Physical Schema
Default Project folder structure
40. Facts - Attributes - Hierarchies
To edit the appearance of a Graph in a report
3 column types of a Physical Schema
Lookup Table structure of a completely denormalized schema
Components of the Logical Data Model
41. The logical associations between attributes that exist based on a business rule
Nested Metrics
Attribute Relationships
Attribute Elements
2 types of Fact Expressions
42. Specifies what info to retrieve from a data-warehouse - and how to display it
Configuration Wizard
Report Template
2 types of Fact Expressions
To save a Report Format
43. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Methods are there to creating Attributes
Level Prompts
Different methods for creating Page-by fields
Desktop Architec
44. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Cannot create project objects
3 Methods of MSTR Desktop navigation
Default Project folder structure
Application Objects
45. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
2 types of Table Keys
Lookup Table structure of a completely denormalized schema
Schema Objects
Desktop Designer
46. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
OLAP
Fact Expression
2 types of Attribute Relationships
Sorting
47. Extraction - transformation - loading
ETL
To save a Report Format
Types of analysis you can perform with OLAP Services
Filter Definition Prompts
48. Filter definition prompts - Object prompts - Value prompts - Level prompts
3 types of Attributes
4 types of Prompts
3 project creation interfaces
User Hierarchies
49. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
Attribute or its relationship(s)
4 factors to consider when designing a data-warehouse schema
Attribute Forms
50. A new tool for project design tasks - used for fine-tuning a project after initial creation
Logical Data Model
Factors to consider when designing a logical data model
MSTR applications
Architect Graphical Interface