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. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Required on the report for Outline Model to work
User Hierarchies
MSTR OLAP Services
Characteristics of a Simple Table Key

2. Must have Subtotals enabled - or you won't see any data for higher-level attributes
2 types of Attribute Expression
Required on the report for Outline Model to work
3-Tier Architecture
Report Definitions

3. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Prompts
Logical Data Model
Report Objects
Desktop Analyst

4. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Attribute Creation Wizard good for
Characteristics of a Compound Table Key
Schema
4 properties you must know in order to create attributes using the Attribute Editor

5. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Attribute Creation Wizard good for
Desktop Administrative Functions
Stored
2 types of Fact Expressions

6. Attribute Creation Wizard - Attribute Editor
To create the Project connectivity
Methods are there to creating Attributes
New SQL
Project

7. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
5 steps to creating a logical data model
Compound Metric
Factors to consider when designing a logical data model
Components of a MSTR architecture

8. Primary keys
Table Keys
Advantage of a completely denormalized schema
MSTR Desktop Architect
Compound Attribute

9. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Minimal or none
Attribute or its relationship(s)
Desktop Administrative Functions
Warehouse Catalog

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

11. Reduced number of JOINS in the generated SQL
3 Methods of MSTR Desktop navigation
2 types of Table Keys
MSTR Connectivity Wizard
Advantage of a completely denormalized schema

12. More storage - Complex SQL - Simple ETL
Homogeneous Fact
Characteristics of a Compound Table Key
Notes
Search-based prompts

13. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Different methods for creating Page-by fields
OLTP
Terabytes (TB)
Attribute Elements

14. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
MSTR OLAP Services
Terabytes (TB)
Attribute Elements
To save a Report Format

15. OLTP data storage measure
Lookup Table structure of a completely denormalized schema
Relationship Tables
4 basic Schema objects
Gigabytes (GB)

16. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Metrics
Components of Compound Metrics
Level Prompts
4 factors to consider when designing a data-warehouse schema

17. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Sorting
Relationship Tables
Nested Metrics
Level Prompts

18. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Simple Metrics
Schema Object Editor
Sample Metrics commonly performed on Facts
Physical Schema

19. Simple - Derived
4 types of Report Filters
3 Types of Objects in MSTR Desktop
2 types of Attribute Expression
Stored

20. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
User Hierarchies
Outline Mode
Desktop Administrative Functions
To edit the appearance of a Graph in a report

21. The Attribute Form maps to the same column name in multiple tables
Locking and Resizing
Homogeneous Attribute
To drill through User Hierarchies
Very high; part of ETL process

22. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
ID form
Report Editor
Cannot create project objects
2 options for Sorting

23. Formula - Level (Dimensionality) - Conditionality - Transformation
Components of a Metric
Aggregate a Metric
Homogeneous Attribute
Report Formatting

24. Homogeneous - Heterogeneous
Advantage of a completely denormalized schema
2 types of Facts
Cannot create project objects
Thresholding

25. OLAP retains data ________
Long-term (2 - 5 years)
Objects you are allowed to Page-by
Banding
Nested Metrics

26. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
4 factors to consider when designing a data-warehouse schema
User Hierarchies
Lookup Table structure of a moderately denormalized schema

27. Enables you to lock column headers so that they always appear when scrolling
Search-based prompts
Locking and Resizing
Display views you can Print by
Minimal or none

28. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Column Aliases
Required on the report for Outline Model to work
Facts
Architect Graphical Interface

29. Creating multiple attributes quickly. Used during the initial project creation.
Cannot create project objects
5 Report display views
4 types of Metrics
Attribute Creation Wizard good for

30. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Unlimited
File types are allowed for exporting a Report
3 Types of Objects in MSTR Desktop

31. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Shortcut Bar
OLTP
Data Pivoting
Facts

32. Schema Objects - Application Objects - Configuration Objects
3 column types of a Physical Schema
Components of a Derived Metric
Heterogeneous Fact
3 Types of Objects in MSTR Desktop

33. 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
Sample Metrics commonly performed on Facts
Nested Metrics
OLAP
Characteristics of Nested Metrics

34. Enables you to rearrange the columns and rows in a report.
Attribute Forms
Characteristics of a Compound Table Key
OLAP
Data Pivoting

35. Subtotals reflect accumulations at selected attribute levels
Subtotals
2 ways you can configure the Project Source to connect to the Metadata database
Project
2 types of Fact Expressions

36. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Reports
2 types of Table Keys
Report Editor

37. Extraction - transformation - loading
Fact Tables
To qualify a Metric in a Set Qualification
ETL
Derived Metrics

38. Facts - Attributes - Hierarchies
Homogeneous Attribute
Homogeneous Fact
Attribute Forms
Components of the Logical Data Model

39. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Subtotals
ETL process
3 functions of Attribute Forms
Advantage of a completely denormalized schema

40. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
Heterogeneous Attribute
Report Objects
Different methods for creating Page-by fields

41. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
3-Tier Architecture
Sample Metrics commonly performed on Facts
Objects you are allowed to Page-by
Locking and Resizing

42. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
'View of a Report'
Desktop Architec
MSTR applications
To edit the appearance of a Graph in a report

43. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Components of a Derived Metric
Thresholding
Warehouse Catalog

44. Descriptive data that provides context for Facts.
Attribute Forms
Attribute Elements
3 Types of Objects in MSTR Desktop
File > Email Reports As

45. Simple - Compound - Nested - Derived
4 types of Metrics
ETL process
Required on the report for Outline Model to work
Types of analysis you can perform with OLAP Services

46. Used to limit a possibly overwhelming set of potential prompt answers
MSTR Connectivity Wizard
Search-based prompts
Nested Metrics
Locking and Resizing

47. OLAP Services does not add any ______ to the report query.
Advantage of a completely denormalized schema
To drill through User Hierarchies
3 Methods of MSTR Desktop navigation
New SQL

48. 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.
Object Prompts
Project-level options/settings
Characteristics of a Compound Table Key
View Filters

49. Columns - Tables
Attribute Forms
3 Sections of the MSTR Desktop interface
Desktop Designer
2 components of a Physical Schema

50. AND - OR - OR NOT - AND NOT
Cannot create project objects
Report Editor
Locking and Resizing
Report Filter operators