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. Extraction - transformation - loading
Report Filter
Value Prompts
Desktop Architec
ETL
2. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Report Filter
View Filters
Terabytes (TB)
3. Specifies a condition data must meet in order to be included in a report
Column Aliases
Filter Definition Prompts
2-Tier Architecture
Report Filter
4. Metrics aggregate on the lowest-level attribute __________.
To "drill down" on a report
Rollback your changes
Attribute Elements
By default
5. To see data at completely different levels - other than that of the original Grid or Graph
ETL
Drilling
2 options for Sorting
2 types of Attribute Expression
6. It contains the ID and DESC columns of all higher-level attributes
Object Prompts
Metrics
Stored
Lookup Table structure of a completely denormalized schema
7. Reduced number of JOINS in the generated SQL
3 Schema types
Compound Attribute
2 types of Attribute Relationships
Advantage of a completely denormalized schema
8. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Subtotals
File types are allowed for exporting a Report
Project
Report Filter
9. The Attribute Form Expression that maps to a single column - no matter the number of tables
2 components of a Physical Schema
Sorting
Relationship Tables
Simple Attribute Expression
10. It contains the ID column of all higher-level attributes
2-Tier Architecture
Lookup Table structure of a moderately denormalized schema
File > Email Reports As
Attribute Relationships
11. Descriptive data that provides context for Facts.
ETL
Desktop Administrative Functions
Attribute Forms
Gigabytes (GB)
12. Used to create or edit complex attributes - facts - hierarchies - and logical tables
4 parts of the Project Design Process
Schema Object Editor
2 types of Fact Expressions
To qualify a Metric in a Set Qualification
13. You can _____________ in the Architect Graphical Interface.
File types are allowed for exporting a Report
4 types of Report Filters
Facts
Rollback your changes
14. All Attributes must have an _______.
File types are allowed for exporting a Report
3 project creation interfaces
ID form
Sorting
15. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Components of a Derived Metric
Using a Search Object
Architect Graphical Interface
Report Filter operators
16. Attribute Creation Wizard - Attribute Editor
Short-term (2 - 6 months)
Methods are there to creating Attributes
User Hierarchies
2-Tier Architecture
17. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Report Filter
Factors to consider when designing a logical data model
Stored
Desktop Designer
18. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
MSTR Connectivity Wizard
Lookup Table structure of a moderately denormalized schema
Desktop Designer
Notes
19. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
MSTR Desktop Architect
Data warehouse characteristics
Desktop Designer
ETL
20. User reporting requirements - Query performance - Data volume - DB Maintenance
2 types of Attribute Expression
Characteristics of a Compound Table Key
4 factors to consider when designing a data-warehouse schema
Required on the report for Outline Model to work
21. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
MSTR OLAP Services
2 types of Attribute Expression
Report Formatting
22. OLAP retains data ________
Level Prompts
Long-term (2 - 5 years)
3-Tier Architecture
To drill through User Hierarchies
23. All report-level options overwrite ___________.
To "drill down" on a report
Tasks when defining a User Hierarchy
ETL process
Project-level options/settings
24. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
3 functions of Attribute Forms
Search Object
View Filter
25. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Report Filters
Notes
'View of a Report'
4 types of Prompts
26. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Shortcut Bar
Characteristics of Nested Metrics
2 types of Fact Expressions
2 types of Attribute Relationships
27. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Physical Schema
Types of drilling
2 options for Sorting
3-Tier Architecture
28. A feature that enables users to delivers reports to the history list - cache or mobile
To "drill down" on a report
Report Formatting
Lookup Table structure of a moderately denormalized schema
Report Subscription
29. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
MSTR Desktop
Attribute Forms
4 parts of the Project Design Process
2 types of Fact Expressions
30. Direct: 2-tier - Server: 3-tier
Column Aliases
ETL process
File > Email Reports As
2 ways you can configure the Project Source to connect to the Metadata database
31. Tables - Facts - Attributes - Hierarchies
Limitations of the Attribute Creation Wizard
Characteristics of a Compound Table Key
4 basic Schema objects
MSTR Desktop
32. Create the Project Source - Create the Database Instance
Minimal or none
To create the Project connectivity
2 types of Table Keys
'View of a Report'
33. 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
Simple Metrics
Schema Objects
Subtotals
34. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
Report Formatting
Relationship Tables
Types of drilling
35. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Reference Report Objects
4 parts of the Project Design Process
Subtotals
36. 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
Tasks when defining a User Hierarchy
Types of analysis you can perform with OLAP Services
Column Aliases
Application Objects
37. OLAP Services does not add any ______ to the report query.
New SQL
2-Tier Architecture
Stored
Unlimited
38. Groupings of directly related attributes. Also commonly known as "dimensions".
Compound Metric
Hierarchies
Data Pivoting
Lookup Table structure of a moderately denormalized schema
39. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Attribute Forms
Project Source
ETL process
40. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Report Formatting
2 types of Fact Expressions
Lookup Table structure of a completely normalized schema
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
ETL
2 types of Table Keys
Different methods for creating Page-by fields
Homogeneous Attribute
42. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Search Object
ETL process
Report Formatting
43. 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
Configuration Wizard
Logical Data Model
Stored
The 3 MSTR Tools
44. It contains links to specific folders in the Folder List
Locking and Resizing
To create a Report Prompt
Shortcut Bar
Report Formatting
45. What tool do you use to create the Metadata shell?
Configuration Wizard
Thresholding
Hierarchies
Relationship Tables
46. A development environment to create BI applications - allowing users to edit the Metadata database
Project Creation Wizard
Drilling
Desktop Architec
Desktop Designer
47. Level of OLTP integration
Objects you are allowed to Page-by
Derived Attribute Expression
Minimal or none
Report Subscription
48. Grid View - Graph View - Grid/Graph View - SQL View
Heterogeneous Attribute
Table Keys
Display views you can Print by
Filter Definition Prompts
49. 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
Drilling
MSTR Connectivity Wizard
Subtotals
50. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
The 3 MSTR Tools
Fact Expression
4 tasks of the Attribute Creation Wizard
To create a Report Prompt