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 condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
3 column types of a Physical Schema
Facts
Advantage of a completely denormalized schema
View Filter

2. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Report Formatting
2 options for Sorting
Desktop Analyst
Lookup Table structure of a moderately denormalized schema

3. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
3 Schema types
View Filters
Very high; part of ETL process
Physical Schema

4. Extraction - transformation - loading
4 types of Report Filters
Report Filter
Report Template
ETL

5. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Short-term (2 - 6 months)
2 types of Attribute Expression
MSTR Desktop Architect
MSTR applications

6. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
MSTR Desktop
Reports
Attribute or its relationship(s)

7. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Facts
Aggregate a Metric
Reference Report Objects

8. The Attribute Form maps to different column names in multiple tables
5 steps to creating a logical data model
3 project creation interfaces
Heterogeneous Attribute
Long-term (2 - 5 years)

9. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Value Prompts
Simple Attribute Expression
Attribute or its relationship(s)
Components of the Logical Data Model

10. To define the level of aggregation for a specific metric - Used for qualifications
The System
Attributes
Attribute Elements
Attribute Creation Wizard good for

11. Columns - Tables
Hierarchies
2 components of a Physical Schema
3 Sections of the MSTR Desktop interface
Objects you are allowed to Page-by

12. A new tool for project design tasks - used for fine-tuning a project after initial creation
Tasks when defining a User Hierarchy
Attribute Relationships
Characteristics of Nested Metrics
Architect Graphical Interface

13. Facts associated to the same column name in 1 or more tables
Project Source
Homogeneous Fact
Column Aliases
Architect Graphical Interface

14. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Desktop Designer
Sample Metrics commonly performed on Facts
2 options for Sorting
To edit the appearance of a Graph in a report

15. Descriptive data that provides context for Facts.
Characteristics of a Simple Table Key
Report Formatting
Attribute Forms
Attribute or its relationship(s)

16. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Data warehouse characteristics
Logical Data Model
3 column types of a Physical Schema

17. Must have a one-to-one relationship with all other forms.
Types of drilling
Report Objects
Attribute Forms
Reference Report Objects

18. 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
Default Project folder structure
3 functions of Attribute Forms
2 types of Attribute Relationships
5 Report display views

19. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Locking and Resizing
Report Template
Object Prompts

20. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
3 functions of Attribute Forms
Fact Expression
Metrics
Schema Objects

21. Filter definition prompts - Object prompts - Value prompts - Level prompts
2 methods to creating Facts
Report Definitions
ID form
4 types of Prompts

22. OLTP data storage measure
Thresholding
Advantage of a completely denormalized schema
Project
Gigabytes (GB)

23. Metrics that perform multiple aggregations; one calculation inside of another.
ETL
Nested Metrics
To create the Project connectivity
4 types of Metrics

24. 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
To save a Report Format
Report Subscription
Locking and Resizing

25. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Attribute Forms
4 types of Report Filters
Types of analysis you can perform with OLAP Services

26. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
The 3 MSTR Tools
Outline Mode
Sample Metrics commonly performed on Facts
Types of analysis you can perform with OLAP Services

27. You can e-mail reports by going to _____
File > Email Reports As
Object Prompts
Table Keys
3-Tier Architecture

28. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
2-Tier Architecture
Stored
MSTR Desktop
Architect Graphical Interface

29. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Attribute Forms
Attribute Creation Wizard good for
Types of drilling

30. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Application Objects
Attribute or its relationship(s)
The 3 MSTR Tools
Attributes

31. The actual column name for a fact. Every fact must have at least 1 expression.
Components of Compound Metrics
New SQL
Project Creation Wizard
Fact Expression

32. 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
Short-term (2 - 6 months)
Attribute Creation Wizard good for
To qualify a Metric in a Set Qualification
Application Objects

33. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Subtotals
Aggregate a Metric
4 factors to consider when designing a data-warehouse schema
Architect Graphical Interface

34. It contains the ID column of the parent attribute
Factors to consider when designing a logical data model
4 parts of the Project Design Process
File > Email Reports As
Lookup Table structure of a completely normalized schema

35. Top menu/dropdowns - Toolbar - Right-click popup menus
Project
Types of analysis you can perform with OLAP Services
2 types of Table Keys
3 Methods of MSTR Desktop navigation

36. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Different methods for creating Page-by fields
3 Schema types
4 basic Schema objects

37. How users can share comments for reports to other users
Notes
3 Types of Objects in MSTR Desktop
Outline Mode
Components of Compound Metrics

38. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
To "drill down" on a report
Long-term (2 - 5 years)
3 Schema types

39. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
3 Schema types
Components of a MSTR architecture
Types of drilling
Desktop Architec

40. ID columns - Description columns - Fact columns
Attribute Forms
3-Tier Architecture
3 column types of a Physical Schema
Attribute Creation Wizard good for

41. The default entry-points.
Fact Tables
Highest-level attributes
Report Filter operators
Compound Attribute

42. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Logical Data Model
Schema Objects
Column Aliases
5 Report display views

43. OLAP Services does not add any ______ to the report query.
Rollback your changes
Object Prompts
New SQL
Simple Metrics

44. All report-level options overwrite ___________.
3 components of a Report
2 methods to creating Facts
Project-level options/settings
Reports

45. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Rollback your changes
MSTR OLAP Services
3 Types of Objects in MSTR Desktop
To drill through User Hierarchies

46. Direct: 2-tier - Server: 3-tier
View Filters
Long-term (2 - 5 years)
Report Filter operators
2 ways you can configure the Project Source to connect to the Metadata database

47. To see data at completely different levels - other than that of the original Grid or Graph
Rollback your changes
Drilling
3 Types of Objects in MSTR Desktop
Shortcut Bar

48. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Derived Metrics
3 project creation interfaces
Shortcut in MSTR Desktop
Column Aliases

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

50. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Metrics
Project Source
Project Creation Wizard
3 Methods of MSTR Desktop navigation