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. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Simple Table Key
4 parts of the Project Design Process
Report Definitions
2. Creating multiple attributes quickly. Used during the initial project creation.
Cannot create project objects
4 parts of the Project Design Process
3 types of Attributes
Attribute Creation Wizard good for
3. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
3 functions of Attribute Forms
2 components of a Physical Schema
Lookup Tables
4. Folder List - Object Viewer - Shortcut Bar
Lookup Table structure of a completely normalized schema
3 Sections of the MSTR Desktop interface
Project
Attributes
5. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Process for creating the Project Metadata
File types are allowed for exporting a Report
Characteristics of a Compound Table Key
3 project creation interfaces
6. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Attribute Forms
Schema Object Editor
2 components of a Physical Schema
7. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
Report Formatting
Warehouse Catalog
Sorting
8. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
2 types of Attribute Expression
Cannot create project objects
3-Tier Architecture
Derived Attribute Expression
9. What tool do you use to create the Metadata DSN connection?
Locking and Resizing
Shortcut Bar
MSTR Connectivity Wizard
5 Report display views
10. All Attributes must have an _______.
ID form
Simple Attribute Expression
Drilling
Factors to consider when designing a logical data model
11. OLAP retains data ________
3 Methods of MSTR Desktop navigation
Long-term (2 - 5 years)
View Filter
ETL
12. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Report Subscription
Simple Metrics
3-Tier Architecture
13. 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
Value Prompts
Types of drilling
Gigabytes (GB)
Schema
14. You can _____________ in the Architect Graphical Interface.
MSTR OLAP Services
2 ways you can configure the Project Source to connect to the Metadata database
Methods are there to creating Attributes
Rollback your changes
15. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Minimal or none
Fact Tables
User Hierarchies
Derived Attribute Expression
16. Metrics that perform multiple aggregations; one calculation inside of another.
Physical Schema
Attribute Relationships
Minimal or none
Nested Metrics
17. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Components of Compound Metrics
Limitations of the Attribute Creation Wizard
Heterogeneous Attribute
18. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Different methods for creating Page-by fields
View Filter
Filter Definition Prompts
Attribute or its relationship(s)
19. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Shortcut in MSTR Desktop
Components of a MSTR architecture
To "drill down" on a report
4 properties you must know in order to create attributes using the Attribute Editor
20. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Report Filter
4 parts of the Project Design Process
Physical Schema
4 basic Schema objects
21. All report-level options overwrite ___________.
Project-level options/settings
Report Filter
Desktop Administrative Functions
Heterogeneous Fact
22. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Attribute Elements
2 types of Attribute Expression
2 types of Table Keys
Components of a Metric
23. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
To edit the appearance of a Graph in a report
Value Prompts
Attribute Forms
Facts
24. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
4 types of Metrics
Minimal or none
Thresholding
25. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
User Hierarchies
Derived Metrics
MSTR OLAP Services
View Filter
26. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Report Subscription
Facts
Methods are there to creating Attributes
Project Source
27. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
New SQL
Report Objects
Desktop Analyst
MSTR Desktop
28. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
4 factors to consider when designing a data-warehouse schema
3 column types of a Physical Schema
Homogeneous Fact
Limitations of the Attribute Creation Wizard
29. Columns - Tables
Sample Metrics commonly performed on Facts
2 components of a Physical Schema
Display views you can Print by
MSTR applications
30. Enables you to select which tables from the data-warehouse to store in the Metadata database
Attribute or its relationship(s)
Components of a MSTR architecture
Warehouse Catalog
Compound Metric
31. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Components of a MSTR architecture
Project Source
2 options for Sorting
32. The Attribute Form Expression that maps to a single column - no matter the number of tables
Lookup Table structure of a completely normalized schema
Homogeneous Attribute
Simple Attribute Expression
3 Sections of the MSTR Desktop interface
33. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Architect Graphical Interface
3 project creation interfaces
3 functions of Attribute Forms
34. The logical associations between attributes that exist based on a business rule
Components of Compound Metrics
Attribute Relationships
To create the Project connectivity
MSTR Desktop
35. The default entry-points.
2 types of Facts
Report Filter
Nested Metrics
Highest-level attributes
36. Filter definition prompts - Object prompts - Value prompts - Level prompts
To qualify a Metric in a Set Qualification
3 components of a Report
4 types of Prompts
Attribute Elements
37. A method of organizing the appearance of report results in a Grid report based on a criteria
Physical Schema
Components of the Logical Data Model
The System
Banding
38. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Report Filter
Heterogeneous Fact
Aggregate a Metric
39. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Project-level options/settings
Stored
2 components of a Physical Schema
40. Specifies what info to retrieve from a data-warehouse - and how to display it
3 Methods of MSTR Desktop navigation
Stored
Reference Report Objects
Report Template
41. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
MSTR Connectivity Wizard
Hierarchies
Report Filter
Schema
42. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Heterogeneous Fact
Tasks when defining a User Hierarchy
MSTR applications
Desktop Designer
43. Tables - Facts - Attributes - Hierarchies
Attribute Elements
Schema Object Editor
Project Source
4 basic Schema objects
44. View Filters can only ___________.
To create the Project connectivity
Attribute Elements
Reference Report Objects
Subtotals
45. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
4 types of Report Filters
Using a Search Object
2 types of Attribute Relationships
3 types of Attributes
46. 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
4 types of Report Filters
Types of drilling
Characteristics of Nested Metrics
By default
47. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Report Filter
2 ways you can configure the Project Source to connect to the Metadata database
Search Object
Heterogeneous Fact
48. Grid View - Graph View - Grid/Graph View - SQL View
Attribute Creation Wizard good for
Compound Attribute
Filter Definition Prompts
Display views you can Print by
49. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Report Editor
2 types of Fact Expressions
Characteristics of a Compound Table Key
Desktop Administrative Functions
50. Must have a one-to-one relationship with all other forms.
Object Prompts
Schema Objects
3 types of Attributes
Attribute Forms