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. Metrics that perform multiple aggregations; one calculation inside of another.
Facts
2-Tier Architecture
Advantage of a completely denormalized schema
Nested Metrics
2. Metrics aggregate on the lowest-level attribute __________.
5 steps to creating a logical data model
Components of a Derived Metric
Minimal or none
By default
3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Warehouse Catalog
Lookup Table structure of a moderately denormalized schema
2 methods to creating Facts
Search Object
4. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Facts
Schema
Default Project folder structure
5. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Terabytes (TB)
View Filters
2 methods to creating Facts
Metrics
6. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Using a Search Object
Report Objects
Subtotals
Metrics
7. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Derived Metrics
Homogeneous Attribute
Attribute or its relationship(s)
ETL process
8. Primary keys
3 column types of a Physical Schema
Table Keys
4 types of Metrics
Project Creation Wizard
9. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Sample Metrics commonly performed on Facts
3 Schema types
Column Aliases
10. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
The System
Homogeneous Fact
Display views you can Print by
11. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
3 Methods of MSTR Desktop navigation
View Filters
Lookup Tables
ETL process
12. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Project-level options/settings
2 types of Fact Expressions
Architect Graphical Interface
Configuration Wizard
13. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Default Project folder structure
Outline Mode
Very high; part of ETL process
MSTR applications
14. Facts associated to different column names in 2 or more tables
Project Creation Wizard
Characteristics of Nested Metrics
Heterogeneous Fact
Characteristics of a Simple Table Key
15. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
'View of a Report'
Compound Metric
Project Creation Wizard
16. Create the Project Source - Create the Database Instance
To create the Project connectivity
Report Editor
Aggregate a Metric
View Filters
17. Folder List - Object Viewer - Shortcut Bar
5 Report display views
Advantage of a completely denormalized schema
Data Pivoting
3 Sections of the MSTR Desktop interface
18. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
4 types of Report Filters
View Filter
Drilling
Heterogeneous Fact
19. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Limitations of the Attribute Creation Wizard
Source system characteristics
Reference Report Objects
ID form
20. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Schema Objects
MSTR Desktop
Facts
Components of a Derived Metric
21. The Attribute Form Expression that maps to a single column - no matter the number of tables
Compound Metric
Homogeneous Attribute
Simple Attribute Expression
Required on the report for Outline Model to work
22. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Report Prompts
Attribute or its relationship(s)
ETL process
3 Schema types
23. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Project
Physical Schema
Banding
Metrics
24. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
4 types of Prompts
2 types of Fact Expressions
Stored
3 Types of Objects in MSTR Desktop
25. OLAP retains data ________
Architect Graphical Interface
ID form
Source system characteristics
Long-term (2 - 5 years)
26. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Metrics
Report Objects
Report Filter operators
Project
27. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Attribute Forms
Page-by
Shortcut Bar
5 steps to creating a logical data model
28. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Table Keys
Report Template
To save a Report Format
29. Enables you to select and display subsets of a report as separate pages.
Page-by
To qualify a Metric in a Set Qualification
Desktop Designer
Homogeneous Fact
30. Filter definition prompts - Object prompts - Value prompts - Level prompts
Lookup Table structure of a completely denormalized schema
2 ways you can configure the Project Source to connect to the Metadata database
4 types of Prompts
Outline Mode
31. A shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
3 column types of a Physical Schema
Notes
3 components of a Report
32. Must have a one-to-one relationship with all other forms.
Source system characteristics
Attribute Forms
Rollback your changes
Components of Compound Metrics
33. Attribute Creation Wizard - Attribute Editor
2 types of Attribute Relationships
Level Prompts
Fact Tables
Methods are there to creating Attributes
34. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Filter
Components of a Metric
Report Filter
Banding
35. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
Default Project folder structure
Process for creating the Project Metadata
Attribute Elements
36. User requirements - Existing source data - Technical and performance considerations
ETL
Fact Expression
ETL process
Factors to consider when designing a logical data model
37. Enables you to select which tables from the data-warehouse to store in the Metadata database
Using a Search Object
Warehouse Catalog
Thresholding
2 types of Table Keys
38. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Characteristics of Nested Metrics
Report Objects
Locking and Resizing
Drilling
39. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Desktop Analyst
'View of a Report'
Components of a Derived Metric
40. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Schema Objects
Limitations of the Attribute Creation Wizard
OLAP
2 types of Table Keys
41. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
3 Types of Objects in MSTR Desktop
Report Editor
Derived Attribute Expression
42. Columns - Tables
2 components of a Physical Schema
Report Prompts
Minimal or none
Attribute Elements
43. Top menu/dropdowns - Toolbar - Right-click popup menus
ETL process
Architect Graphical Interface
3 Methods of MSTR Desktop navigation
4 factors to consider when designing a data-warehouse schema
44. Compound - Homogeneous - Heterogeneous
Page-by
2 ways you can configure the Project Source to connect to the Metadata database
3 types of Attributes
Compound Metric
45. OLAP Services does not add any ______ to the report query.
Logical Data Model
Report Filter
Desktop Administrative Functions
New SQL
46. Tables - Facts - Attributes - Hierarchies
File types are allowed for exporting a Report
2 components of a Physical Schema
4 basic Schema objects
Schema Object Editor
47. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Application Objects
To save a Report Format
Components of a Metric
Column Aliases
48. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Long-term (2 - 5 years)
Default Project folder structure
Fact Tables
Schema
49. Prompts to select a single value on which to qualify a date - number or text string.
4 properties you must know in order to create attributes using the Attribute Editor
Types of analysis you can perform with OLAP Services
Value Prompts
File > Email Reports As
50. The logical associations between attributes that exist based on a business rule
MSTR applications
Attribute Relationships
3 functions of Attribute Forms
Report Formatting