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. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
MSTR Connectivity Wizard
Schema Objects
Gigabytes (GB)
Facts
2. A feature that enables users to delivers reports to the history list - cache or mobile
Rollback your changes
MSTR Desktop
Report Subscription
Methods are there to creating Attributes
3. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Compound Attribute
MSTR Desktop
Using a Search Object
3 types of Attributes
4. Enables you to rearrange the columns and rows in a report.
Lookup Table structure of a moderately denormalized schema
4 basic Schema objects
Data Pivoting
ETL process
5. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
2 types of Fact Expressions
Search Object
The System
Sorting
6. What tool do you use to create the Metadata DSN connection?
OLAP
New SQL
MSTR Connectivity Wizard
Data warehouse characteristics
7. Facts - Attributes - Hierarchies
Source system characteristics
Components of the Logical Data Model
Shortcut Bar
User Hierarchies
8. 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
MSTR applications
2 ways you can configure the Project Source to connect to the Metadata database
Simple Metrics
3 column types of a Physical Schema
9. You can e-mail reports by going to _____
File > Email Reports As
To edit the appearance of a Graph in a report
2 methods to creating Facts
Level Prompts
10. Enables you to select which tables from the data-warehouse to store in the Metadata database
3 Sections of the MSTR Desktop interface
Value Prompts
Characteristics of Nested Metrics
Warehouse Catalog
11. One that uses 2 or more columns as its ID
Components of a Derived Metric
Compound Attribute
'View of a Report'
4 types of Prompts
12. Allow you to interact with the BI system - logically organize data to analyze complex relationships
View Filters
New SQL
4 basic Schema objects
MSTR applications
13. Formula - Level (Dimensionality) - Conditionality - Transformation
Desktop Administrative Functions
Facts
Notes
Components of a Metric
14. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
To save a Report Format
Warehouse Catalog
Unlimited
Attributes
15. 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.
Derived Metrics
Terabytes (TB)
Long-term (2 - 5 years)
User Hierarchies
16. Used to create or edit complex attributes - facts - hierarchies - and logical tables
To "drill down" on a report
Schema Object Editor
Heterogeneous Fact
Components of the Logical Data Model
17. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
To save a Report Format
Derived Attribute Expression
Attribute or its relationship(s)
Report Template
18. Enables you to format report values based on a condition - such as highlights - font colors - etc.
4 basic Schema objects
Attribute Elements
Thresholding
Attributes
19. Reduced number of JOINS in the generated SQL
3 Schema types
Heterogeneous Fact
Advantage of a completely denormalized schema
To create a Report Prompt
20. Enables you to select and display subsets of a report as separate pages.
2 components of a Physical Schema
Short-term (2 - 6 months)
Page-by
3 Methods of MSTR Desktop navigation
21. Simple - Compound - Nested - Derived
Homogeneous Attribute
Factors to consider when designing a logical data model
4 types of Metrics
Notes
22. An environment in which the MSTR Desktop connects directly to the Metadata database.
Desktop Architec
2-Tier Architecture
Table Keys
3-Tier Architecture
23. OLAP data storage measure
View Filter
Hierarchies
Terabytes (TB)
4 types of Metrics
24. To define the level of aggregation for a specific metric - Used for qualifications
To drill through User Hierarchies
Attributes
MSTR Desktop
Types of analysis you can perform with OLAP Services
25. 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
MSTR Connectivity Wizard
Lookup Table structure of a completely denormalized schema
Components of Compound Metrics
Types of drilling
26. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Report Subscription
Minimal or none
Components of a Derived Metric
View Filters
27. Compound - Homogeneous - Heterogeneous
3 types of Attributes
3 Schema types
Fact Tables
Subtotals
28. Metrics you create within a report using only those objects in the report.
Desktop Architec
Derived Metrics
To edit the appearance of a Graph in a report
Aggregate a Metric
29. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Schema Object Editor
Compound Metric
Reports
Nested Metrics
30. To see data at completely different levels - other than that of the original Grid or Graph
Subtotals
2 types of Table Keys
Drilling
Types of drilling
31. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
4 basic Schema objects
Report Filter
2 components of a Physical Schema
Facts
32. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
4 tasks of the Attribute Creation Wizard
Project Creation Wizard
To drill through User Hierarchies
Level Prompts
33. Used to limit a possibly overwhelming set of potential prompt answers
Fact Expression
Search-based prompts
New SQL
'View of a Report'
34. A method of organizing the appearance of report results in a Grid report based on a criteria
Lookup Table structure of a moderately denormalized schema
Banding
File types are allowed for exporting a Report
OLAP
35. Metrics aggregate on the lowest-level attribute __________.
4 types of Prompts
By default
Locking and Resizing
4 parts of the Project Design Process
36. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Heterogeneous Fact
Objects you are allowed to Page-by
Components of a Derived Metric
3 types of Attributes
37. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
User Hierarchies
3 project creation interfaces
Cannot create project objects
OLTP
38. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Objects
To save a Report Format
Report Template
Types of analysis you can perform with OLAP Services
39. Must have a one-to-one relationship with all other forms.
3 column types of a Physical Schema
Logical Data Model
Attribute Forms
Table Keys
40. What tool do you use to create the Metadata shell?
Configuration Wizard
Default Project folder structure
Aggregate a Metric
Report Editor
41. View Filters can only ___________.
Drilling
MSTR OLAP Services
Simple Attribute Expression
Reference Report Objects
42. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
View Filter
Process for creating the Project Metadata
Simple Attribute Expression
43. 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.
View Filters
User Hierarchies
Warehouse Catalog
Application Objects
44. 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
Drilling
3 functions of Attribute Forms
3 components of a Report
Attribute or its relationship(s)
45. Primary keys
Short-term (2 - 6 months)
Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
Lookup Table structure of a completely denormalized schema
46. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
3 project creation interfaces
Unlimited
To "drill down" on a report
Derived Metrics
47. OLAP Services does not add any ______ to the report query.
New SQL
Default Project folder structure
OLAP
Desktop Administrative Functions
48. The unique values of an attribute obtained from the data-warehouse
2 components of a Physical Schema
Attribute Elements
Report Filter
3 functions of Attribute Forms
49. 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
Report Objects
4 tasks of the Attribute Creation Wizard
4 factors to consider when designing a data-warehouse schema
50. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Report Prompts
To qualify a Metric in a Set Qualification
Banding