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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Minimal or none
To create a Report Prompt
ETL
2. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
2-Tier Architecture
File types are allowed for exporting a Report
Source system characteristics
Outline Mode
3. You can _____________ in the Architect Graphical Interface.
Banding
Report Template
4 parts of the Project Design Process
Rollback your changes
4. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
The 3 MSTR Tools
Compound Metric
Types of drilling
2 methods to creating Facts
5. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Heterogeneous Attribute
Search-based prompts
Long-term (2 - 5 years)
6. Descriptive data that provides context for Facts.
Metrics
Attribute Forms
To edit the appearance of a Graph in a report
Long-term (2 - 5 years)
7. Enables you to rearrange the columns and rows in a report.
View Filters
3 functions of Attribute Forms
Nested Metrics
Data Pivoting
8. The default entry-points.
Terabytes (TB)
3 Methods of MSTR Desktop navigation
Highest-level attributes
Source system characteristics
9. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Different methods for creating Page-by fields
Report Filter
Heterogeneous Fact
Physical Schema
10. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Aggregate a Metric
Unlimited
Limitations of the Attribute Creation Wizard
Components of a MSTR architecture
11. Facts associated to different column names in 2 or more tables
Required on the report for Outline Model to work
Heterogeneous Fact
Attribute Elements
Default Project folder structure
12. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Lookup Table structure of a moderately denormalized schema
2 types of Attribute Expression
Reference Report Objects
Desktop Analyst
13. More storage - Complex SQL - Simple ETL
Long-term (2 - 5 years)
MSTR OLAP Services
2-Tier Architecture
Characteristics of a Compound Table Key
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
Objects you are allowed to Page-by
3 project creation interfaces
3 Schema types
Homogeneous Fact
15. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Lookup Table structure of a completely normalized schema
ETL
Banding
OLAP
16. To define the level of aggregation for a specific metric - Used for qualifications
2 components of a Physical Schema
Components of a Derived Metric
Attributes
3 functions of Attribute Forms
17. All Attributes must have an _______.
Required on the report for Outline Model to work
ID form
Shortcut Bar
Derived Metrics
18. Level of OLTP integration
Minimal or none
Terabytes (TB)
Attribute Forms
ETL process
19. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
User Hierarchies
MSTR OLAP Services
OLAP
20. The Attribute Form Expression that maps to a single column - no matter the number of tables
Report Template
Simple Attribute Expression
Object Prompts
4 types of Prompts
21. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Fact Expression
Homogeneous Attribute
Nested Metrics
22. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Sorting
Desktop Administrative Functions
Relationship Tables
Architect Graphical Interface
23. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
To save a Report Format
Project Creation Wizard
Schema Object Editor
24. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Compound Attribute
Attribute or its relationship(s)
5 Report display views
Minimal or none
25. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Data warehouse characteristics
Components of Compound Metrics
Desktop Designer
Filter Definition Prompts
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
Configuration Wizard
Reference Report Objects
Report Subscription
Tasks when defining a User Hierarchy
27. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Components of Compound Metrics
The System
3 Sections of the MSTR Desktop interface
Derived Metrics
28. Must have a one-to-one relationship with all other forms.
Attribute Forms
Report Objects
Reports
3 functions of Attribute Forms
29. Compound - Homogeneous - Heterogeneous
To save a Report Format
Compound Attribute
To drill through User Hierarchies
3 types of Attributes
30. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Unlimited
5 steps to creating a logical data model
Lookup Table structure of a completely normalized schema
Schema Objects
31. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
By default
4 types of Metrics
Objects you are allowed to Page-by
ETL
32. You can e-mail reports by going to _____
Attribute or its relationship(s)
Report Subscription
Fact Tables
File > Email Reports As
33. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Display views you can Print by
Fact Expression
Facts
OLAP
34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Outline Mode
3 Sections of the MSTR Desktop interface
Sorting
Attribute Relationships
35. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
To create a Report Prompt
Warehouse Catalog
Derived Attribute Expression
36. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
View Filters
Configuration Wizard
To create a Report Prompt
Simple Metrics
37. The logical associations between attributes that exist based on a business rule
2 types of Table Keys
Attribute Relationships
Using a Search Object
MSTR Desktop Architect
38. It contains the ID column of all higher-level attributes
'View of a Report'
Lookup Table structure of a moderately denormalized schema
Components of a MSTR architecture
Reports
39. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Attribute Relationships
Cannot create project objects
Report Filter
Derived Attribute Expression
40. Create the Project Source - Create the Database Instance
Value Prompts
To create the Project connectivity
Report Editor
2 components of a Physical Schema
41. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
3 Methods of MSTR Desktop navigation
To save a Report Format
Reports
Subtotals
42. Metrics aggregate on the lowest-level attribute __________.
By default
Objects you are allowed to Page-by
Desktop Analyst
Derived Metrics
43. Used to modify a Report
Types of analysis you can perform with OLAP Services
2 types of Facts
Report Editor
Facts
44. ID columns - Description columns - Fact columns
MSTR Desktop
MSTR applications
3 column types of a Physical Schema
Report Filter
45. Homogeneous - Heterogeneous
OLTP
2 types of Facts
Lookup Table structure of a completely normalized schema
File > Email Reports As
46. Schema Objects - Application Objects - Configuration Objects
3 column types of a Physical Schema
Shortcut in MSTR Desktop
Logical Data Model
3 Types of Objects in MSTR Desktop
47. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Attributes
Desktop Analyst
Gigabytes (GB)
48. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
2 components of a Physical Schema
Report Prompts
'View of a Report'
49. Extraction - transformation - loading
Facts
Level Prompts
2 types of Fact Expressions
ETL
50. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
2 types of Facts
Attribute or its relationship(s)
2 types of Fact Expressions
Types of drilling