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. 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
Simple Metrics
Report Editor
Report Formatting
Filter Definition Prompts
2. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Thresholding
OLAP
MSTR Desktop Architect
Facts
3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Table Keys
3 components of a Report
MSTR Desktop Architect
4. All Attributes must have an _______.
To qualify a Metric in a Set Qualification
Source system characteristics
Heterogeneous Fact
ID form
5. 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
By default
Logical Data Model
Application Objects
To create a Report Prompt
6. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Notes
Schema Objects
Tasks when defining a User Hierarchy
7. What tool do you use to create the Metadata shell?
Desktop Architec
Advantage of a completely denormalized schema
Configuration Wizard
5 Report display views
8. Facts associated to different column names in 2 or more tables
Types of drilling
Default Project folder structure
Heterogeneous Fact
Attribute Elements
9. Top menu/dropdowns - Toolbar - Right-click popup menus
Warehouse Catalog
Metrics
Lookup Table structure of a completely normalized schema
3 Methods of MSTR Desktop navigation
10. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Simple Attribute Expression
Required on the report for Outline Model to work
Desktop Designer
11. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
To save a Report Format
Gigabytes (GB)
User Hierarchies
12. Facts - Attributes - Hierarchies
Sample Metrics commonly performed on Facts
Minimal or none
Components of the Logical Data Model
Characteristics of a Simple Table Key
13. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Column Aliases
Stored
Simple Metrics
14. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
2 types of Attribute Expression
OLAP
2 components of a Physical Schema
Components of a Derived Metric
15. Level of OLAP integration
2 types of Attribute Expression
Configuration Wizard
Very high; part of ETL process
3 Schema types
16. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Facts
To edit the appearance of a Graph in a report
2 components of a Physical Schema
17. Simple - Compound - Nested - Derived
Characteristics of a Compound Table Key
4 types of Metrics
Locking and Resizing
Compound Attribute
18. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Schema Object Editor
View Filters
2 types of Table Keys
Schema
19. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
4 basic Schema objects
5 steps to creating a logical data model
Schema
5 Report display views
20. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
2 methods to creating Facts
Report Definitions
Simple Attribute Expression
21. Creating multiple attributes quickly. Used during the initial project creation.
Characteristics of Nested Metrics
The System
Attribute Creation Wizard good for
Unlimited
22. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Characteristics of Nested Metrics
Page-by
Attribute Forms
Column Aliases
23. The Attribute Form maps to different column names in multiple tables
Cannot create project objects
Notes
Heterogeneous Attribute
Objects you are allowed to Page-by
24. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Homogeneous Attribute
3 Schema types
Simple Metrics
Derived Attribute Expression
25. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Schema Objects
Reports
Components of a MSTR architecture
Simple Attribute Expression
26. Prompts to select a single value on which to qualify a date - number or text string.
Tasks when defining a User Hierarchy
Value Prompts
Objects you are allowed to Page-by
2 types of Facts
27. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Report Objects
Filter Definition Prompts
3 project creation interfaces
28. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
'View of a Report'
2 methods to creating Facts
3 project creation interfaces
Limitations of the Attribute Creation Wizard
29. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Project Creation Wizard
Desktop Architec
To create a Report Prompt
Source system characteristics
30. The actual column name for a fact. Every fact must have at least 1 expression.
2 components of a Physical Schema
5 Report display views
Methods are there to creating Attributes
Fact Expression
31. Specifies a condition data must meet in order to be included in a report
Components of a Metric
Report Filter
Physical Schema
Lookup Table structure of a moderately denormalized schema
32. OLAP retains data ________
Data warehouse characteristics
Heterogeneous Fact
Long-term (2 - 5 years)
Attributes
33. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Report Filter
Derived Attribute Expression
New SQL
Fact Tables
34. Simple - Derived
Source system characteristics
Aggregate a Metric
Attribute or its relationship(s)
2 types of Attribute Expression
35. Specifies what info to retrieve from a data-warehouse - and how to display it
2 ways you can configure the Project Source to connect to the Metadata database
Report Template
3 column types of a Physical Schema
Display views you can Print by
36. A new tool for project design tasks - used for fine-tuning a project after initial creation
Schema Objects
File > Email Reports As
Schema Object Editor
Architect Graphical Interface
37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
2 components of a Physical Schema
Attribute Elements
Thresholding
'View of a Report'
38. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
39. It contains links to specific folders in the Folder List
Report Filter
Desktop Architec
Shortcut Bar
Architect Graphical Interface
40. Metrics you create within a report using only those objects in the report.
3-Tier Architecture
Warehouse Catalog
Derived Metrics
Short-term (2 - 6 months)
41. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Report Objects
MSTR applications
Object Prompts
Tasks when defining a User Hierarchy
42. Create the Project Source - Create the Database Instance
Compound Metric
To create the Project connectivity
Facts
Gigabytes (GB)
43. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Relationship Tables
Schema
Long-term (2 - 5 years)
44. One that uses 2 or more columns as its ID
Subtotals
Schema Object Editor
Attribute Creation Wizard good for
Compound Attribute
45. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Characteristics of a Simple Table Key
Components of the Logical Data Model
Attribute Elements
The System
46. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
'View of a Report'
Desktop Administrative Functions
Fact Expression
4 types of Metrics
47. The System Hierarchy is automatically updated whenever you make a change to an __________________.
4 properties you must know in order to create attributes using the Attribute Editor
3 column types of a Physical Schema
Attribute or its relationship(s)
4 factors to consider when designing a data-warehouse schema
48. Filter definition prompts - Object prompts - Value prompts - Level prompts
Characteristics of Nested Metrics
Components of a Derived Metric
4 types of Prompts
Types of drilling
49. 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
Report Editor
Types of drilling
Simple Metrics
4 parts of the Project Design Process
50. Attribute Creation Wizard - Attribute Editor
Sample Metrics commonly performed on Facts
Project
Methods are there to creating Attributes
Schema Objects