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. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Report Objects
Shortcut in MSTR Desktop
Very high; part of ETL process
2. Used to limit a possibly overwhelming set of potential prompt answers
2-Tier Architecture
Search-based prompts
Facts
Report Formatting
3. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
The System
MSTR Desktop
Compound Metric
4. Subtotals reflect accumulations at selected attribute levels
2 types of Attribute Relationships
Types of drilling
Subtotals
Attribute Forms
5. 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
5 Report display views
Data warehouse characteristics
ETL process
6. 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
Report Editor
Report Filter operators
Objects you are allowed to Page-by
7. Extraction - transformation - loading
Unlimited
ETL
Components of Compound Metrics
Objects you are allowed to Page-by
8. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
Very high; part of ETL process
2 types of Fact Expressions
2 components of a Physical Schema
9. Must have Subtotals enabled - or you won't see any data for higher-level attributes
View Filter
Simple Metrics
Required on the report for Outline Model to work
Lookup Tables
10. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Types of drilling
2 methods to creating Facts
Relationship Tables
View Filters
11. The Attribute Form maps to the same column name in multiple tables
Stored
Homogeneous Attribute
Notes
Lookup Table structure of a completely denormalized schema
12. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Components of Compound Metrics
Desktop Analyst
Very high; part of ETL process
Components of a MSTR architecture
13. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
2 ways you can configure the Project Source to connect to the Metadata database
Heterogeneous Fact
4 tasks of the Attribute Creation Wizard
14. Formula - Level (Dimensionality) - Conditionality - Transformation
Level Prompts
Logical Data Model
4 factors to consider when designing a data-warehouse schema
Components of a Metric
15. Groupings of directly related attributes. Also commonly known as "dimensions".
Desktop Architec
Hierarchies
Rollback your changes
Lookup Table structure of a moderately denormalized schema
16. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
2 types of Fact Expressions
Derived Metrics
Cannot create project objects
Compound Attribute
17. ID columns - Description columns - Fact columns
Project Source
Required on the report for Outline Model to work
Fact Tables
3 column types of a Physical Schema
18. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
To drill through User Hierarchies
User Hierarchies
Attribute Creation Wizard good for
Attribute or its relationship(s)
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
ETL
Reports
2 types of Table Keys
3 Schema types
20. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Unlimited
Configuration Wizard
Facts
21. Template - Filter - View of a Report
Lookup Table structure of a completely normalized schema
3 components of a Report
Facts
Reports
22. Grid View - Graph View - Grid/Graph View - SQL View
Derived Metrics
Display views you can Print by
Components of a Derived Metric
2 types of Fact Expressions
23. Facts - Attributes - Hierarchies
Unlimited
Schema Object Editor
Components of the Logical Data Model
Components of a Metric
24. Descriptive data that provides context for Facts.
Reports
Lookup Table structure of a moderately denormalized schema
Attribute Forms
3 functions of Attribute Forms
25. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
To qualify a Metric in a Set Qualification
Components of a Metric
Sorting
Project Source
26. Level of OLTP integration
Derived Metrics
Minimal or none
Configuration Wizard
Attributes
27. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
3 project creation interfaces
Characteristics of Nested Metrics
4 properties you must know in order to create attributes using the Attribute Editor
To edit the appearance of a Graph in a report
28. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Components of the Logical Data Model
Data warehouse characteristics
Methods are there to creating Attributes
Desktop Designer
29. OLAP retains data ________
Methods are there to creating Attributes
Limitations of the Attribute Creation Wizard
Long-term (2 - 5 years)
Warehouse Catalog
30. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Short-term (2 - 6 months)
Nested Metrics
Outline Mode
31. Specifies what info to retrieve from a data-warehouse - and how to display it
Project Source
Factors to consider when designing a logical data model
Report Template
3 column types of a Physical Schema
32. 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.
Report Prompts
2 components of a Physical Schema
MSTR applications
Schema Objects
33. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Components of the Logical Data Model
File types are allowed for exporting a Report
Minimal or none
Objects you are allowed to Page-by
34. Facts associated to the same column name in 1 or more tables
Lookup Tables
Report Filter
Homogeneous Fact
To "drill down" on a report
35. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Schema Object Editor
Relationship Tables
2 types of Fact Expressions
36. You can _____________ in the Architect Graphical Interface.
Subtotals
Attribute or its relationship(s)
Rollback your changes
Compound Attribute
37. To see data at completely different levels - other than that of the original Grid or Graph
Highest-level attributes
Desktop Designer
Facts
Drilling
38. Metrics that perform multiple aggregations; one calculation inside of another.
Desktop Administrative Functions
3 Types of Objects in MSTR Desktop
3 components of a Report
Nested Metrics
39. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Homogeneous Fact
4 tasks of the Attribute Creation Wizard
Compound Metric
40. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
5 Report display views
Required on the report for Outline Model to work
ID form
41. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Unlimited
Lookup Table structure of a completely normalized schema
Advantage of a completely denormalized schema
42. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
MSTR Desktop
Hierarchies
3 functions of Attribute Forms
43. Create the Project Source - Create the Database Instance
View Filters
Configuration Wizard
Compound Metric
To create the Project connectivity
44. 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
45. The unique values of an attribute obtained from the data-warehouse
Highest-level attributes
Attribute Elements
2-Tier Architecture
Required on the report for Outline Model to work
46. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Heterogeneous Fact
Required on the report for Outline Model to work
2 types of Table Keys
To edit the appearance of a Graph in a report
47. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Components of a Metric
Report Subscription
3 project creation interfaces
48. Direct: 2-tier - Server: 3-tier
Data Pivoting
Column Aliases
2 ways you can configure the Project Source to connect to the Metadata database
Facts
49. Level of OLAP integration
5 steps to creating a logical data model
View Filters
File > Email Reports As
Very high; part of ETL process
50. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Project
Homogeneous Fact
Facts
3 types of Attributes