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
Thresholding
2 types of Table Keys
2 ways you can configure the Project Source to connect to the Metadata database
Gigabytes (GB)
2. Using the Prompt Generation Wizard - Inside the Report Editor
Characteristics of a Simple Table Key
Factors to consider when designing a logical data model
To create a Report Prompt
2 types of Table Keys
3. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
Components of a Derived Metric
Desktop Designer
4 basic Schema objects
4. Extraction - transformation - loading
4 tasks of the Attribute Creation Wizard
Search-based prompts
ETL
Thresholding
5. The Attribute Form maps to different column names in multiple tables
File > Email Reports As
Attribute Creation Wizard good for
Heterogeneous Attribute
Thresholding
6. You can _____________ in the Architect Graphical Interface.
Fact Tables
Outline Mode
Display views you can Print by
Rollback your changes
7. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLAP
Report Filter
4 types of Report Filters
Relationship Tables
8. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Short-term (2 - 6 months)
Schema Objects
2 methods to creating Facts
Outline Mode
9. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
ETL
3 components of a Report
Outline Mode
10. The logical associations between attributes that exist based on a business rule
Characteristics of a Compound Table Key
Attribute Relationships
Report Editor
Notes
11. Top menu/dropdowns - Toolbar - Right-click popup menus
Data warehouse characteristics
Project
OLTP
3 Methods of MSTR Desktop navigation
12. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Gigabytes (GB)
ETL
Components of a Metric
13. It contains the ID column of all higher-level attributes
Report Editor
Methods are there to creating Attributes
Heterogeneous Fact
Lookup Table structure of a moderately denormalized schema
14. Enables you to rearrange the columns and rows in a report.
Schema Objects
Data Pivoting
Unlimited
Reference Report Objects
15. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Types of analysis you can perform with OLAP Services
Lookup Tables
Project
2 types of Table Keys
16. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Lookup Table structure of a completely denormalized schema
2 methods to creating Facts
Report Filter operators
Required on the report for Outline Model to work
17. OLAP data storage measure
Terabytes (TB)
To create a Report Prompt
Report Editor
Using a Search Object
18. Metrics you create within a report using only those objects in the report.
4 parts of the Project Design Process
3 Sections of the MSTR Desktop interface
Report Filter
Derived Metrics
19. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Physical Schema
To save a Report Format
Schema
View Filters
20. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Fact Tables
By default
Sorting
21. Must have a one-to-one relationship with all other forms.
Application Objects
Attribute Forms
By default
User Hierarchies
22. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Hierarchies
Cannot create project objects
Heterogeneous Attribute
23. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Attribute Forms
Minimal or none
Sample Metrics commonly performed on Facts
2 options for Sorting
24. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Lookup Table structure of a moderately denormalized schema
Report Definitions
Report Filter operators
25. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
File types are allowed for exporting a Report
Level Prompts
ETL process
To drill through User Hierarchies
26. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 types of Prompts
3 Schema types
4 tasks of the Attribute Creation Wizard
Fact Expression
27. Enables you to select and display subsets of a report as separate pages.
Page-by
Schema Objects
3 types of Attributes
Sorting
28. Create the Project Source - Create the Database Instance
Homogeneous Attribute
To create the Project connectivity
Fact Tables
Process for creating the Project Metadata
29. The unique values of an attribute obtained from the data-warehouse
Simple Attribute Expression
Report Filter
Attribute Elements
MSTR applications
30. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Application Objects
Logical Data Model
Report Objects
'View of a Report'
31. To define the level of aggregation for a specific metric - Used for qualifications
Heterogeneous Fact
Project Creation Wizard
Shortcut in MSTR Desktop
Attributes
32. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Reports
File types are allowed for exporting a Report
Using a Search Object
To "drill down" on a report
33. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
3 Sections of the MSTR Desktop interface
Project Source
3 project creation interfaces
Project Creation Wizard
34. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Characteristics of a Compound Table Key
OLTP
Homogeneous Fact
35. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
Application Objects
Derived Attribute Expression
Filter Definition Prompts
36. A new tool for project design tasks - used for fine-tuning a project after initial creation
User Hierarchies
File types are allowed for exporting a Report
Architect Graphical Interface
Report Filter operators
37. 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
Attribute Creation Wizard good for
2 types of Table Keys
Using a Search Object
38. Facts associated to different column names in 2 or more tables
Data warehouse characteristics
Desktop Architec
Heterogeneous Fact
Schema Objects
39. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Minimal or none
Filter Definition Prompts
4 basic Schema objects
Lookup Tables
40. Filter definition prompts - Object prompts - Value prompts - Level prompts
Gigabytes (GB)
4 types of Report Filters
4 types of Prompts
To "drill down" on a report
41. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
Terabytes (TB)
Physical Schema
5 steps to creating a logical data model
42. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
To qualify a Metric in a Set Qualification
Facts
Using a Search Object
4 types of Metrics
43. 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
Sample Metrics commonly performed on Facts
Tasks when defining a User Hierarchy
Components of a MSTR architecture
Warehouse Catalog
44. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
Aggregate a Metric
2 ways you can configure the Project Source to connect to the Metadata database
OLTP
45. View Filters can only ___________.
Reference Report Objects
Shortcut in MSTR Desktop
Components of a MSTR architecture
Lookup Tables
46. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Project-level options/settings
4 factors to consider when designing a data-warehouse schema
Level Prompts
Table Keys
47. You can e-mail reports by going to _____
2 types of Attribute Relationships
5 steps to creating a logical data model
Types of analysis you can perform with OLAP Services
File > Email Reports As
48. Tables - Facts - Attributes - Hierarchies
Report Editor
Page-by
4 basic Schema objects
Very high; part of ETL process
49. One that uses 2 or more columns as its ID
Hierarchies
Compound Attribute
To create the Project connectivity
Object Prompts
50. View Filters are saved with the _____________.
Schema Object Editor
Heterogeneous Fact
Report Definitions
Report Filter operators