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. A feature that enables users to delivers reports to the history list - cache or mobile
4 types of Metrics
Report Subscription
Attribute Relationships
Default Project folder structure

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
Facts
Report Filter operators
By default
3 functions of Attribute Forms

3. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Source system characteristics
Report Filter
Attribute Relationships
2 options for Sorting

4. 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
Lookup Table structure of a moderately denormalized schema
Compound Metric
Hierarchies

5. Compound - Homogeneous - Heterogeneous
Unlimited
3 types of Attributes
Methods are there to creating Attributes
Long-term (2 - 5 years)

6. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Facts
4 types of Report Filters
The 3 MSTR Tools
Limitations of the Attribute Creation Wizard

7. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Fact Tables
MSTR Desktop Architect
3 functions of Attribute Forms

8. A new tool for project design tasks - used for fine-tuning a project after initial creation
Search-based prompts
Architect Graphical Interface
Report Definitions
Report Prompts

9. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Report Editor
Unlimited
Homogeneous Attribute

10. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
ID form
Using a Search Object
3 types of Attributes
Unlimited

11. Must have a one-to-one relationship with all other forms.
User Hierarchies
Attribute Forms
Rollback your changes
Simple Metrics

12. An environment in which the MSTR Desktop connects directly to the Metadata database.
2 options for Sorting
2-Tier Architecture
ETL process
4 tasks of the Attribute Creation Wizard

13. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
File > Email Reports As
User Hierarchies
Search Object
'View of a Report'

14. Must have Subtotals enabled - or you won't see any data for higher-level attributes
4 parts of the Project Design Process
2 options for Sorting
2 components of a Physical Schema
Required on the report for Outline Model to work

15. How users can share comments for reports to other users
Report Definitions
Notes
File types are allowed for exporting a Report
Aggregate a Metric

16. Extraction - transformation - loading
ETL
'View of a Report'
Filter Definition Prompts
Schema Object Editor

17. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
2 types of Facts
5 Report display views
Object Prompts
To create a Report Prompt

18. It contains links to specific folders in the Folder List
Report Prompts
Shortcut Bar
Simple Metrics
Architect Graphical Interface

19. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Desktop Architec
5 Report display views
Cannot create project objects
Advantage of a completely denormalized schema

20. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Heterogeneous Attribute
OLAP
Value Prompts

21. Folder List - Object Viewer - Shortcut Bar
Very high; part of ETL process
Fact Expression
3 Sections of the MSTR Desktop interface
Report Formatting

22. Specifies a condition data must meet in order to be included in a report
Report Filter
Components of a Metric
4 factors to consider when designing a data-warehouse schema
Search Object

23. 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
Data warehouse characteristics
Report Template
Report Objects
Default Project folder structure

24. View Filters are saved with the _____________.
Shortcut Bar
Report Definitions
4 tasks of the Attribute Creation Wizard
Data warehouse characteristics

25. OLTP retains data ________
Short-term (2 - 6 months)
'View of a Report'
Attribute Elements
Stored

26. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Report Filter operators
Compound Attribute
2-Tier Architecture
3-Tier Architecture

27. Metrics you create within a report using only those objects in the report.
Cannot create project objects
Schema Object Editor
3 project creation interfaces
Derived Metrics

28. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
MSTR Desktop Architect
View Filters
Sorting
Types of drilling

29. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
File types are allowed for exporting a Report
3 column types of a Physical Schema
Filter Definition Prompts

30. View Filters can only ___________.
3 column types of a Physical Schema
Desktop Architec
Reference Report Objects
Attribute Elements

31. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Level Prompts
Homogeneous Fact
2 options for Sorting

32. Filter definition prompts - Object prompts - Value prompts - Level prompts
Short-term (2 - 6 months)
4 types of Prompts
Tasks when defining a User Hierarchy
Simple Metrics

33. Primary keys
4 factors to consider when designing a data-warehouse schema
Sample Metrics commonly performed on Facts
Table Keys
Filter Definition Prompts

34. More storage - Complex SQL - Simple ETL
3 components of a Report
Characteristics of a Compound Table Key
Attribute Creation Wizard good for
Object Prompts

35. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Components of a MSTR architecture
Project Source
Highest-level attributes
4 tasks of the Attribute Creation Wizard

36. Tables - Facts - Attributes - Hierarchies
Factors to consider when designing a logical data model
To create a Report Prompt
Schema
4 basic Schema objects

37. The unique values of an attribute obtained from the data-warehouse
Simple Attribute Expression
Attribute Elements
User Hierarchies
Compound Metric

38. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
Attribute or its relationship(s)
To save a Report Format
2 types of Fact Expressions

39. Enables you to lock column headers so that they always appear when scrolling
Banding
Locking and Resizing
3-Tier Architecture
To drill through User Hierarchies

40. Used for - Initially populating the Metadata - Creating schema objects
Report Formatting
MSTR Desktop Architect
Warehouse Catalog
Application Objects

41. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Using a Search Object
Cannot create project objects
Warehouse Catalog
Project Creation Wizard

42. All report-level options overwrite ___________.
Shortcut in MSTR Desktop
OLAP
Project-level options/settings
Attribute Elements

43. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Lookup Tables
Rollback your changes
Lookup Table structure of a completely denormalized schema

44. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Long-term (2 - 5 years)
Configuration Wizard
Desktop Administrative Functions
4 parts of the Project Design Process

45. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Desktop Designer
Simple Attribute Expression
Level Prompts
3 functions of Attribute Forms

46. Level of OLAP integration
Application Objects
To create the Project connectivity
Sample Metrics commonly performed on Facts
Very high; part of ETL process

47. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Tasks when defining a User Hierarchy
MSTR applications
ETL process

48. 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.
2 options for Sorting
View Filters
2 methods to creating Facts
3 Schema types

49. Level of OLTP integration
To drill through User Hierarchies
Minimal or none
MSTR applications
Unlimited

50. You must select "Other directions" when drilling attributes while viewing a report
Object Prompts
Compound Attribute
Facts
To drill through User Hierarchies