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. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
To create a Report Prompt
Level Prompts
Locking and Resizing
Architect Graphical Interface
2. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
OLTP
2 options for Sorting
Using a Search Object
3. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Report Editor
Shortcut Bar
2 types of Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
4. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Lookup Table structure of a completely denormalized schema
By default
To save a Report Format
Warehouse Catalog
5. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
To qualify a Metric in a Set Qualification
MSTR applications
Objects you are allowed to Page-by
Aggregate a Metric
6. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
User Hierarchies
Shortcut Bar
Table Keys
7. OLAP data storage measure
Heterogeneous Fact
The 3 MSTR Tools
ETL
Terabytes (TB)
8. OLTP retains data ________
MSTR Desktop
3 Methods of MSTR Desktop navigation
Short-term (2 - 6 months)
3 components of a Report
9. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Aggregate a Metric
Shortcut Bar
The 3 MSTR Tools
3 project creation interfaces
10. One that uses 2 or more columns as its ID
4 types of Metrics
Reference Report Objects
Compound Attribute
File > Email Reports As
11. It contains links to specific folders in the Folder List
Shortcut Bar
2 components of a Physical Schema
3 column types of a Physical Schema
Objects you are allowed to Page-by
12. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
2 types of Facts
Project Creation Wizard
Characteristics of Nested Metrics
13. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Cannot create project objects
2 types of Attribute Expression
4 parts of the Project Design Process
5 steps to creating a logical data model
14. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
New SQL
Table Keys
Filter Definition Prompts
2-Tier Architecture
15. Schema Objects - Application Objects - Configuration Objects
Project Creation Wizard
Notes
Fact Tables
3 Types of Objects in MSTR Desktop
16. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Factors to consider when designing a logical data model
Homogeneous Attribute
3 project creation interfaces
17. Homogeneous - Heterogeneous
2 types of Facts
4 types of Report Filters
3 column types of a Physical Schema
Locking and Resizing
18. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Fact Tables
Types of analysis you can perform with OLAP Services
Lookup Table structure of a completely normalized schema
Desktop Administrative Functions
19. You can _____________ in the Architect Graphical Interface.
Source system characteristics
Short-term (2 - 6 months)
2 types of Fact Expressions
Rollback your changes
20. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Attribute Forms
4 factors to consider when designing a data-warehouse schema
Cannot create project objects
21. 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.
Derived Metrics
Homogeneous Attribute
Rollback your changes
User Hierarchies
22. View Filters can only ___________.
Reference Report Objects
MSTR Desktop Architect
Project Creation Wizard
4 types of Prompts
23. A development environment to create BI applications - allowing users to edit the Metadata database
The 3 MSTR Tools
2 types of Table Keys
Desktop Architec
Report Formatting
24. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Relationship Tables
Report Prompts
ID form
3-Tier Architecture
25. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Objects you are allowed to Page-by
Desktop Architec
Project
26. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Report Filter operators
Schema Object Editor
View Filters
27. User requirements - Existing source data - Technical and performance considerations
Derived Metrics
Very high; part of ETL process
Aggregate a Metric
Factors to consider when designing a logical data model
28. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Fact Tables
The System
2 types of Fact Expressions
Application Objects
29. How users can share comments for reports to other users
3 Sections of the MSTR Desktop interface
Attribute or its relationship(s)
Notes
To edit the appearance of a Graph in a report
30. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Subtotals
User Hierarchies
Level Prompts
31. View Filters are saved with the _____________.
ID form
2 components of a Physical Schema
Process for creating the Project Metadata
Report Definitions
32. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
3 Methods of MSTR Desktop navigation
MSTR applications
Lookup Table structure of a moderately denormalized schema
33. A condition data must meet in order to be included in a report. Does affect the SQL.
Desktop Administrative Functions
MSTR applications
Lookup Table structure of a completely denormalized schema
Report Filter
34. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
2 types of Fact Expressions
Lookup Table structure of a completely normalized schema
Data warehouse characteristics
35. Level of OLAP integration
Simple Attribute Expression
Cannot create project objects
Very high; part of ETL process
Process for creating the Project Metadata
36. 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
ETL process
Compound Metric
2 types of Attribute Expression
Characteristics of Nested Metrics
37. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
2 types of Table Keys
4 types of Report Filters
Aggregate a Metric
The System
38. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Metrics
Desktop Designer
'View of a Report'
Report Filter
39. Enables you to rearrange the columns and rows in a report.
Attribute Forms
Components of a Metric
Data Pivoting
MSTR Desktop Architect
40. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
3 column types of a Physical Schema
Schema Objects
Desktop Designer
Limitations of the Attribute Creation Wizard
41. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Application Objects
'View of a Report'
Rollback your changes
42. Enables you to lock column headers so that they always appear when scrolling
ID form
Locking and Resizing
Fact Tables
Schema
43. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Compound Attribute
2 options for Sorting
Source system characteristics
Attribute Creation Wizard good for
44. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
ETL process
Desktop Administrative Functions
Default Project folder structure
Components of Compound Metrics
45. User reporting requirements - Query performance - Data volume - DB Maintenance
To create a Report Prompt
4 factors to consider when designing a data-warehouse schema
Banding
Different methods for creating Page-by fields
46. Subtotals reflect accumulations at selected attribute levels
Required on the report for Outline Model to work
To qualify a Metric in a Set Qualification
Subtotals
Facts
47. 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
5 Report display views
Report Subscription
Types of drilling
Banding
48. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
'View of a Report'
3 project creation interfaces
Lookup Tables
Metrics
49. A feature that enables users to delivers reports to the history list - cache or mobile
New SQL
Long-term (2 - 5 years)
Nested Metrics
Report Subscription
50. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Drilling
4 basic Schema objects
Types of analysis you can perform with OLAP Services
View Filter