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. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Desktop Architec
Very high; part of ETL process
Schema Object Editor
Components of Compound Metrics
2. Specifies what info to retrieve from a data-warehouse - and how to display it
Types of drilling
By default
Report Template
Facts
3. Metrics aggregate on the lowest-level attribute __________.
By default
Display views you can Print by
3 Types of Objects in MSTR Desktop
To drill through User Hierarchies
4. Tables - Facts - Attributes - Hierarchies
Rollback your changes
4 basic Schema objects
Relationship Tables
Data warehouse characteristics
5. The logical associations between attributes that exist based on a business rule
View Filters
Attribute Relationships
Lookup Table structure of a completely denormalized schema
Default Project folder structure
6. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Report Template
MSTR OLAP Services
Schema
Compound Metric
7. 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.
Highest-level attributes
3 components of a Report
Terabytes (TB)
View Filters
8. Less storage - Simple SQL - Complex ETL
Advantage of a completely denormalized schema
Characteristics of a Simple Table Key
Report Definitions
Types of drilling
9. A user interface for creating and maintaining a BI environment
MSTR Desktop
4 types of Metrics
By default
4 basic Schema objects
10. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
5 Report display views
Components of the Logical Data Model
4 tasks of the Attribute Creation Wizard
To qualify a Metric in a Set Qualification
11. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
The 3 MSTR Tools
Report Editor
Project Creation Wizard
Types of drilling
12. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Search-based prompts
Derived Attribute Expression
4 properties you must know in order to create attributes using the Attribute Editor
MSTR OLAP Services
13. Facts associated to the same column name in 1 or more tables
Schema
Objects you are allowed to Page-by
Relationship Tables
Homogeneous Fact
14. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Shortcut in MSTR Desktop
2 methods to creating Facts
The 3 MSTR Tools
4 parts of the Project Design Process
15. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Schema
To create a Report Prompt
Different methods for creating Page-by fields
Configuration Wizard
16. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Highest-level attributes
Compound Attribute
Schema
Column Aliases
17. Schema Objects - Application Objects - Configuration Objects
Report Formatting
4 types of Metrics
Configuration Wizard
3 Types of Objects in MSTR Desktop
18. How users can share comments for reports to other users
File > Email Reports As
ID form
4 tasks of the Attribute Creation Wizard
Notes
19. 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
3 types of Attributes
Logical Data Model
Lookup Tables
2 types of Attribute Expression
20. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
View Filters
Attribute Forms
File > Email Reports As
21. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Report Formatting
'View of a Report'
Different methods for creating Page-by fields
22. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Editor
Very high; part of ETL process
Report Objects
Components of a Derived Metric
23. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Banding
5 Report display views
Simple Attribute Expression
Types of analysis you can perform with OLAP Services
24. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Types of analysis you can perform with OLAP Services
Outline Mode
Project-level options/settings
View Filter
25. User reporting requirements - Query performance - Data volume - DB Maintenance
Desktop Analyst
Advantage of a completely denormalized schema
MSTR Desktop Architect
4 factors to consider when designing a data-warehouse schema
26. Used to limit a possibly overwhelming set of potential prompt answers
MSTR OLAP Services
ETL process
3-Tier Architecture
Search-based prompts
27. Used for - Initially populating the Metadata - Creating schema objects
Fact Expression
Process for creating the Project Metadata
MSTR Desktop Architect
Locking and Resizing
28. Must have a one-to-one relationship with all other forms.
Physical Schema
4 factors to consider when designing a data-warehouse schema
Attribute Forms
Filter Definition Prompts
29. 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
3 components of a Report
Homogeneous Attribute
Characteristics of Nested Metrics
Stored
30. A development environment to create BI applications - allowing users to edit the Metadata database
Attribute Relationships
Desktop Architec
Hierarchies
Facts
31. Columns - Tables
2 types of Fact Expressions
To create a Report Prompt
MSTR Connectivity Wizard
2 components of a Physical Schema
32. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Types of analysis you can perform with OLAP Services
Report Filter operators
To qualify a Metric in a Set Qualification
Locking and Resizing
33. Enables you to select and display subsets of a report as separate pages.
Required on the report for Outline Model to work
Page-by
Components of a MSTR architecture
Architect Graphical Interface
34. It contains the ID column of all higher-level attributes
Stored
Compound Attribute
Application Objects
Lookup Table structure of a moderately denormalized schema
35. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Page-by
3 Schema types
Lookup Table structure of a moderately denormalized schema
36. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
OLTP
Outline Mode
Desktop Designer
3-Tier Architecture
37. It contains the ID column of the parent attribute
4 basic Schema objects
Nested Metrics
Lookup Table structure of a completely normalized schema
Architect Graphical Interface
38. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Report Filter operators
Filter Definition Prompts
Advantage of a completely denormalized schema
Column Aliases
39. The Attribute Form Expression that maps to a single column - no matter the number of tables
Thresholding
Simple Attribute Expression
Value Prompts
Warehouse Catalog
40. View Filters can only ___________.
Locking and Resizing
Banding
Reference Report Objects
Limitations of the Attribute Creation Wizard
41. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Homogeneous Fact
Locking and Resizing
Thresholding
Notes
42. You must select "Other directions" when drilling attributes while viewing a report
File types are allowed for exporting a Report
Desktop Designer
To drill through User Hierarchies
Fact Expression
43. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
OLAP
4 parts of the Project Design Process
Filter Definition Prompts
The 3 MSTR Tools
44. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Homogeneous Fact
Architect Graphical Interface
Attribute or its relationship(s)
Shortcut in MSTR Desktop
45. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Components of the Logical Data Model
Source system characteristics
Data warehouse characteristics
4 properties you must know in order to create attributes using the Attribute Editor
46. Reduced number of JOINS in the generated SQL
Table Keys
Advantage of a completely denormalized schema
4 tasks of the Attribute Creation Wizard
Characteristics of a Compound Table Key
47. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Search Object
The System
Methods are there to creating Attributes
Physical Schema
48. View Filters are saved with the _____________.
Report Definitions
Warehouse Catalog
Report Filter operators
3 Methods of MSTR Desktop navigation
49. 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
The 3 MSTR Tools
Simple Attribute Expression
3 Schema types
50. What tool do you use to create the Metadata DSN connection?
2-Tier Architecture
MSTR Connectivity Wizard
Unlimited
Objects you are allowed to Page-by