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. Primary keys
2-Tier Architecture
Object Prompts
Table Keys
4 basic Schema objects
2. Simple - Derived
Value Prompts
2 types of Attribute Expression
4 basic Schema objects
2 components of a Physical Schema
3. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Relationship Tables
3 Sections of the MSTR Desktop interface
Application Objects
ETL
4. Homogeneous - Heterogeneous
4 types of Prompts
View Filters
MSTR Desktop
2 types of Facts
5. Extraction - transformation - loading
Project
Report Formatting
ETL
Limitations of the Attribute Creation Wizard
6. 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.
3 types of Attributes
Derived Attribute Expression
User Hierarchies
View Filters
7. Less storage - Simple SQL - Complex ETL
Relationship Tables
Lookup Table structure of a moderately denormalized schema
Characteristics of a Simple Table Key
Banding
8. Compound - Homogeneous - Heterogeneous
The System
3 types of Attributes
Architect Graphical Interface
Different methods for creating Page-by fields
9. Metrics that perform multiple aggregations; one calculation inside of another.
4 types of Report Filters
Architect Graphical Interface
4 types of Prompts
Nested Metrics
10. OLAP retains data ________
Characteristics of Nested Metrics
OLTP
Long-term (2 - 5 years)
To create the Project connectivity
11. The Attribute Form maps to different column names in multiple tables
The 3 MSTR Tools
Heterogeneous Attribute
Factors to consider when designing a logical data model
Page-by
12. Folder List - Object Viewer - Shortcut Bar
Unlimited
3 Sections of the MSTR Desktop interface
Characteristics of Nested Metrics
Components of a Metric
13. Template - Filter - View of a Report
Lookup Table structure of a moderately denormalized schema
Components of a Metric
3 components of a Report
Short-term (2 - 6 months)
14. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Rollback your changes
Long-term (2 - 5 years)
Characteristics of a Simple Table Key
Level Prompts
15. A shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
3-Tier Architecture
Tasks when defining a User Hierarchy
Default Project folder structure
16. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
To drill through User Hierarchies
Factors to consider when designing a logical data model
Sample Metrics commonly performed on Facts
Rollback your changes
17. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Different methods for creating Page-by fields
2 methods to creating Facts
Configuration Wizard
Attribute or its relationship(s)
18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
File types are allowed for exporting a Report
Highest-level attributes
By default
19. Metrics you create within a report using only those objects in the report.
The 3 MSTR Tools
Derived Metrics
Drilling
Short-term (2 - 6 months)
20. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Value Prompts
Stored
To qualify a Metric in a Set Qualification
Lookup Tables
21. How users can share comments for reports to other users
Heterogeneous Fact
Page-by
Report Filter
Notes
22. ID columns - Description columns - Fact columns
Simple Attribute Expression
Data Pivoting
3 column types of a Physical Schema
Outline Mode
23. Create the Project Source - Create the Database Instance
4 factors to consider when designing a data-warehouse schema
To create the Project connectivity
Using a Search Object
5 Report display views
24. View Filters are saved with the _____________.
Homogeneous Attribute
Characteristics of a Simple Table Key
Report Objects
Report Definitions
25. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Page-by
ETL process
Desktop Designer
Desktop Administrative Functions
26. A development environment to create BI applications - allowing users to edit the Metadata database
Components of a MSTR architecture
Data Pivoting
OLTP
Desktop Architec
27. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Short-term (2 - 6 months)
2 types of Table Keys
Data warehouse characteristics
4 factors to consider when designing a data-warehouse schema
28. Simple - Compound - Nested - Derived
To create a Report Prompt
4 types of Metrics
2 components of a Physical Schema
Highest-level attributes
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
Characteristics of Nested Metrics
To create the Project connectivity
Thresholding
Simple Attribute Expression
30. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Simple Metrics
Compound Attribute
Components of a Derived Metric
Report Filter operators
31. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
4 types of Metrics
3-Tier Architecture
Desktop Designer
32. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
View Filters
Attribute Elements
Types of analysis you can perform with OLAP Services
33. View Filters can only ___________.
Application Objects
Reference Report Objects
Level Prompts
To create a Report Prompt
34. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Object Prompts
Attribute Forms
Project
35. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Lookup Table structure of a completely normalized schema
MSTR applications
Aggregate a Metric
Metrics
36. 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
Schema Objects
Architect Graphical Interface
Types of drilling
Factors to consider when designing a logical data model
37. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Drilling
Homogeneous Attribute
Required on the report for Outline Model to work
Facts
38. Used to limit a possibly overwhelming set of potential prompt answers
Desktop Architec
Attribute Creation Wizard good for
Search-based prompts
3 project creation interfaces
39. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
4 parts of the Project Design Process
To "drill down" on a report
2 types of Attribute Relationships
Metrics
40. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Filter Definition Prompts
Objects you are allowed to Page-by
Report Editor
2 ways you can configure the Project Source to connect to the Metadata database
41. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Types of analysis you can perform with OLAP Services
Different methods for creating Page-by fields
'View of a Report'
Aggregate a Metric
42. OLAP Services does not add any ______ to the report query.
Report Definitions
Data Pivoting
Search-based prompts
New SQL
43. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
3 functions of Attribute Forms
Desktop Administrative Functions
Notes
Components of a Derived Metric
44. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Search Object
3 Schema types
To create a Report Prompt
45. The logical associations between attributes that exist based on a business rule
Unlimited
Heterogeneous Fact
Attributes
Attribute Relationships
46. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Attributes
Factors to consider when designing a logical data model
Filter Definition Prompts
47. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
4 parts of the Project Design Process
Aggregate a Metric
Gigabytes (GB)
48. It contains links to specific folders in the Folder List
Shortcut Bar
Cannot create project objects
Unlimited
Notes
49. A feature that enables users to delivers reports to the history list - cache or mobile
MSTR Desktop
Types of drilling
To edit the appearance of a Graph in a report
Report Subscription
50. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
To "drill down" on a report
Characteristics of a Compound Table Key
3-Tier Architecture
Aggregate a Metric