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. An environment in which the MSTR Desktop connects directly to the Metadata database.
Aggregate a Metric
Nested Metrics
2-Tier Architecture
Advantage of a completely denormalized schema
2. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Long-term (2 - 5 years)
User Hierarchies
2 methods to creating Facts
3. Enables you to lock column headers so that they always appear when scrolling
Attribute Forms
MSTR OLAP Services
Reference Report Objects
Locking and Resizing
4. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Project-level options/settings
Very high; part of ETL process
2 types of Table Keys
5. Level of OLAP integration
Highest-level attributes
Very high; part of ETL process
Shortcut in MSTR Desktop
Lookup Table structure of a moderately denormalized schema
6. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
4 types of Report Filters
To qualify a Metric in a Set Qualification
Shortcut in MSTR Desktop
7. Primary keys
Cannot create project objects
Search-based prompts
To create the Project connectivity
Table Keys
8. Subtotals reflect accumulations at selected attribute levels
Required on the report for Outline Model to work
Subtotals
Schema
4 factors to consider when designing a data-warehouse schema
9. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
MSTR applications
Column Aliases
Derived Metrics
Facts
10. Facts - Attributes - Hierarchies
2 types of Attribute Expression
Components of the Logical Data Model
4 factors to consider when designing a data-warehouse schema
Source system characteristics
11. All Attributes must have an _______.
Project-level options/settings
By default
Fact Tables
ID form
12. Specifies what info to retrieve from a data-warehouse - and how to display it
Objects you are allowed to Page-by
Report Template
Homogeneous Attribute
Homogeneous Fact
13. A development environment to create BI applications - allowing users to edit the Metadata database
Characteristics of a Simple Table Key
Schema Objects
Desktop Architec
2 options for Sorting
14. Facts associated to the same column name in 1 or more tables
Banding
Homogeneous Fact
3 Sections of the MSTR Desktop interface
Report Filter
15. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
OLTP
Report Definitions
New SQL
Desktop Administrative Functions
16. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Object Prompts
Advantage of a completely denormalized schema
Compound Attribute
17. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Search-based prompts
Search Object
Outline Mode
18. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Derived Attribute Expression
Attribute or its relationship(s)
MSTR Connectivity Wizard
Reference Report Objects
19. Groupings of directly related attributes. Also commonly known as "dimensions".
Different methods for creating Page-by fields
Hierarchies
Components of a MSTR architecture
3 Types of Objects in MSTR Desktop
20. OLTP data storage measure
Column Aliases
Gigabytes (GB)
Schema
Report Prompts
21. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Reference Report Objects
4 tasks of the Attribute Creation Wizard
Simple Attribute Expression
22. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Thresholding
'View of a Report'
4 basic Schema objects
Simple Metrics
23. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Cannot create project objects
Report Filter
Derived Attribute Expression
3 functions of Attribute Forms
24. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Methods are there to creating Attributes
Reports
Rollback your changes
25. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3 column types of a Physical Schema
3-Tier Architecture
Schema Object Editor
Process for creating the Project Metadata
26. Used to "fine-tune" your Project
Reports
Architect Graphical Interface
Facts
4 parts of the Project Design Process
27. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Warehouse Catalog
Report Editor
Value Prompts
28. 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
Data Pivoting
2 types of Facts
Table Keys
29. You can e-mail reports by going to _____
Desktop Designer
4 types of Prompts
File > Email Reports As
OLAP
30. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Page-by
View Filter
Report Objects
'View of a Report'
31. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Project Creation Wizard
4 tasks of the Attribute Creation Wizard
Fact Expression
MSTR OLAP Services
32. Used to modify a Report
Report Editor
File > Email Reports As
Search-based prompts
Application Objects
33. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Attribute or its relationship(s)
Lookup Tables
Data warehouse characteristics
Components of the Logical Data Model
34. How users can share comments for reports to other users
Report Editor
Notes
3 functions of Attribute Forms
Homogeneous Attribute
35. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Column Aliases
Short-term (2 - 6 months)
Attribute Forms
4 properties you must know in order to create attributes using the Attribute Editor
36. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Project
Nested Metrics
Search Object
Locking and Resizing
37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Table Keys
Thresholding
Subtotals
Report Subscription
38. Less storage - Simple SQL - Complex ETL
Default Project folder structure
Characteristics of a Simple Table Key
Report Filter
Physical Schema
39. The unique values of an attribute obtained from the data-warehouse
The 3 MSTR Tools
Attribute Elements
2 types of Facts
Metrics
40. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
3 column types of a Physical Schema
2 components of a Physical Schema
To save a Report Format
41. Prompts to select a single value on which to qualify a date - number or text string.
Attribute or its relationship(s)
Architect Graphical Interface
Derived Metrics
Value Prompts
42. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Simple Metrics
MSTR applications
Subtotals
Project Source
43. 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
Attribute Elements
Limitations of the Attribute Creation Wizard
MSTR Desktop
44. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
The 3 MSTR Tools
Schema
Desktop Analyst
Compound Attribute
45. It contains the ID and DESC columns of all higher-level attributes
Attributes
4 types of Metrics
Lookup Table structure of a completely denormalized schema
Facts
46. Columns - Tables
3 Types of Objects in MSTR Desktop
4 types of Metrics
2 components of a Physical Schema
Methods are there to creating Attributes
47. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Shortcut in MSTR Desktop
Logical Data Model
3 components of a Report
48. AND - OR - OR NOT - AND NOT
4 factors to consider when designing a data-warehouse schema
Lookup Table structure of a completely normalized schema
Report Filter operators
Heterogeneous Fact
49. 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
Facts
User Hierarchies
Notes
50. OLTP retains data ________
Heterogeneous Fact
Short-term (2 - 6 months)
Lookup Tables
Schema Object Editor