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. View Filters can only ___________.
Limitations of the Attribute Creation Wizard
Filter Definition Prompts
Objects you are allowed to Page-by
Reference Report Objects
2. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
To create the Project connectivity
User Hierarchies
File types are allowed for exporting a Report
Configuration Wizard
3. It contains links to specific folders in the Folder List
To create the Project connectivity
Warehouse Catalog
File types are allowed for exporting a Report
Shortcut Bar
4. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Rollback your changes
Configuration Wizard
4 basic Schema objects
5. Metrics aggregate on the lowest-level attribute __________.
Report Objects
'View of a Report'
By default
Desktop Architec
6. 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
Project-level options/settings
Logical Data Model
Configuration Wizard
3-Tier Architecture
7. OLTP retains data ________
Short-term (2 - 6 months)
File > Email Reports As
By default
Derived Metrics
8. Groupings of directly related attributes. Also commonly known as "dimensions".
Components of a Derived Metric
3 project creation interfaces
Derived Attribute Expression
Hierarchies
9. 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
3 components of a Report
3 types of Attributes
Outline Mode
3 functions of Attribute Forms
10. Must have a one-to-one relationship with all other forms.
Project
By default
Tasks when defining a User Hierarchy
Attribute Forms
11. It contains the ID and DESC columns of all higher-level attributes
Heterogeneous Attribute
Lookup Table structure of a completely denormalized schema
Lookup Table structure of a completely normalized schema
Relationship Tables
12. Facts associated to different column names in 2 or more tables
Facts
Rollback your changes
Desktop Administrative Functions
Heterogeneous Fact
13. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Types of analysis you can perform with OLAP Services
2 options for Sorting
Report Editor
Project
14. Used to modify a Report
Schema
MSTR applications
Report Editor
3 functions of Attribute Forms
15. 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
Using a Search Object
Attribute or its relationship(s)
Stored
4 types of Report Filters
16. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Value Prompts
Facts
Fact Tables
Limitations of the Attribute Creation Wizard
17. All Attributes must have an _______.
Architect Graphical Interface
3 functions of Attribute Forms
To edit the appearance of a Graph in a report
ID form
18. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
To edit the appearance of a Graph in a report
2 types of Fact Expressions
Derived Attribute Expression
Sorting
19. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Table Keys
Advantage of a completely denormalized schema
3 functions of Attribute Forms
2 types of Table Keys
20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
File types are allowed for exporting a Report
Components of a MSTR architecture
Aggregate a Metric
User Hierarchies
21. A user interface for creating and maintaining a BI environment
MSTR Desktop
To save a Report Format
Drilling
2 types of Attribute Relationships
22. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
To qualify a Metric in a Set Qualification
Desktop Architec
Tasks when defining a User Hierarchy
Search Object
23. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
3 Methods of MSTR Desktop navigation
3 types of Attributes
Physical Schema
Attributes
24. 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
25. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Report Definitions
Unlimited
Components of Compound Metrics
26. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Attribute Elements
User Hierarchies
Process for creating the Project Metadata
Desktop Analyst
27. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Project-level options/settings
Attribute or its relationship(s)
OLTP
4 factors to consider when designing a data-warehouse schema
28. A new tool for project design tasks - used for fine-tuning a project after initial creation
5 Report display views
Report Formatting
Architect Graphical Interface
Derived Metrics
29. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
To create a Report Prompt
Report Editor
2 types of Table Keys
30. The Attribute Form maps to different column names in multiple tables
Reference Report Objects
Heterogeneous Attribute
Components of Compound Metrics
Display views you can Print by
31. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
The System
Source system characteristics
2 types of Facts
32. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Components of Compound Metrics
Attribute or its relationship(s)
To save a Report Format
Simple Metrics
33. Columns - Tables
Minimal or none
2 components of a Physical Schema
2 ways you can configure the Project Source to connect to the Metadata database
Using a Search Object
34. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Gigabytes (GB)
Report Subscription
3 Methods of MSTR Desktop navigation
35. One that uses 2 or more columns as its ID
Compound Attribute
3-Tier Architecture
Warehouse Catalog
Simple Attribute Expression
36. It contains the ID column of all higher-level attributes
Column Aliases
Lookup Table structure of a moderately denormalized schema
Attributes
Notes
37. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
Shortcut Bar
MSTR OLAP Services
MSTR Connectivity Wizard
38. Facts associated to the same column name in 1 or more tables
Limitations of the Attribute Creation Wizard
Attribute Creation Wizard good for
Banding
Homogeneous Fact
39. The Attribute Form Expression that maps to a single column - no matter the number of tables
Report Editor
Attribute Relationships
Desktop Analyst
Simple Attribute Expression
40. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Minimal or none
3 column types of a Physical Schema
Types of analysis you can perform with OLAP Services
Factors to consider when designing a logical data model
41. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Banding
Process for creating the Project Metadata
Shortcut in MSTR Desktop
Project Creation Wizard
42. You must select "Other directions" when drilling attributes while viewing a report
Stored
To drill through User Hierarchies
Simple Metrics
MSTR Desktop Architect
43. The logical associations between attributes that exist based on a business rule
Rollback your changes
Attribute Relationships
Attribute Forms
To qualify a Metric in a Set Qualification
44. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Characteristics of Nested Metrics
Configuration Wizard
Object Prompts
Gigabytes (GB)
45. Simple - Compound - Nested - Derived
Report Filter
4 types of Metrics
Report Objects
4 parts of the Project Design Process
46. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Stored
Different methods for creating Page-by fields
Object Prompts
2 types of Facts
47. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Short-term (2 - 6 months)
Long-term (2 - 5 years)
Reports
Project Creation Wizard
48. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
5 steps to creating a logical data model
Desktop Designer
4 tasks of the Attribute Creation Wizard
Report Filter
49. 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
Report Editor
Factors to consider when designing a logical data model
Characteristics of a Simple Table Key
Simple Metrics
50. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Report Filter operators
ETL process
To create a Report Prompt
To "drill down" on a report