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. Tables - Facts - Attributes - Hierarchies
Locking and Resizing
Warehouse Catalog
4 basic Schema objects
Heterogeneous Fact
2. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Components of Compound Metrics
Warehouse Catalog
Components of the Logical Data Model
Desktop Analyst
3. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Components of Compound Metrics
Using a Search Object
Report Objects
ETL process
4. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Report Template
ID form
Search Object
5 steps to creating a logical data model
5. 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.
2-Tier Architecture
Report Prompts
Attribute Creation Wizard good for
Attribute Forms
6. 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
Locking and Resizing
Derived Metrics
Attribute Relationships
7. 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
File > Email Reports As
Search Object
Lookup Table structure of a completely denormalized schema
3 Schema types
8. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Filter Definition Prompts
MSTR OLAP Services
Warehouse Catalog
Desktop Administrative Functions
9. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
4 types of Report Filters
Project
Stored
Rollback your changes
10. Grid View - Graph View - Grid/Graph View - SQL View
Components of Compound Metrics
Display views you can Print by
View Filter
Heterogeneous Fact
11. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
MSTR Connectivity Wizard
Process for creating the Project Metadata
Characteristics of a Compound Table Key
Gigabytes (GB)
12. More storage - Complex SQL - Simple ETL
Fact Expression
Components of the Logical Data Model
Characteristics of a Compound Table Key
Attribute Creation Wizard good for
13. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Report Filter
Nested Metrics
Schema Objects
4 properties you must know in order to create attributes using the Attribute Editor
14. 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.
Sample Metrics commonly performed on Facts
Architect Graphical Interface
4 types of Prompts
User Hierarchies
15. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
View Filter
Using a Search Object
5 steps to creating a logical data model
16. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Unlimited
To create a Report Prompt
Drilling
Outline Mode
17. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Hierarchies
Warehouse Catalog
3-Tier Architecture
Shortcut in MSTR Desktop
18. Used to create or edit complex attributes - facts - hierarchies - and logical tables
4 basic Schema objects
Characteristics of a Simple Table Key
Schema Object Editor
2 ways you can configure the Project Source to connect to the Metadata database
19. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
MSTR Desktop Architect
3 Schema types
The 3 MSTR Tools
Metrics
20. 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
Types of drilling
Simple Metrics
2 options for Sorting
Sample Metrics commonly performed on Facts
21. Metrics aggregate on the lowest-level attribute __________.
OLAP
4 types of Metrics
Terabytes (TB)
By default
22. Less storage - Simple SQL - Complex ETL
Report Subscription
Characteristics of a Simple Table Key
Drilling
2 options for Sorting
23. A condition data must meet in order to be included in a report. Does affect the SQL.
Desktop Designer
Drilling
MSTR OLAP Services
Report Filter
24. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Architect Graphical Interface
Project Source
Facts
ETL
25. A method of organizing the appearance of report results in a Grid report based on a criteria
Components of a Metric
Banding
Report Template
Desktop Administrative Functions
26. Level of OLTP integration
Minimal or none
Report Prompts
Attribute Creation Wizard good for
Using a Search Object
27. User reporting requirements - Query performance - Data volume - DB Maintenance
Derived Metrics
5 steps to creating a logical data model
4 factors to consider when designing a data-warehouse schema
2 ways you can configure the Project Source to connect to the Metadata database
28. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
3 types of Attributes
Attribute or its relationship(s)
Components of the Logical Data Model
29. 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
Required on the report for Outline Model to work
Schema
Attributes
Logical Data Model
30. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
MSTR Desktop
Homogeneous Fact
Report Template
31. Creating multiple attributes quickly. Used during the initial project creation.
Metrics
Display views you can Print by
2 methods to creating Facts
Attribute Creation Wizard good for
32. Homogeneous - Heterogeneous
Data Pivoting
Components of Compound Metrics
The 3 MSTR Tools
2 types of Facts
33. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Project-level options/settings
Banding
View Filter
Metrics
34. Primary keys
To "drill down" on a report
OLAP
Subtotals
Table Keys
35. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Minimal or none
Terabytes (TB)
To create the Project connectivity
36. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Drilling
2 types of Table Keys
Unlimited
4 properties you must know in order to create attributes using the Attribute Editor
37. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
3 Sections of the MSTR Desktop interface
Fact Tables
Stored
Data Pivoting
38. Enables you to select which tables from the data-warehouse to store in the Metadata database
OLAP
Factors to consider when designing a logical data model
Warehouse Catalog
ETL process
39. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
OLTP
To create the Project connectivity
Project
40. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Lookup Table structure of a moderately denormalized schema
Using a Search Object
By default
Required on the report for Outline Model to work
41. Subtotals reflect accumulations at selected attribute levels
Physical Schema
Attribute Relationships
Subtotals
Notes
42. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
To edit the appearance of a Graph in a report
Fact Expression
Objects you are allowed to Page-by
43. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Notes
Source system characteristics
Attribute Creation Wizard good for
44. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Lookup Tables
The 3 MSTR Tools
Column Aliases
The System
45. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
3 components of a Report
Simple Metrics
2 ways you can configure the Project Source to connect to the Metadata database
Components of a MSTR architecture
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
4 properties you must know in order to create attributes using the Attribute Editor
MSTR applications
Components of a Derived Metric
Highest-level attributes
47. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Rollback your changes
Thresholding
Data Pivoting
Source system characteristics
48. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
File > Email Reports As
Long-term (2 - 5 years)
Hierarchies
Schema
49. Prompts to select a single value on which to qualify a date - number or text string.
Schema Objects
Report Subscription
Value Prompts
Table Keys
50. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
Highest-level attributes
Display views you can Print by
Advantage of a completely denormalized schema