SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Report Template
Minimal or none
Project
Physical Schema
2. The Attribute Form Expression that maps to a single column - no matter the number of tables
Report Filter
By default
Simple Attribute Expression
Components of a MSTR architecture
3. A user interface for creating and maintaining a BI environment
Source system characteristics
Lookup Tables
Physical Schema
MSTR Desktop
4. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Thresholding
Unlimited
Compound Metric
The 3 MSTR Tools
5. Columns - Tables
2 components of a Physical Schema
Types of drilling
4 types of Metrics
Data Pivoting
6. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Warehouse Catalog
Derived Metrics
4 properties you must know in order to create attributes using the Attribute Editor
7. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Attribute Elements
Default Project folder structure
5 Report display views
The System
8. You must select "Other directions" when drilling attributes while viewing a report
Shortcut in MSTR Desktop
2 types of Facts
To drill through User Hierarchies
Lookup Table structure of a completely normalized schema
9. Folder List - Object Viewer - Shortcut Bar
5 steps to creating a logical data model
Architect Graphical Interface
Column Aliases
3 Sections of the MSTR Desktop interface
10. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project Creation Wizard
Components of a MSTR architecture
Nested Metrics
Project
11. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
4 properties you must know in order to create attributes using the Attribute Editor
2 options for Sorting
5 Report display views
12. It contains links to specific folders in the Folder List
Default Project folder structure
Hierarchies
Shortcut Bar
Compound Attribute
13. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema Object Editor
Schema
Long-term (2 - 5 years)
2 types of Table Keys
14. Direct: 2-tier - Server: 3-tier
Data warehouse characteristics
2-Tier Architecture
2 ways you can configure the Project Source to connect to the Metadata database
Banding
15. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Shortcut in MSTR Desktop
Types of drilling
Facts
4 properties you must know in order to create attributes using the Attribute Editor
16. Facts - Attributes - Hierarchies
To edit the appearance of a Graph in a report
Reference Report Objects
Components of the Logical Data Model
Types of analysis you can perform with OLAP Services
17. A subset of a report that users can manipulate without altering the SQL
18. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Facts
4 tasks of the Attribute Creation Wizard
Object Prompts
4 types of Report Filters
19. User requirements - Existing source data - Technical and performance considerations
Components of Compound Metrics
Data Pivoting
Factors to consider when designing a logical data model
Homogeneous Fact
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
Project-level options/settings
Components of a Derived Metric
Process for creating the Project Metadata
Drilling
21. Prompts to select a single value on which to qualify a date - number or text string.
Terabytes (TB)
Value Prompts
5 steps to creating a logical data model
2 types of Facts
22. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Value Prompts
Architect Graphical Interface
Relationship Tables
Desktop Administrative Functions
23. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
2 options for Sorting
To edit the appearance of a Graph in a report
Lookup Tables
Compound Attribute
24. The default entry-points.
Highest-level attributes
Display views you can Print by
Relationship Tables
Components of Compound Metrics
25. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Fact Tables
2-Tier Architecture
Schema Object Editor
26. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Types of drilling
Objects you are allowed to Page-by
Attribute Forms
27. Grid View - Graph View - Grid/Graph View - SQL View
Project Creation Wizard
ETL
Display views you can Print by
Architect Graphical Interface
28. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Project Source
Factors to consider when designing a logical data model
Schema Objects
29. A development environment to create BI applications - allowing users to edit the Metadata database
3 Types of Objects in MSTR Desktop
Desktop Architec
Simple Metrics
3 Schema types
30. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Advantage of a completely denormalized schema
Facts
4 parts of the Project Design Process
Required on the report for Outline Model to work
31. Top menu/dropdowns - Toolbar - Right-click popup menus
2 options for Sorting
Attribute or its relationship(s)
3 Methods of MSTR Desktop navigation
Report Objects
32. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
3-Tier Architecture
Lookup Table structure of a completely normalized schema
Compound Metric
Shortcut in MSTR Desktop
33. All Attributes must have an _______.
Reports
ID form
Default Project folder structure
MSTR Desktop Architect
34. ID columns - Description columns - Fact columns
Components of a MSTR architecture
Search Object
Report Filter operators
3 column types of a Physical Schema
35. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Stored
Report Subscription
2 types of Table Keys
5 steps to creating a logical data model
36. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
Shortcut in MSTR Desktop
Characteristics of Nested Metrics
Desktop Architec
37. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Display views you can Print by
Heterogeneous Attribute
Report Template
Facts
38. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
Schema
4 types of Report Filters
Characteristics of Nested Metrics
Configuration Wizard
39. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Schema
Project Creation Wizard
Level Prompts
Facts
40. To see data at completely different levels - other than that of the original Grid or Graph
3 functions of Attribute Forms
View Filter
Characteristics of a Compound Table Key
Drilling
41. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Stored
Table Keys
Value Prompts
42. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
View Filter
MSTR applications
To drill through User Hierarchies
Sample Metrics commonly performed on Facts
43. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Banding
Lookup Table structure of a completely denormalized schema
4 types of Report Filters
Data warehouse characteristics
44. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
5 Report display views
Components of Compound Metrics
Search Object
Report Objects
45. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Project-level options/settings
Fact Tables
To create the Project connectivity
Thresholding
46. Must have a one-to-one relationship with all other forms.
Attribute or its relationship(s)
Facts
Attribute Forms
Limitations of the Attribute Creation Wizard
47. Reduced number of JOINS in the generated SQL
Facts
Project-level options/settings
Advantage of a completely denormalized schema
4 properties you must know in order to create attributes using the Attribute Editor
48. One that uses 2 or more columns as its ID
4 types of Metrics
Compound Attribute
Schema
Attribute Elements
49. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
5 steps to creating a logical data model
3-Tier Architecture
3 column types of a Physical Schema
50. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of a Simple Table Key
Desktop Architec
Search-based prompts
Desktop Designer