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. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Unlimited
Derived Attribute Expression
Notes
2. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
View Filters
Very high; part of ETL process
Using a Search Object
Project Source
3. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
To "drill down" on a report
OLAP
Reports
Desktop Administrative Functions
4. To define the level of aggregation for a specific metric - Used for qualifications
Notes
Heterogeneous Attribute
Aggregate a Metric
Attributes
5. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
Shortcut in MSTR Desktop
Desktop Analyst
Lookup Table structure of a completely denormalized schema
6. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Reports
Banding
Level Prompts
Methods are there to creating Attributes
7. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
3 Schema types
Homogeneous Fact
2 types of Fact Expressions
8. Metrics aggregate on the lowest-level attribute __________.
By default
Report Template
Attribute Elements
ID form
9. 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
Report Filter
Unlimited
Simple Metrics
Report Subscription
10. Top menu/dropdowns - Toolbar - Right-click popup menus
Components of a Derived Metric
Facts
Report Filter
3 Methods of MSTR Desktop navigation
11. The unique values of an attribute obtained from the data-warehouse
4 types of Prompts
To create a Report Prompt
Attribute Elements
Different methods for creating Page-by fields
12. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Logical Data Model
MSTR OLAP Services
Thresholding
'View of a Report'
13. Using the Prompt Generation Wizard - Inside the Report Editor
Schema
4 types of Prompts
To create a Report Prompt
3 Schema types
14. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
MSTR applications
4 properties you must know in order to create attributes using the Attribute Editor
View Filter
Banding
15. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
2 types of Attribute Relationships
Lookup Table structure of a completely normalized schema
Heterogeneous Fact
ETL process
16. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
3 Methods of MSTR Desktop navigation
Sample Metrics commonly performed on Facts
Reports
17. The Attribute Form maps to the same column name in multiple tables
Report Formatting
Column Aliases
Report Prompts
Homogeneous Attribute
18. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Report Editor
Schema
File types are allowed for exporting a Report
3-Tier Architecture
19. Specifies a condition data must meet in order to be included in a report
Using a Search Object
OLAP
Report Filter
4 parts of the Project Design Process
20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Project Creation Wizard
Components of a MSTR architecture
Display views you can Print by
3 components of a Report
21. User requirements - Existing source data - Technical and performance considerations
Short-term (2 - 6 months)
Attributes
Factors to consider when designing a logical data model
Fact Expression
22. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
MSTR OLAP Services
Source system characteristics
2 ways you can configure the Project Source to connect to the Metadata database
Data Pivoting
23. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Attribute Relationships
3 Sections of the MSTR Desktop interface
4 basic Schema objects
Types of analysis you can perform with OLAP Services
24. Less storage - Simple SQL - Complex ETL
The System
Characteristics of a Simple Table Key
Components of the Logical Data Model
Hierarchies
25. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Project-level options/settings
Characteristics of a Simple Table Key
Search Object
26. Template - Filter - View of a Report
2 types of Attribute Expression
3 components of a Report
Tasks when defining a User Hierarchy
2 types of Table Keys
27. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
2 types of Facts
Cannot create project objects
Terabytes (TB)
3 Schema types
28. 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
Components of a Derived Metric
Short-term (2 - 6 months)
ID form
29. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
3 functions of Attribute Forms
Page-by
4 types of Metrics
Using a Search Object
30. The default entry-points.
Highest-level attributes
Methods are there to creating Attributes
To qualify a Metric in a Set Qualification
Attribute or its relationship(s)
31. 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
Characteristics of Nested Metrics
3 Schema types
5 steps to creating a logical data model
File > Email Reports As
32. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
Sample Metrics commonly performed on Facts
MSTR Connectivity Wizard
3 components of a Report
33. A development environment to create BI applications - allowing users to edit the Metadata database
Reports
Lookup Tables
Desktop Architec
Schema Object Editor
34. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Tasks when defining a User Hierarchy
Components of a Metric
Reference Report Objects
To edit the appearance of a Graph in a report
35. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Metrics
File types are allowed for exporting a Report
Characteristics of Nested Metrics
MSTR OLAP Services
36. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Nested Metrics
3 Methods of MSTR Desktop navigation
MSTR OLAP Services
Column Aliases
37. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Sample Metrics commonly performed on Facts
2 methods to creating Facts
Lookup Tables
38. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
ETL process
User Hierarchies
Gigabytes (GB)
39. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
3 project creation interfaces
Components of a Metric
2 methods to creating Facts
Stored
40. 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 MSTR architecture
Components of a Derived Metric
Fact Tables
3-Tier Architecture
41. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Reference Report Objects
To drill through User Hierarchies
Simple Attribute Expression
42. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Homogeneous Fact
Methods are there to creating Attributes
The System
Process for creating the Project Metadata
43. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
To edit the appearance of a Graph in a report
Homogeneous Fact
Characteristics of a Compound Table Key
Objects you are allowed to Page-by
44. It contains links to specific folders in the Folder List
Report Subscription
Cannot create project objects
3-Tier Architecture
Shortcut Bar
45. One that uses 2 or more columns as its ID
Level Prompts
2 methods to creating Facts
Locking and Resizing
Compound Attribute
46. All Attributes must have an _______.
ID form
OLTP
Process for creating the Project Metadata
Relationship Tables
47. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Components of a Metric
5 steps to creating a logical data model
Report Subscription
48. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Report Definitions
Sorting
MSTR Desktop Architect
2 components of a Physical Schema
49. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Search-based prompts
Facts
Compound Metric
3 Schema types
50. 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.
OLTP
View Filters
3 Sections of the MSTR Desktop interface
Components of a Metric