SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. A condition data must meet in order to be included in a report. Does affect the SQL.
Reports
Schema Objects
By default
Report Filter
2. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Report Editor
Reports
4 basic Schema objects
3. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Banding
The 3 MSTR Tools
Components of the Logical Data Model
Sample Metrics commonly performed on Facts
4. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Filter operators
3 components of a Report
Report Template
3 column types of a Physical Schema
5. Schema Objects - Application Objects - Configuration Objects
Attribute Forms
3 Types of Objects in MSTR Desktop
Required on the report for Outline Model to work
Objects you are allowed to Page-by
6. A subset of a report that users can manipulate without altering the SQL
7. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Objects you are allowed to Page-by
MSTR applications
Types of drilling
Schema
8. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Attribute Relationships
File types are allowed for exporting a Report
3 components of a Report
Sorting
9. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Objects you are allowed to Page-by
2 methods to creating Facts
Level Prompts
OLTP
10. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Aggregate a Metric
Subtotals
Display views you can Print by
11. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
To edit the appearance of a Graph in a report
3 project creation interfaces
4 types of Prompts
Data Pivoting
12. Folder List - Object Viewer - Shortcut Bar
Project Creation Wizard
Attributes
3 Methods of MSTR Desktop navigation
3 Sections of the MSTR Desktop interface
13. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
4 properties you must know in order to create attributes using the Attribute Editor
2 components of a Physical Schema
Aggregate a Metric
Cannot create project objects
14. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Schema Object Editor
Physical Schema
4 parts of the Project Design Process
Components of a MSTR architecture
15. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
To create the Project connectivity
Application Objects
Banding
Attribute Forms
16. You must select "Other directions" when drilling attributes while viewing a report
To drill through User Hierarchies
Attribute Creation Wizard good for
Types of drilling
Fact Tables
17. Columns - Tables
2 components of a Physical Schema
Default Project folder structure
Attribute Elements
2 types of Attribute Expression
18. 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
Terabytes (TB)
'View of a Report'
Level Prompts
19. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
Schema Object Editor
3 Schema types
Architect Graphical Interface
Attribute Forms
20. 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
View Filter
Types of drilling
5 steps to creating a logical data model
Very high; part of ETL process
21. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Facts
Physical Schema
To create a Report Prompt
Unlimited
22. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Object Prompts
Compound Metric
OLTP
Shortcut Bar
23. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Components of a Derived Metric
View Filter
'View of a Report'
Project-level options/settings
24. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
To save a Report Format
Lookup Table structure of a moderately denormalized schema
Desktop Architec
25. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Terabytes (TB)
Outline Mode
Source system characteristics
Warehouse Catalog
26. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Stored
2 types of Fact Expressions
Process for creating the Project Metadata
27. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
View Filters
Components of a Metric
Search-based prompts
28. A new tool for project design tasks - used for fine-tuning a project after initial creation
2 options for Sorting
Architect Graphical Interface
Data warehouse characteristics
Facts
29. Extraction - transformation - loading
Using a Search Object
ID form
Attribute or its relationship(s)
ETL
30. Metrics aggregate on the lowest-level attribute __________.
Highest-level attributes
By default
Derived Attribute Expression
Types of analysis you can perform with OLAP Services
31. You can e-mail reports by going to _____
Desktop Analyst
MSTR applications
2 types of Facts
File > Email Reports As
32. OLAP retains data ________
Homogeneous Fact
4 factors to consider when designing a data-warehouse schema
Banding
Long-term (2 - 5 years)
33. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
MSTR Desktop Architect
Unlimited
Report Objects
34. Level of OLTP integration
Default Project folder structure
File types are allowed for exporting a Report
Desktop Designer
Minimal or none
35. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
2 methods to creating Facts
Limitations of the Attribute Creation Wizard
Reports
5 Report display views
36. Facts associated to different column names in 2 or more tables
3 project creation interfaces
Heterogeneous Attribute
Project Source
Heterogeneous Fact
37. An environment in which the MSTR Desktop connects directly to the Metadata database.
Heterogeneous Fact
Schema
4 basic Schema objects
2-Tier Architecture
38. Filter definition prompts - Object prompts - Value prompts - Level prompts
Rollback your changes
Default Project folder structure
3 project creation interfaces
4 types of Prompts
39. OLTP retains data ________
Short-term (2 - 6 months)
File types are allowed for exporting a Report
ID form
By default
40. The Attribute Form maps to different column names in multiple tables
Architect Graphical Interface
Heterogeneous Attribute
MSTR Desktop
'View of a Report'
41. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Search-based prompts
Metrics
4 basic Schema objects
Schema Object Editor
42. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Schema Objects
3 types of Attributes
4 types of Prompts
43. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Filter Definition Prompts
Report Formatting
To create the Project connectivity
2 types of Table Keys
44. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Relationship Tables
Value Prompts
Subtotals
Limitations of the Attribute Creation Wizard
45. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
View Filter
Cannot create project objects
Fact Tables
MSTR Connectivity Wizard
46. Specifies a condition data must meet in order to be included in a report
Report Filter
2 ways you can configure the Project Source to connect to the Metadata database
Desktop Architec
3 Methods of MSTR Desktop navigation
47. Enables you to select and display subsets of a report as separate pages.
Hierarchies
Page-by
By default
Project
48. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Objects you are allowed to Page-by
Level Prompts
Sample Metrics commonly performed on Facts
To edit the appearance of a Graph in a report
49. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Banding
Report Objects
Lookup Tables
To create the Project connectivity
50. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Short-term (2 - 6 months)
Objects you are allowed to Page-by
Components of a Metric