Test your basic knowledge |

Certified Project Designer Cpd

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. The unique values of an attribute obtained from the data-warehouse
3 project creation interfaces
Attribute Elements
Project Creation Wizard
Page-by

2. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Project
Report Prompts
Using a Search Object
4 types of Prompts

3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Gigabytes (GB)
Search Object
4 factors to consider when designing a data-warehouse schema
Reference Report Objects

4. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Report Prompts
Reports
Filter Definition Prompts
Report Objects

5. The logical associations between attributes that exist based on a business rule
Required on the report for Outline Model to work
Attribute Relationships
Schema Objects
2 components of a Physical Schema

6. Level of OLTP integration
Report Objects
The System
Stored
Minimal or none

7. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
3 project creation interfaces
Tasks when defining a User Hierarchy
Attribute Forms

8. OLTP retains data ________
Aggregate a Metric
Short-term (2 - 6 months)
Rollback your changes
Attribute Relationships

9. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Report Subscription
Desktop Administrative Functions
4 properties you must know in order to create attributes using the Attribute Editor

10. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
MSTR OLAP Services
Homogeneous Attribute
Sample Metrics commonly performed on Facts

11. One that uses 2 or more columns as its ID
Project
'View of a Report'
Compound Attribute
The 3 MSTR Tools

12. Primary keys
View Filter
Table Keys
3-Tier Architecture
2 components of a Physical Schema

13. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute Forms
Lookup Table structure of a completely normalized schema
Attribute or its relationship(s)
Compound Metric

14. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Short-term (2 - 6 months)
4 tasks of the Attribute Creation Wizard
ETL
Heterogeneous Attribute

15. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Terabytes (TB)
Aggregate a Metric
Report Formatting

16. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Advantage of a completely denormalized schema
Report Prompts
Report Formatting

17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
To save a Report Format
To create the Project connectivity
Rollback your changes

18. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Characteristics of a Simple Table Key
Schema Object Editor
Fact Tables

19. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
ETL process
Search-based prompts
2 options for Sorting
Source system characteristics

20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
2 types of Attribute Relationships
5 Report display views
Report Objects
Components of a MSTR architecture

21. Enables you to lock column headers so that they always appear when scrolling
Short-term (2 - 6 months)
Attributes
Locking and Resizing
The System

22. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Architect Graphical Interface
Attribute or its relationship(s)
Physical Schema
Report Formatting

23. The Attribute Form Expression that maps to a single column - no matter the number of tables
'View of a Report'
OLAP
Simple Attribute Expression
2 types of Attribute Expression

24. 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.
Lookup Table structure of a completely denormalized schema
Report Template
Report Prompts
Desktop Analyst

25. Specifies a condition data must meet in order to be included in a report
Components of Compound Metrics
Report Filter
Notes
'View of a Report'

26. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Data Pivoting
Locking and Resizing
Object Prompts
2 types of Attribute Relationships

27. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Components of a Metric
Long-term (2 - 5 years)
Report Objects
Process for creating the Project Metadata

28. Template - Filter - View of a Report
2 types of Table Keys
Project Creation Wizard
Required on the report for Outline Model to work
3 components of a Report

29. All report-level options overwrite ___________.
Project-level options/settings
Attribute Forms
Cannot create project objects
Types of analysis you can perform with OLAP Services

30. Facts associated to the same column name in 1 or more tables
Types of analysis you can perform with OLAP Services
Homogeneous Fact
Reports
View Filters

31. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Gigabytes (GB)
Project Creation Wizard
Aggregate a Metric
Filter Definition Prompts

32. Enables you to select and display subsets of a report as separate pages.
To create a Report Prompt
Page-by
Tasks when defining a User Hierarchy
Cannot create project objects

33. Grid View - Graph View - Grid/Graph View - SQL View
Homogeneous Fact
2 ways you can configure the Project Source to connect to the Metadata database
Display views you can Print by
Level Prompts

34. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
2 methods to creating Facts
Compound Attribute
Attribute Relationships

35. OLTP data storage measure
To qualify a Metric in a Set Qualification
Gigabytes (GB)
Value Prompts
3 project creation interfaces

36. Specifies what info to retrieve from a data-warehouse - and how to display it
Application Objects
Report Template
To create a Report Prompt
2 methods to creating Facts

37. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Report Editor
Default Project folder structure
Lookup Table structure of a completely denormalized schema

38. Must have Subtotals enabled - or you won't see any data for higher-level attributes
MSTR Desktop
Required on the report for Outline Model to work
To "drill down" on a report
Different methods for creating Page-by fields

39. Using the Prompt Generation Wizard - Inside the Report Editor
Search Object
Minimal or none
3 column types of a Physical Schema
To create a Report Prompt

40. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
2 types of Attribute Expression
Data warehouse characteristics
3 column types of a Physical Schema
Level Prompts

41. User requirements - Existing source data - Technical and performance considerations
Short-term (2 - 6 months)
Schema
Factors to consider when designing a logical data model
4 types of Metrics

42. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Shortcut Bar
4 parts of the Project Design Process
Project-level options/settings

43. OLAP retains data ________
Configuration Wizard
Report Subscription
Long-term (2 - 5 years)
Desktop Designer

44. You must select "Other directions" when drilling attributes while viewing a report
3 Schema types
2 methods to creating Facts
To create the Project connectivity
To drill through User Hierarchies

45. You can e-mail reports by going to _____
3 Sections of the MSTR Desktop interface
Aggregate a Metric
File > Email Reports As
To "drill down" on a report

46. 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
4 types of Report Filters
User Hierarchies
2 components of a Physical Schema
Default Project folder structure

47. The Attribute Form maps to different column names in multiple tables
Sample Metrics commonly performed on Facts
Desktop Designer
Heterogeneous Attribute
Highest-level attributes

48. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Reports
Sample Metrics commonly performed on Facts
3-Tier Architecture
Cannot create project objects

49. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Factors to consider when designing a logical data model
2 types of Attribute Relationships
3 Sections of the MSTR Desktop interface

50. OLAP Services does not add any ______ to the report query.
OLAP
Facts
New SQL
Physical Schema