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. Must have a one-to-one relationship with all other forms.
Characteristics of a Simple Table Key
Project-level options/settings
MSTR OLAP Services
Attribute Forms
2. You must select "Other directions" when drilling attributes while viewing a report
File types are allowed for exporting a Report
Project Source
To drill through User Hierarchies
New SQL
3. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Characteristics of a Compound Table Key
Report Objects
Default Project folder structure
Objects you are allowed to Page-by
4. View Filters are saved with the _____________.
Report Definitions
4 parts of the Project Design Process
'View of a Report'
MSTR OLAP Services
5. Reduced number of JOINS in the generated SQL
Report Objects
Advantage of a completely denormalized schema
Characteristics of Nested Metrics
Simple Attribute Expression
6. OLTP data storage measure
The System
Limitations of the Attribute Creation Wizard
Gigabytes (GB)
5 steps to creating a logical data model
7. 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
Data Pivoting
Unlimited
4 types of Report Filters
Facts
8. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Object Prompts
3 Methods of MSTR Desktop navigation
Desktop Administrative Functions
Minimal or none
9. Homogeneous - Heterogeneous
Report Objects
Terabytes (TB)
2 types of Facts
2 components of a Physical Schema
10. Used to "fine-tune" your Project
Shortcut in MSTR Desktop
Architect Graphical Interface
Project-level options/settings
Table Keys
11. Facts associated to the same column name in 1 or more tables
By default
4 tasks of the Attribute Creation Wizard
Reports
Homogeneous Fact
12. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Objects you are allowed to Page-by
Report Formatting
Short-term (2 - 6 months)
MSTR OLAP Services
13. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Configuration Wizard
Warehouse Catalog
Relationship Tables
3 functions of Attribute Forms
14. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Project Source
4 parts of the Project Design Process
Report Prompts
Project
15. Using the Prompt Generation Wizard - Inside the Report Editor
File > Email Reports As
Physical Schema
Stored
To create a Report Prompt
16. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Lookup Table structure of a completely denormalized schema
ETL process
To save a Report Format
3 types of Attributes
17. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Lookup Tables
Project
Components of a Derived Metric
3-Tier Architecture
18. OLAP data storage measure
3 functions of Attribute Forms
Short-term (2 - 6 months)
Simple Attribute Expression
Terabytes (TB)
19. The logical associations between attributes that exist based on a business rule
Attribute Relationships
Terabytes (TB)
2-Tier Architecture
Report Definitions
20. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Derived Attribute Expression
2-Tier Architecture
OLTP
Compound Attribute
21. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Sorting
Table Keys
Components of Compound Metrics
22. A new tool for project design tasks - used for fine-tuning a project after initial creation
By default
Architect Graphical Interface
Report Filter
User Hierarchies
23. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Lookup Table structure of a completely normalized schema
3-Tier Architecture
4 basic Schema objects
24. OLAP Services does not add any ______ to the report query.
2 options for Sorting
Components of a MSTR architecture
Sample Metrics commonly performed on Facts
New SQL
25. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
4 types of Metrics
Report Filter
File types are allowed for exporting a Report
26. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
2 methods to creating Facts
Types of drilling
The 3 MSTR Tools
Rollback your changes
27. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Attributes
Homogeneous Attribute
Limitations of the Attribute Creation Wizard
Search Object
28. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Shortcut Bar
Project Source
Desktop Designer
Lookup Table structure of a moderately denormalized schema
29. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
To create the Project connectivity
Notes
Report Filter operators
Project
30. OLAP retains data ________
Simple Metrics
2 types of Fact Expressions
Long-term (2 - 5 years)
Notes
31. All Attributes must have an _______.
Data warehouse characteristics
Project Source
ID form
Objects you are allowed to Page-by
32. Facts associated to different column names in 2 or more tables
Value Prompts
Architect Graphical Interface
Terabytes (TB)
Heterogeneous Fact
33. Top menu/dropdowns - Toolbar - Right-click popup menus
Desktop Architec
3 Methods of MSTR Desktop navigation
Simple Attribute Expression
Project Creation Wizard
34. It contains the ID column of the parent attribute
2 types of Facts
Derived Metrics
Lookup Table structure of a completely normalized schema
Different methods for creating Page-by fields
35. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Derived Metrics
Long-term (2 - 5 years)
3-Tier Architecture
Sample Metrics commonly performed on Facts
36. Used to limit a possibly overwhelming set of potential prompt answers
MSTR applications
Search-based prompts
Report Filter operators
Report Filter
37. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Short-term (2 - 6 months)
Default Project folder structure
5 steps to creating a logical data model
Attribute Forms
38. You can _____________ in the Architect Graphical Interface.
Schema Objects
Rollback your changes
Attribute or its relationship(s)
Homogeneous Fact
39. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Objects you are allowed to Page-by
The 3 MSTR Tools
ETL process
40. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
MSTR Desktop
Components of the Logical Data Model
Object Prompts
File types are allowed for exporting a Report
41. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Hierarchies
Stored
Subtotals
42. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Different methods for creating Page-by fields
Short-term (2 - 6 months)
Banding
43. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Report Filter
Attribute Relationships
Components of a MSTR architecture
44. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Desktop Architec
Stored
To edit the appearance of a Graph in a report
Compound Metric
45. To define the level of aggregation for a specific metric - Used for qualifications
MSTR Connectivity Wizard
Attributes
2 components of a Physical Schema
Thresholding
46. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Attributes
Homogeneous Attribute
Desktop Designer
User Hierarchies
47. An environment in which the MSTR Desktop connects directly to the Metadata database.
5 steps to creating a logical data model
2-Tier Architecture
Configuration Wizard
2 options for Sorting
48. Extraction - transformation - loading
MSTR applications
Data warehouse characteristics
ETL
Attribute Creation Wizard good for
49. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Unlimited
Schema Objects
3 components of a Report
2 types of Table Keys
50. Enables you to rearrange the columns and rows in a report.
Components of a MSTR architecture
Data Pivoting
4 properties you must know in order to create attributes using the Attribute Editor
Project Source