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. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Report Formatting
Data warehouse characteristics
Outline Mode
The 3 MSTR Tools

2. View Filters are saved with the _____________.
Tasks when defining a User Hierarchy
Desktop Designer
Report Definitions
4 factors to consider when designing a data-warehouse schema

3. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Application Objects
Value Prompts
Logical Data Model

4. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
OLTP
Limitations of the Attribute Creation Wizard
Fact Tables

5. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Report Subscription
Factors to consider when designing a logical data model
Report Filter
Relationship Tables

6. 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

7. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Factors to consider when designing a logical data model
To create the Project connectivity
ID form

8. You can e-mail reports by going to _____
Schema Objects
ID form
To save a Report Format
File > Email Reports As

9. It contains links to specific folders in the Folder List
Shortcut Bar
4 types of Report Filters
Desktop Architec
Fact Expression

10. Used for - Initially populating the Metadata - Creating schema objects
MSTR Connectivity Wizard
3 Methods of MSTR Desktop navigation
MSTR Desktop Architect
Sample Metrics commonly performed on Facts

11. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Desktop Administrative Functions
2 options for Sorting
Cannot create project objects
Report Filter operators

12. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
4 basic Schema objects
Compound Metric
Notes
5 Report display views

13. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Filter Definition Prompts
Project Creation Wizard
Metrics

14. Using the Prompt Generation Wizard - Inside the Report Editor
3 Methods of MSTR Desktop navigation
Project
ID form
To create a Report Prompt

15. How users can share comments for reports to other users
Methods are there to creating Attributes
MSTR applications
Warehouse Catalog
Notes

16. User reporting requirements - Query performance - Data volume - DB Maintenance
4 types of Report Filters
4 factors to consider when designing a data-warehouse schema
Components of a MSTR architecture
Components of a Derived Metric

17. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Reports
4 parts of the Project Design Process
4 factors to consider when designing a data-warehouse schema

18. The actual column name for a fact. Every fact must have at least 1 expression.
Simple Attribute Expression
Fact Expression
2 types of Facts
Short-term (2 - 6 months)

19. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Lookup Table structure of a completely denormalized schema
Source system characteristics
Sorting
Components of Compound Metrics

20. A shortcut to an existing Object in a Project
To create the Project connectivity
Shortcut in MSTR Desktop
Attribute Creation Wizard good for
Tasks when defining a User Hierarchy

21. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Components of a Metric
Unlimited
Simple Metrics
To edit the appearance of a Graph in a report

22. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
4 tasks of the Attribute Creation Wizard
Desktop Architec
2 types of Table Keys
Report Formatting

23. OLAP retains data ________
Long-term (2 - 5 years)
ETL process
Search Object
Components of the Logical Data Model

24. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Project Creation Wizard
Advantage of a completely denormalized schema
Stored
Sorting

25. OLAP Services does not add any ______ to the report query.
2 types of Table Keys
2 types of Facts
Report Filter
New SQL

26. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Thresholding
Relationship Tables
ETL

27. A development environment to create BI applications - allowing users to edit the Metadata database
2 types of Fact Expressions
Desktop Architec
Different methods for creating Page-by fields
Objects you are allowed to Page-by

28. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Attribute Forms
Report Template
Search Object
Objects you are allowed to Page-by

29. You can _____________ in the Architect Graphical Interface.
Physical Schema
2 methods to creating Facts
Rollback your changes
Types of analysis you can perform with OLAP Services

30. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
MSTR Connectivity Wizard
Architect Graphical Interface
Compound Attribute

31. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Short-term (2 - 6 months)
To "drill down" on a report
Report Definitions
Application Objects

32. Enables you to select which tables from the data-warehouse to store in the Metadata database
To create a Report Prompt
Warehouse Catalog
Value Prompts
Methods are there to creating Attributes

33. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
Process for creating the Project Metadata
4 tasks of the Attribute Creation Wizard
Architect Graphical Interface

34. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Characteristics of a Simple Table Key
Attribute or its relationship(s)
Fact Tables
Relationship Tables

35. Folder List - Object Viewer - Shortcut Bar
Thresholding
To create the Project connectivity
4 types of Report Filters
3 Sections of the MSTR Desktop interface

36. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Gigabytes (GB)
ID form
3 components of a Report
Lookup Tables

37. An environment in which the MSTR Desktop connects directly to the Metadata database.
Project Creation Wizard
2 types of Attribute Expression
Architect Graphical Interface
2-Tier Architecture

38. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Application Objects
Project Creation Wizard
Attribute or its relationship(s)
3-Tier Architecture

39. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Highest-level attributes
View Filter
Report Filter operators

40. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
4 factors to consider when designing a data-warehouse schema
Lookup Tables
The 3 MSTR Tools
Search Object

41. All report-level options overwrite ___________.
Project-level options/settings
Components of Compound Metrics
Gigabytes (GB)
MSTR Desktop

42. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Default Project folder structure
Desktop Administrative Functions
Using a Search Object
Types of drilling

43. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Column Aliases
Derived Attribute Expression
View Filter
Project-level options/settings

44. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Types of drilling
Physical Schema
New SQL
Report Filter operators

45. User requirements - Existing source data - Technical and performance considerations
Using a Search Object
Shortcut in MSTR Desktop
3 Types of Objects in MSTR Desktop
Factors to consider when designing a logical data model

46. AND - OR - OR NOT - AND NOT
File > Email Reports As
Report Formatting
Report Filter operators
4 factors to consider when designing a data-warehouse schema

47. View Filters can only ___________.
Methods are there to creating Attributes
Reference Report Objects
MSTR applications
3 Methods of MSTR Desktop navigation

48. OLTP retains data ________
Objects you are allowed to Page-by
Logical Data Model
Short-term (2 - 6 months)
To edit the appearance of a Graph in a report

49. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Outline Mode
Heterogeneous Attribute
To save a Report Format
Object Prompts

50. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3 Schema types
Short-term (2 - 6 months)
ETL process
Hierarchies