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. 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
Project-level options/settings
Report Template
Characteristics of Nested Metrics
Hierarchies
2. Simple - Derived
3 project creation interfaces
Aggregate a Metric
Search-based prompts
2 types of Attribute Expression
3. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Attributes
3 project creation interfaces
Report Objects
Metrics
4. 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
Factors to consider when designing a logical data model
Report Editor
Simple Metrics
Report Formatting
5. Descriptive data that provides context for Facts.
Lookup Table structure of a completely denormalized schema
Very high; part of ETL process
Architect Graphical Interface
Attribute Forms
6. Enables you to rearrange the columns and rows in a report.
Lookup Table structure of a completely normalized schema
Column Aliases
Data Pivoting
Components of a MSTR architecture
7. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
8. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Unlimited
Source system characteristics
Desktop Analyst
Report Formatting
9. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Reference Report Objects
Limitations of the Attribute Creation Wizard
Shortcut Bar
Attribute Creation Wizard good for
10. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
2 components of a Physical Schema
Thresholding
Report Filter
Metrics
11. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Shortcut Bar
By default
ETL process
3 column types of a Physical Schema
12. You must select "Other directions" when drilling attributes while viewing a report
Sorting
Desktop Analyst
Relationship Tables
To drill through User Hierarchies
13. Groupings of directly related attributes. Also commonly known as "dimensions".
4 types of Report Filters
Level Prompts
Hierarchies
Shortcut in MSTR Desktop
14. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Simple Attribute Expression
Characteristics of a Simple Table Key
Hierarchies
2 types of Fact Expressions
15. Used to modify a Report
The System
ETL process
Warehouse Catalog
Report Editor
16. A feature that enables users to delivers reports to the history list - cache or mobile
Architect Graphical Interface
2 types of Table Keys
Report Subscription
Fact Expression
17. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Components of a MSTR architecture
Table Keys
Fact Tables
18. Extraction - transformation - loading
Very high; part of ETL process
3 column types of a Physical Schema
3 components of a Report
ETL
19. You can _____________ in the Architect Graphical Interface.
The 3 MSTR Tools
Rollback your changes
Banding
Reports
20. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
2 components of a Physical Schema
OLTP
Rollback your changes
4 properties you must know in order to create attributes using the Attribute Editor
21. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
Minimal or none
To save a Report Format
3 Sections of the MSTR Desktop interface
22. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
3-Tier Architecture
Tasks when defining a User Hierarchy
2 components of a Physical Schema
23. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Logical Data Model
Report Filter operators
MSTR OLAP Services
Lookup Tables
24. 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
Object Prompts
Reports
Types of drilling
ETL process
25. View Filters are saved with the _____________.
Hierarchies
Physical Schema
Architect Graphical Interface
Report Definitions
26. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Project Creation Wizard
Required on the report for Outline Model to work
Cannot create project objects
To drill through User Hierarchies
27. Enables you to lock column headers so that they always appear when scrolling
Attributes
Locking and Resizing
Very high; part of ETL process
Fact Tables
28. Used to limit a possibly overwhelming set of potential prompt answers
Desktop Architec
Search-based prompts
3 Schema types
Report Formatting
29. Simple - Compound - Nested - Derived
Rollback your changes
Search Object
Different methods for creating Page-by fields
4 types of Metrics
30. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Page-by
Process for creating the Project Metadata
4 parts of the Project Design Process
3 Methods of MSTR Desktop navigation
31. Direct: 2-tier - Server: 3-tier
Column Aliases
Long-term (2 - 5 years)
Using a Search Object
2 ways you can configure the Project Source to connect to the Metadata database
32. One that uses 2 or more columns as its ID
Compound Attribute
To edit the appearance of a Graph in a report
ID form
Homogeneous Attribute
33. The logical associations between attributes that exist based on a business rule
Compound Attribute
4 types of Report Filters
Attribute Relationships
Reports
34. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Attribute Forms
The 3 MSTR Tools
Architect Graphical Interface
Application Objects
35. OLAP data storage measure
Terabytes (TB)
4 parts of the Project Design Process
Unlimited
3 types of Attributes
36. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
File > Email Reports As
Subtotals
Page-by
37. Prompts to select a single value on which to qualify a date - number or text string.
Fact Expression
Fact Tables
Value Prompts
Attribute Creation Wizard good for
38. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Schema Objects
2 types of Fact Expressions
Display views you can Print by
39. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
2 ways you can configure the Project Source to connect to the Metadata database
Banding
3 types of Attributes
40. OLAP Services does not add any ______ to the report query.
Factors to consider when designing a logical data model
Report Filter
New SQL
Very high; part of ETL process
41. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Shortcut Bar
Characteristics of Nested Metrics
Metrics
42. An environment in which the MSTR Desktop connects directly to the Metadata database.
Compound Attribute
3 Types of Objects in MSTR Desktop
2-Tier Architecture
New SQL
43. It contains the ID column of all higher-level attributes
Tasks when defining a User Hierarchy
File types are allowed for exporting a Report
2 ways you can configure the Project Source to connect to the Metadata database
Lookup Table structure of a moderately denormalized schema
44. Used to "fine-tune" your Project
Architect Graphical Interface
5 steps to creating a logical data model
Components of a Metric
Heterogeneous Fact
45. To see data at completely different levels - other than that of the original Grid or Graph
Notes
Drilling
Report Prompts
Compound Attribute
46. 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
Stored
Attribute Relationships
Reports
Tasks when defining a User Hierarchy
47. Create the Project Source - Create the Database Instance
To create the Project connectivity
5 steps to creating a logical data model
Short-term (2 - 6 months)
Components of a Derived Metric
48. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Lookup Table structure of a moderately denormalized schema
Data Pivoting
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
Desktop Architec
New SQL
Sample Metrics commonly performed on Facts
50. What tool do you use to create the Metadata DSN connection?
Report Subscription
4 factors to consider when designing a data-warehouse schema
MSTR Connectivity Wizard
Limitations of the Attribute Creation Wizard