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. Grid View - Graph View - Grid/Graph View - SQL View
3 types of Attributes
Display views you can Print by
Components of the Logical Data Model
The System
2. 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
Report Prompts
Schema
4 types of Metrics
3 functions of Attribute Forms
3. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Report Formatting
Facts
Tasks when defining a User Hierarchy
3 Methods of MSTR Desktop navigation
4. Schema Objects - Application Objects - Configuration Objects
To edit the appearance of a Graph in a report
Attribute or its relationship(s)
3 Types of Objects in MSTR Desktop
Data warehouse characteristics
5. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Nested Metrics
3-Tier Architecture
Column Aliases
Very high; part of ETL process
6. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
2-Tier Architecture
User Hierarchies
2 types of Attribute Expression
Sample Metrics commonly performed on Facts
7. OLTP data storage measure
View Filter
MSTR Desktop Architect
Homogeneous Attribute
Gigabytes (GB)
8. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Simple Attribute Expression
MSTR applications
To create a Report Prompt
9. A feature that enables users to delivers reports to the history list - cache or mobile
Aggregate a Metric
Metrics
Report Subscription
Report Prompts
10. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
3 column types of a Physical Schema
3 Methods of MSTR Desktop navigation
Project Creation Wizard
Process for creating the Project Metadata
11. You can e-mail reports by going to _____
File > Email Reports As
Default Project folder structure
Long-term (2 - 5 years)
Source system characteristics
12. Enables you to select and display subsets of a report as separate pages.
Page-by
4 types of Prompts
Homogeneous Fact
Report Filter operators
13. 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
Report Subscription
Fact Tables
View Filter
3 Schema types
14. Filter definition prompts - Object prompts - Value prompts - Level prompts
Homogeneous Fact
Source system characteristics
4 types of Prompts
Logical Data Model
15. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 types of Attribute Relationships
Search Object
Schema Objects
Gigabytes (GB)
16. Template - Filter - View of a Report
Simple Metrics
3 components of a Report
ETL
2 ways you can configure the Project Source to connect to the Metadata database
17. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Schema Object Editor
Simple Metrics
Project Creation Wizard
Shortcut Bar
18. 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 Derived Metric
3 Types of Objects in MSTR Desktop
Banding
Attribute Creation Wizard good for
19. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Shortcut in MSTR Desktop
Derived Metrics
To save a Report Format
3 column types of a Physical Schema
20. 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
User Hierarchies
Attribute Forms
Logical Data Model
Architect Graphical Interface
21. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Desktop Administrative Functions
Using a Search Object
Project Creation Wizard
Very high; part of ETL process
22. A user interface for creating and maintaining a BI environment
New SQL
MSTR Desktop
Aggregate a Metric
Long-term (2 - 5 years)
23. Less storage - Simple SQL - Complex ETL
Short-term (2 - 6 months)
Subtotals
Characteristics of a Simple Table Key
Advantage of a completely denormalized schema
24. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Attribute or its relationship(s)
Report Subscription
Components of a MSTR architecture
25. Must have a one-to-one relationship with all other forms.
Architect Graphical Interface
Components of the Logical Data Model
Attribute Forms
Sorting
26. More storage - Complex SQL - Simple ETL
4 parts of the Project Design Process
ETL
Report Definitions
Characteristics of a Compound Table Key
27. Level of OLAP integration
Attribute Creation Wizard good for
Gigabytes (GB)
Homogeneous Fact
Very high; part of ETL process
28. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Shortcut Bar
Reports
Architect Graphical Interface
29. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
2 types of Facts
2 ways you can configure the Project Source to connect to the Metadata database
To drill through User Hierarchies
OLTP
30. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Report Definitions
Desktop Analyst
To qualify a Metric in a Set Qualification
Table Keys
31. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
4 parts of the Project Design Process
Lookup Table structure of a moderately denormalized schema
Fact Tables
Unlimited
32. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Schema
Lookup Table structure of a completely normalized schema
Different methods for creating Page-by fields
33. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
File > Email Reports As
Display views you can Print by
OLTP
Data warehouse characteristics
34. Enables you to lock column headers so that they always appear when scrolling
Advantage of a completely denormalized schema
To drill through User Hierarchies
Locking and Resizing
Page-by
35. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Project Creation Wizard
Project Source
Simple Attribute Expression
Objects you are allowed to Page-by
36. A development environment to create BI applications - allowing users to edit the Metadata database
Long-term (2 - 5 years)
Locking and Resizing
Desktop Architec
Project Source
37. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Project Creation Wizard
4 parts of the Project Design Process
Desktop Analyst
Minimal or none
38. 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
New SQL
Heterogeneous Attribute
Application Objects
39. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Report Filter
To drill through User Hierarchies
Objects you are allowed to Page-by
4 tasks of the Attribute Creation Wizard
40. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Display views you can Print by
Project Creation Wizard
Drilling
2 methods to creating Facts
41. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
2 components of a Physical Schema
Minimal or none
Attribute Forms
Level Prompts
42. Create the Project Source - Create the Database Instance
To create the Project connectivity
Report Filter operators
Page-by
Heterogeneous Attribute
43. What tool do you use to create the Metadata shell?
Homogeneous Attribute
Configuration Wizard
MSTR applications
Tasks when defining a User Hierarchy
44. A condition data must meet in order to be included in a report. Does affect the SQL.
ID form
Report Filter
OLAP
Compound Metric
45. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
4 parts of the Project Design Process
Process for creating the Project Metadata
Report Editor
46. Level of OLTP integration
User Hierarchies
Subtotals
Outline Mode
Minimal or none
47. The default entry-points.
Report Prompts
Architect Graphical Interface
Page-by
Highest-level attributes
48. One that uses 2 or more columns as its ID
Compound Attribute
Homogeneous Fact
Unlimited
Lookup Table structure of a completely normalized schema
49. The actual column name for a fact. Every fact must have at least 1 expression.
Report Editor
View Filters
Fact Expression
3 Sections of the MSTR Desktop interface
50. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Highest-level attributes
Relationship Tables
Outline Mode
Report Filter