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. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
4 properties you must know in order to create attributes using the Attribute Editor
ETL process
5 Report display views

2. Enables you to rearrange the columns and rows in a report.
3 components of a Report
The System
Characteristics of a Compound Table Key
Data Pivoting

3. One that uses 2 or more columns as its ID
Physical Schema
Desktop Administrative Functions
Schema Objects
Compound Attribute

4. Folder List - Object Viewer - Shortcut Bar
Desktop Designer
3 Sections of the MSTR Desktop interface
MSTR Connectivity Wizard
2 components of a Physical Schema

5. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Tasks when defining a User Hierarchy
File types are allowed for exporting a Report
Display views you can Print by
Attribute Elements

6. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Using a Search Object
Heterogeneous Attribute
Sorting

7. OLTP retains data ________
Report Objects
Short-term (2 - 6 months)
Value Prompts
'View of a Report'

8. Extraction - transformation - loading
ETL
2 types of Attribute Relationships
Report Objects
Cannot create project objects

9. Simple - Derived
2 types of Attribute Expression
Objects you are allowed to Page-by
Compound Attribute
File types are allowed for exporting a Report

10. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Methods are there to creating Attributes
To save a Report Format
Facts
2 types of Table Keys

11. Used to modify a Report
Reports
Report Editor
Architect Graphical Interface
Schema

12. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
OLAP
Schema Objects
Unlimited

13. AND - OR - OR NOT - AND NOT
Report Filter operators
Different methods for creating Page-by fields
View Filters
Attribute Elements

14. It contains the ID and DESC columns of all higher-level attributes
4 types of Prompts
Lookup Table structure of a completely denormalized schema
Report Editor
Heterogeneous Fact

15. Attribute Creation Wizard - Attribute Editor
Thresholding
ETL
Methods are there to creating Attributes
Search-based prompts

16. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Desktop Architec
2-Tier Architecture
Schema Object Editor

17. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Gigabytes (GB)
User Hierarchies
Level Prompts
Advantage of a completely denormalized schema

18. User requirements - Existing source data - Technical and performance considerations
Sorting
Homogeneous Attribute
To drill through User Hierarchies
Factors to consider when designing a logical data model

19. Subtotals reflect accumulations at selected attribute levels
Default Project folder structure
Report Objects
Subtotals
Derived Metrics

20. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
To create the Project connectivity
2 options for Sorting
Components of the Logical Data Model
Locking and Resizing

21. Less storage - Simple SQL - Complex ETL
Hierarchies
Simple Attribute Expression
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Simple Table Key

22. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Logical Data Model
4 tasks of the Attribute Creation Wizard
Report Template
Outline Mode

23. A feature that enables users to delivers reports to the history list - cache or mobile
3 Methods of MSTR Desktop navigation
4 tasks of the Attribute Creation Wizard
MSTR Desktop
Report Subscription

24. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
Simple Attribute Expression
2 types of Facts
Desktop Administrative Functions

25. Create the Project Source - Create the Database Instance
Report Objects
To create the Project connectivity
Facts
Attribute Forms

26. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
To "drill down" on a report
Facts
Compound Attribute
2 methods to creating Facts

27. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Lookup Table structure of a completely denormalized schema
Locking and Resizing
Gigabytes (GB)

28. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
File types are allowed for exporting a Report
Report Filter
To drill through User Hierarchies
Desktop Administrative Functions

29. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
To drill through User Hierarchies
'View of a Report'
View Filter
Report Filter

30. OLAP Services does not add any ______ to the report query.
New SQL
MSTR OLAP Services
Source system characteristics
MSTR Connectivity Wizard

31. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
To "drill down" on a report
Configuration Wizard
4 tasks of the Attribute Creation Wizard
Page-by

32. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Subtotals
Factors to consider when designing a logical data model
Architect Graphical Interface
Types of analysis you can perform with OLAP Services

33. Used for - Initially populating the Metadata - Creating schema objects
Aggregate a Metric
Shortcut Bar
MSTR Desktop Architect
Source system characteristics

34. Grid View - Graph View - Grid/Graph View - SQL View
Methods are there to creating Attributes
View Filters
2 ways you can configure the Project Source to connect to the Metadata database
Display views you can Print by

35. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
Shortcut in MSTR Desktop
Characteristics of a Simple Table Key
Short-term (2 - 6 months)

36. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Project-level options/settings
2 ways you can configure the Project Source to connect to the Metadata database
Components of the Logical Data Model

37. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
3-Tier Architecture
Attribute Creation Wizard good for
Process for creating the Project Metadata

38. How users can share comments for reports to other users
Simple Metrics
Objects you are allowed to Page-by
Components of the Logical Data Model
Notes

39. Specifies a condition data must meet in order to be included in a report
MSTR Desktop Architect
Report Filter
Outline Mode
OLAP

40. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Report Template
View Filter
Project Source
Facts

41. The unique values of an attribute obtained from the data-warehouse
Banding
3 components of a Report
Components of a Derived Metric
Attribute Elements

42. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Physical Schema
Reports
Fact Expression
Data warehouse characteristics

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

44. You can e-mail reports by going to _____
File > Email Reports As
2 ways you can configure the Project Source to connect to the Metadata database
5 Report display views
Default Project folder structure

45. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Report Template
Table Keys
4 basic Schema objects

46. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Limitations of the Attribute Creation Wizard
Required on the report for Outline Model to work
Cannot create project objects
Logical Data Model

47. All report-level options overwrite ___________.
Project-level options/settings
Search-based prompts
Lookup Table structure of a moderately denormalized schema
ID form

48. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Reference Report Objects
Compound Metric
Terabytes (TB)

49. Used to "fine-tune" your Project
View Filters
Architect Graphical Interface
2 methods to creating Facts
Attribute Creation Wizard good for

50. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Unlimited
Logical Data Model
2 types of Attribute Relationships
Long-term (2 - 5 years)