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. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
4 basic Schema objects
3-Tier Architecture
Nested Metrics
The 3 MSTR Tools

2. Filter definition prompts - Object prompts - Value prompts - Level prompts
Characteristics of a Simple Table Key
Derived Attribute Expression
4 types of Prompts
Homogeneous Attribute

3. OLTP data storage measure
MSTR Connectivity Wizard
Facts
Search-based prompts
Gigabytes (GB)

4. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
Schema Object Editor
4 parts of the Project Design Process
Shortcut Bar

5. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
2 methods to creating Facts
Desktop Designer
3 column types of a Physical Schema

6. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
5 steps to creating a logical data model
3 functions of Attribute Forms
Outline Mode

7. Attribute Creation Wizard - Attribute Editor
Desktop Architec
2-Tier Architecture
Methods are there to creating Attributes
Cannot create project objects

8. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
View Filter
Characteristics of a Simple Table Key
Drilling

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

10. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Subtotals
Level Prompts
Fact Tables
MSTR Desktop Architect

11. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Homogeneous Fact
Components of a Derived Metric
Characteristics of Nested Metrics
5 steps to creating a logical data model

12. 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
Types of drilling
Very high; part of ETL process
Compound Attribute
3 components of a Report

13. The unique values of an attribute obtained from the data-warehouse
Cannot create project objects
Characteristics of Nested Metrics
Reports
Attribute Elements

14. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
5 Report display views
View Filter
Project
Objects you are allowed to Page-by

15. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Data Pivoting
Characteristics of a Compound Table Key
4 tasks of the Attribute Creation Wizard

16. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Heterogeneous Fact
Default Project folder structure
Schema Objects
Lookup Table structure of a moderately denormalized schema

17. All report-level options overwrite ___________.
Project-level options/settings
5 steps to creating a logical data model
Table Keys
To create a Report Prompt

18. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
4 parts of the Project Design Process
Heterogeneous Attribute
Highest-level attributes
The System

19. Level of OLAP integration
Very high; part of ETL process
To "drill down" on a report
Report Filter
Short-term (2 - 6 months)

20. Metrics aggregate on the lowest-level attribute __________.
By default
File > Email Reports As
Compound Attribute
Data Pivoting

21. Enables you to rearrange the columns and rows in a report.
2 types of Attribute Expression
Data Pivoting
To qualify a Metric in a Set Qualification
Lookup Table structure of a completely normalized schema

22. Facts associated to different column names in 2 or more tables
Default Project folder structure
Heterogeneous Fact
Warehouse Catalog
Characteristics of a Compound Table Key

23. What tool do you use to create the Metadata shell?
Configuration Wizard
New SQL
Factors to consider when designing a logical data model
Objects you are allowed to Page-by

24. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
File > Email Reports As
Types of analysis you can perform with OLAP Services
MSTR Desktop
Table Keys

25. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
To "drill down" on a report
MSTR OLAP Services
Reference Report Objects
By default

26. The Attribute Form maps to different column names in multiple tables
Lookup Table structure of a completely denormalized schema
Heterogeneous Attribute
Lookup Table structure of a completely normalized schema
MSTR Desktop Architect

27. Columns - Tables
Project Creation Wizard
Report Filter operators
2 components of a Physical Schema
Data warehouse characteristics

28. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
OLAP
Very high; part of ETL process
Desktop Designer
Derived Attribute Expression

29. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Page-by
Level Prompts
Required on the report for Outline Model to work

30. All Attributes must have an _______.
Attribute or its relationship(s)
ID form
Table Keys
Report Subscription

31. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
3 project creation interfaces
5 Report display views
Compound Metric
Configuration Wizard

32. Formula - Level (Dimensionality) - Conditionality - Transformation
3 Methods of MSTR Desktop navigation
Desktop Architec
Components of a Metric
Report Filter operators

33. You can e-mail reports by going to _____
3 Types of Objects in MSTR Desktop
Report Formatting
Warehouse Catalog
File > Email Reports As

34. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Attributes
Project Source
Report Objects
Different methods for creating Page-by fields

35. 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
MSTR Connectivity Wizard
Default Project folder structure
MSTR Desktop
Outline Mode

36. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Search-based prompts
Locking and Resizing
2 types of Attribute Relationships

37. Metrics you create within a report using only those objects in the report.
ID form
To qualify a Metric in a Set Qualification
Derived Metrics
MSTR OLAP Services

38. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
Attribute Forms
To create the Project connectivity
Drilling

39. Facts associated to the same column name in 1 or more tables
MSTR Desktop Architect
Filter Definition Prompts
Facts
Homogeneous Fact

40. View Filters are saved with the _____________.
Homogeneous Fact
Shortcut Bar
Report Definitions
The System

41. The Attribute Form Expression that maps to a single column - no matter the number of tables
Cannot create project objects
Simple Attribute Expression
4 basic Schema objects
To drill through User Hierarchies

42. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Attribute Relationships
2 types of Facts
Minimal or none

43. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Report Template
Desktop Analyst
4 tasks of the Attribute Creation Wizard
Outline Mode

44. 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
5 steps to creating a logical data model
4 types of Report Filters
2 components of a Physical Schema
Rollback your changes

45. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Logical Data Model
Report Filter
New SQL
Cannot create project objects

46. Template - Filter - View of a Report
File types are allowed for exporting a Report
3 components of a Report
MSTR applications
4 types of Report Filters

47. Primary keys
Characteristics of Nested Metrics
Table Keys
2 types of Facts
2 types of Attribute Expression

48. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
ID form
To "drill down" on a report
To qualify a Metric in a Set Qualification
Characteristics of Nested Metrics

49. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
4 factors to consider when designing a data-warehouse schema
2 types of Table Keys
Source system characteristics
Physical Schema

50. Create the Project Source - Create the Database Instance
To create the Project connectivity
Rollback your changes
New SQL
Components of a Derived Metric