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. Simple - Compound - Nested - Derived
Homogeneous Fact
Desktop Architec
2 types of Fact Expressions
4 types of Metrics
2. Specifies what info to retrieve from a data-warehouse - and how to display it
Heterogeneous Attribute
Report Template
ID form
2 types of Table Keys
3. Create the Project Source - Create the Database Instance
To create the Project connectivity
Report Definitions
3 types of Attributes
Lookup Table structure of a completely normalized schema
4. Enables you to rearrange the columns and rows in a report.
Components of a Derived Metric
Methods are there to creating Attributes
Objects you are allowed to Page-by
Data Pivoting
5. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
MSTR Desktop
Report Prompts
OLAP
6. The System Hierarchy is automatically updated whenever you make a change to an __________________.
2 types of Attribute Relationships
Attribute or its relationship(s)
3 Sections of the MSTR Desktop interface
Architect Graphical Interface
7. Schema Objects - Application Objects - Configuration Objects
Homogeneous Attribute
3 Types of Objects in MSTR Desktop
Long-term (2 - 5 years)
Attribute Relationships
8. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
To edit the appearance of a Graph in a report
Sorting
Minimal or none
9. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
The System
Components of Compound Metrics
Compound Metric
Heterogeneous Attribute
10. Prompts to select a single value on which to qualify a date - number or text string.
Schema Object Editor
Logical Data Model
Value Prompts
New SQL
11. Direct: 2-tier - Server: 3-tier
Search Object
Warehouse Catalog
New SQL
2 ways you can configure the Project Source to connect to the Metadata database
12. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Shortcut in MSTR Desktop
3 project creation interfaces
3-Tier Architecture
Report Template
13. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Lookup Table structure of a moderately denormalized schema
Report Editor
Hierarchies
14. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
The 3 MSTR Tools
Report Editor
Process for creating the Project Metadata
File > Email Reports As
15. OLAP Services does not add any ______ to the report query.
ETL
2 types of Fact Expressions
4 types of Report Filters
New SQL
16. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Project Creation Wizard
Lookup Tables
Components of a Metric
MSTR applications
17. OLTP data storage measure
2 methods to creating Facts
To create a Report Prompt
Gigabytes (GB)
New SQL
18. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
3 components of a Report
Homogeneous Fact
The 3 MSTR Tools
To "drill down" on a report
19. Facts associated to the same column name in 1 or more tables
Page-by
Homogeneous Fact
Attribute or its relationship(s)
Gigabytes (GB)
20. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Nested Metrics
3 project creation interfaces
Data Pivoting
2 methods to creating Facts
21. Grid View - Graph View - Grid/Graph View - SQL View
MSTR OLAP Services
Object Prompts
Display views you can Print by
To "drill down" on a report
22. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Fact Expression
3 Methods of MSTR Desktop navigation
New SQL
Schema Objects
23. Level of OLTP integration
Minimal or none
By default
To edit the appearance of a Graph in a report
Heterogeneous Fact
24. 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.
User Hierarchies
Compound Attribute
Long-term (2 - 5 years)
ETL process
25. Descriptive data that provides context for Facts.
Fact Tables
Attribute Forms
Highest-level attributes
Very high; part of ETL process
26. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Drilling
Required on the report for Outline Model to work
Warehouse Catalog
27. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Fact Expression
Table Keys
Outline Mode
2 types of Table Keys
28. 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.
3 components of a Report
Project Creation Wizard
Report Prompts
3-Tier Architecture
29. All report-level options overwrite ___________.
4 tasks of the Attribute Creation Wizard
Facts
Project-level options/settings
Source system characteristics
30. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Very high; part of ETL process
By default
To create a Report Prompt
31. Must have Subtotals enabled - or you won't see any data for higher-level attributes
2 types of Fact Expressions
Rollback your changes
Required on the report for Outline Model to work
MSTR Desktop
32. 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
Logical Data Model
Components of a Metric
Attribute Relationships
Column Aliases
33. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Using a Search Object
Value Prompts
Report Filter operators
Sorting
34. One that uses 2 or more columns as its ID
Compound Attribute
Shortcut in MSTR Desktop
Report Editor
Different methods for creating Page-by fields
35. Primary keys
Table Keys
Types of drilling
Outline Mode
To drill through User Hierarchies
36. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Desktop Administrative Functions
Object Prompts
Search-based prompts
Architect Graphical Interface
37. Used to "fine-tune" your Project
Characteristics of a Compound Table Key
Cannot create project objects
Configuration Wizard
Architect Graphical Interface
38. Simple - Derived
2 types of Attribute Expression
Types of analysis you can perform with OLAP Services
Report Objects
Thresholding
39. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Report Template
ETL process
To create a Report Prompt
Unlimited
40. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
Report Filter
Report Formatting
3 functions of Attribute Forms
41. 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
42. Enables you to select which tables from the data-warehouse to store in the Metadata database
Objects you are allowed to Page-by
Stored
Schema
Warehouse Catalog
43. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Architect Graphical Interface
5 Report display views
Homogeneous Attribute
Search-based prompts
44. View Filters can only ___________.
Reference Report Objects
'View of a Report'
Source system characteristics
Metrics
45. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Source system characteristics
2 types of Table Keys
Schema Object Editor
3 components of a Report
46. A feature that enables users to delivers reports to the history list - cache or mobile
Compound Metric
Source system characteristics
Report Subscription
Data Pivoting
47. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
To drill through User Hierarchies
Compound Metric
3 functions of Attribute Forms
New SQL
48. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Shortcut in MSTR Desktop
Project
Report Formatting
Report Template
49. The Attribute Form Expression that maps to a single column - no matter the number of tables
Desktop Administrative Functions
3 Types of Objects in MSTR Desktop
Simple Attribute Expression
5 Report display views
50. Template - Filter - View of a Report
Schema Objects
ETL
3 components of a Report
Warehouse Catalog