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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
To create a Report Prompt
Compound Metric
Value Prompts
2 options for Sorting
2. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Attribute Creation Wizard good for
Value Prompts
Reports
4 properties you must know in order to create attributes using the Attribute Editor
3. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
2 types of Fact Expressions
Homogeneous Attribute
Short-term (2 - 6 months)
Compound Metric
4. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
User Hierarchies
Facts
3 Sections of the MSTR Desktop interface
5 steps to creating a logical data model
5. Attribute Creation Wizard - Attribute Editor
Characteristics of Nested Metrics
To save a Report Format
Methods are there to creating Attributes
Using a Search Object
6. You must select "Other directions" when drilling attributes while viewing a report
Level Prompts
2 types of Fact Expressions
Methods are there to creating Attributes
To drill through User Hierarchies
7. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Project-level options/settings
OLAP
Tasks when defining a User Hierarchy
Sample Metrics commonly performed on Facts
8. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 basic Schema objects
4 parts of the Project Design Process
Column Aliases
ETL
9. Columns - Tables
2 components of a Physical Schema
Gigabytes (GB)
Attribute Elements
Desktop Administrative Functions
10. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Report Editor
ID form
Highest-level attributes
Process for creating the Project Metadata
11. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
MSTR applications
Components of a MSTR architecture
3 column types of a Physical Schema
Hierarchies
12. It contains the ID column of the parent attribute
Types of drilling
Report Filter operators
Lookup Table structure of a completely normalized schema
Sample Metrics commonly performed on Facts
13. Simple - Compound - Nested - Derived
The System
Source system characteristics
2 ways you can configure the Project Source to connect to the Metadata database
4 types of Metrics
14. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
Highest-level attributes
Banding
Reports
15. OLAP Services does not add any ______ to the report query.
Terabytes (TB)
Page-by
New SQL
Highest-level attributes
16. Template - Filter - View of a Report
Components of a MSTR architecture
3 components of a Report
Report Definitions
Sample Metrics commonly performed on Facts
17. The actual column name for a fact. Every fact must have at least 1 expression.
Characteristics of a Simple Table Key
Fact Expression
Shortcut in MSTR Desktop
Methods are there to creating Attributes
18. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Characteristics of a Simple Table Key
2 types of Table Keys
File types are allowed for exporting a Report
Filter Definition Prompts
19. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
2 types of Facts
Object Prompts
Different methods for creating Page-by fields
20. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Banding
3 Types of Objects in MSTR Desktop
2 methods to creating Facts
Components of a Derived Metric
21. A shortcut to an existing Object in a Project
Derived Attribute Expression
Shortcut in MSTR Desktop
Level Prompts
4 basic Schema objects
22. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
To "drill down" on a report
Characteristics of a Simple Table Key
Project
23. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
OLAP
Attribute Creation Wizard good for
2 types of Facts
Logical Data Model
24. OLTP retains data ________
Short-term (2 - 6 months)
Characteristics of Nested Metrics
Sorting
Locking and Resizing
25. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Level Prompts
View Filter
3 Schema types
26. 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
Architect Graphical Interface
3-Tier Architecture
Search-based prompts
Tasks when defining a User Hierarchy
27. Metrics aggregate on the lowest-level attribute __________.
Unlimited
ID form
Schema
By default
28. 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
To edit the appearance of a Graph in a report
User Hierarchies
OLTP
3 Schema types
29. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Derived Attribute Expression
Highest-level attributes
Components of a Derived Metric
30. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
3 types of Attributes
Compound Metric
To "drill down" on a report
Highest-level attributes
31. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Types of drilling
User Hierarchies
Physical Schema
Report Formatting
32. User reporting requirements - Query performance - Data volume - DB Maintenance
Shortcut in MSTR Desktop
4 factors to consider when designing a data-warehouse schema
5 steps to creating a logical data model
Facts
33. It contains links to specific folders in the Folder List
OLTP
View Filter
Derived Metrics
Shortcut Bar
34. The unique values of an attribute obtained from the data-warehouse
Stored
Attribute Elements
5 Report display views
Gigabytes (GB)
35. Top menu/dropdowns - Toolbar - Right-click popup menus
Components of the Logical Data Model
Architect Graphical Interface
ETL
3 Methods of MSTR Desktop navigation
36. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Nested Metrics
5 Report display views
Project
Report Objects
37. Direct: 2-tier - Server: 3-tier
To "drill down" on a report
Components of a Derived Metric
Report Definitions
2 ways you can configure the Project Source to connect to the Metadata database
38. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Very high; part of ETL process
Fact Tables
Required on the report for Outline Model to work
Value Prompts
39. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Desktop Administrative Functions
Fact Tables
Components of a Metric
Outline Mode
40. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
Value Prompts
MSTR Desktop Architect
3 functions of Attribute Forms
41. Facts associated to the same column name in 1 or more tables
Minimal or none
'View of a Report'
Homogeneous Fact
Lookup Table structure of a completely denormalized schema
42. Enables you to select and display subsets of a report as separate pages.
Page-by
Attribute Forms
Reference Report Objects
Tasks when defining a User Hierarchy
43. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of a Simple Table Key
Desktop Designer
Factors to consider when designing a logical data model
Components of Compound Metrics
44. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Components of the Logical Data Model
4 types of Report Filters
By default
45. OLTP data storage measure
Attribute or its relationship(s)
Gigabytes (GB)
Thresholding
Metrics
46. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Components of the Logical Data Model
Object Prompts
ETL
Report Formatting
47. The Attribute Form maps to the same column name in multiple tables
Attributes
Components of a MSTR architecture
Report Definitions
Homogeneous Attribute
48. User requirements - Existing source data - Technical and performance considerations
3 Types of Objects in MSTR Desktop
Logical Data Model
Attribute Creation Wizard good for
Factors to consider when designing a logical data model
49. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Report Filter
2 types of Fact Expressions
Report Filter
50. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Project-level options/settings
Subtotals
Lookup Table structure of a moderately denormalized schema
To save a Report Format