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. Top menu/dropdowns - Toolbar - Right-click popup menus
Hierarchies
2 types of Facts
3 Methods of MSTR Desktop navigation
New SQL

2. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
3 Methods of MSTR Desktop navigation
Logical Data Model
The 3 MSTR Tools
Long-term (2 - 5 years)

3. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Rollback your changes
Derived Metrics
Aggregate a Metric
Types of drilling

4. Metrics you create within a report using only those objects in the report.
Derived Metrics
Gigabytes (GB)
Outline Mode
Schema Object Editor

5. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
4 tasks of the Attribute Creation Wizard
ETL
2 types of Fact Expressions
Using a Search Object

6. It contains the ID and DESC columns of all higher-level attributes
Report Objects
Lookup Table structure of a completely denormalized schema
Default Project folder structure
Report Filter operators

7. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Report Editor
Fact Tables
Lookup Table structure of a completely denormalized schema
By default

8. View Filters are saved with the _____________.
2-Tier Architecture
2 types of Facts
Homogeneous Attribute
Report Definitions

9. Specifies a condition data must meet in order to be included in a report
3 Types of Objects in MSTR Desktop
4 properties you must know in order to create attributes using the Attribute Editor
Report Filter
4 basic Schema objects

10. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Fact Expression
Data warehouse characteristics
5 steps to creating a logical data model
4 types of Metrics

11. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
To save a Report Format
Report Prompts
Outline Mode
Value Prompts

12. A condition data must meet in order to be included in a report. Does affect the SQL.
Short-term (2 - 6 months)
4 properties you must know in order to create attributes using the Attribute Editor
Report Filter
Data Pivoting

13. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Shortcut in MSTR Desktop
MSTR applications
2 types of Attribute Relationships

14. Columns - Tables
Report Filter
Components of Compound Metrics
2 components of a Physical Schema
Limitations of the Attribute Creation Wizard

15. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
MSTR OLAP Services
Methods are there to creating Attributes
Attribute Forms
To save a Report Format

16. Enables you to select and display subsets of a report as separate pages.
Components of Compound Metrics
3 types of Attributes
Page-by
Schema Object Editor

17. Subtotals reflect accumulations at selected attribute levels
Simple Attribute Expression
3-Tier Architecture
Very high; part of ETL process
Subtotals

18. Simple - Derived
4 types of Prompts
'View of a Report'
Banding
2 types of Attribute Expression

19. Groupings of directly related attributes. Also commonly known as "dimensions".
Data Pivoting
Hierarchies
Report Editor
Types of drilling

20. User reporting requirements - Query performance - Data volume - DB Maintenance
To drill through User Hierarchies
Project-level options/settings
To qualify a Metric in a Set Qualification
4 factors to consider when designing a data-warehouse schema

21. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Architect Graphical Interface
To edit the appearance of a Graph in a report
File types are allowed for exporting a Report
MSTR OLAP Services

22. What tool do you use to create the Metadata DSN connection?
MSTR Connectivity Wizard
Characteristics of Nested Metrics
Attribute Relationships
Report Filter

23. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Components of a Metric
Different methods for creating Page-by fields
Tasks when defining a User Hierarchy
Filter Definition Prompts

24. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Schema Objects
4 factors to consider when designing a data-warehouse schema
Search-based prompts

25. Facts associated to the same column name in 1 or more tables
Schema
2 options for Sorting
Homogeneous Fact
The System

26. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Derived Attribute Expression
3 Methods of MSTR Desktop navigation
User Hierarchies

27. The unique values of an attribute obtained from the data-warehouse
To create a Report Prompt
Characteristics of Nested Metrics
Attribute Elements
Shortcut Bar

28. 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.
Short-term (2 - 6 months)
View Filters
Desktop Designer
Objects you are allowed to Page-by

29. Filter definition prompts - Object prompts - Value prompts - Level prompts
Application Objects
4 types of Prompts
Attribute Creation Wizard good for
Nested Metrics

30. To see data at completely different levels - other than that of the original Grid or Graph
2 types of Facts
The System
Drilling
ETL

31. OLAP Services does not add any ______ to the report query.
New SQL
Tasks when defining a User Hierarchy
Attribute Relationships
Search Object

32. Descriptive data that provides context for Facts.
Attribute Forms
Project Creation Wizard
Homogeneous Fact
Outline Mode

33. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Attribute Relationships
Schema Objects
2 options for Sorting
5 Report display views

34. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Unlimited
The System
Reports
To qualify a Metric in a Set Qualification

35. The logical associations between attributes that exist based on a business rule
Compound Attribute
Fact Tables
Report Definitions
Attribute Relationships

36. Tables - Facts - Attributes - Hierarchies
Characteristics of a Compound Table Key
The 3 MSTR Tools
4 basic Schema objects
Banding

37. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Search-based prompts
2 types of Table Keys
Long-term (2 - 5 years)
OLAP

38. Compound - Homogeneous - Heterogeneous
3 types of Attributes
3-Tier Architecture
3 functions of Attribute Forms
Simple Attribute Expression

39. Facts associated to different column names in 2 or more tables
Drilling
Heterogeneous Fact
Desktop Architec
Facts

40. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Report Editor
Characteristics of a Compound Table Key
Reports
Cannot create project objects

41. 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
Desktop Architec
To qualify a Metric in a Set Qualification
Highest-level attributes
Project

42. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Shortcut Bar
Object Prompts
Warehouse Catalog
Minimal or none

43. One that uses 2 or more columns as its ID
Compound Attribute
Sample Metrics commonly performed on Facts
Data Pivoting
Attribute Relationships

44. Facts - Attributes - Hierarchies
Derived Attribute Expression
2 types of Fact Expressions
Components of the Logical Data Model
Components of a Derived Metric

45. Level of OLTP integration
Attribute Creation Wizard good for
Sample Metrics commonly performed on Facts
Minimal or none
Table Keys

46. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Heterogeneous Attribute
Attribute Forms
Report Editor

47. Metrics aggregate on the lowest-level attribute __________.
Simple Metrics
Display views you can Print by
By default
Facts

48. Enables you to lock column headers so that they always appear when scrolling
Search-based prompts
4 parts of the Project Design Process
Locking and Resizing
Shortcut Bar

49. OLTP retains data ________
Short-term (2 - 6 months)
Application Objects
Required on the report for Outline Model to work
ETL process

50. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Metrics
To create a Report Prompt
3 components of a Report
Process for creating the Project Metadata