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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
3 functions of Attribute Forms
Default Project folder structure
Application Objects
Physical Schema

2. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Search-based prompts
Thresholding
New SQL

3. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To edit the appearance of a Graph in a report
2 types of Fact Expressions
Rollback your changes
To save a Report Format

4. Level of OLTP integration
Minimal or none
Report Objects
MSTR Desktop
Advantage of a completely denormalized schema

5. What tool do you use to create the Metadata shell?
Terabytes (TB)
Configuration Wizard
4 types of Prompts
Lookup Tables

6. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Long-term (2 - 5 years)
3 Types of Objects in MSTR Desktop
Logical Data Model
Schema Object Editor

7. Less storage - Simple SQL - Complex ETL
Characteristics of a Compound Table Key
Characteristics of a Simple Table Key
Compound Attribute
2 methods to creating Facts

8. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Shortcut Bar
Types of analysis you can perform with OLAP Services
2 methods to creating Facts
Thresholding

9. Enables you to select which tables from the data-warehouse to store in the Metadata database
Project
Stored
Warehouse Catalog
Gigabytes (GB)

10. View Filters can only ___________.
Homogeneous Attribute
Reference Report Objects
Required on the report for Outline Model to work
Report Filter operators

11. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Lookup Table structure of a moderately denormalized schema
To edit the appearance of a Graph in a report
Report Subscription
Data Pivoting

12. One that uses 2 or more columns as its ID
Attributes
Components of a Derived Metric
Table Keys
Compound Attribute

13. Facts - Attributes - Hierarchies
Desktop Analyst
Thresholding
Components of the Logical Data Model
Simple Metrics

14. Formula - Level (Dimensionality) - Conditionality - Transformation
Project
Different methods for creating Page-by fields
Heterogeneous Fact
Components of a Metric

15. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Derived Metrics
Report Template
Heterogeneous Fact
Application Objects

16. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Thresholding
Architect Graphical Interface
Project-level options/settings

17. OLAP data storage measure
3 Sections of the MSTR Desktop interface
3-Tier Architecture
Project Source
Terabytes (TB)

18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
4 types of Report Filters
Heterogeneous Fact
Homogeneous Attribute
Unlimited

19. A feature that enables users to delivers reports to the history list - cache or mobile
By default
Report Subscription
Attribute or its relationship(s)
Derived Metrics

20. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
Reports
Different methods for creating Page-by fields
Characteristics of a Compound Table Key

21. 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
To save a Report Format
Attribute Forms
4 types of Report Filters
To "drill down" on a report

22. Groupings of directly related attributes. Also commonly known as "dimensions".
Using a Search Object
Object Prompts
Hierarchies
Tasks when defining a User Hierarchy

23. Extraction - transformation - loading
ETL
4 basic Schema objects
To create a Report Prompt
Lookup Table structure of a moderately denormalized schema

24. User reporting requirements - Query performance - Data volume - DB Maintenance
Filter Definition Prompts
File > Email Reports As
4 factors to consider when designing a data-warehouse schema
Relationship Tables

25. Grid View - Graph View - Grid/Graph View - SQL View
Schema Objects
To create the Project connectivity
Fact Tables
Display views you can Print by

26. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
2 components of a Physical Schema
Lookup Table structure of a moderately denormalized schema
By default

27. Simple - Derived
2 types of Attribute Expression
Characteristics of Nested Metrics
Project Creation Wizard
Unlimited

28. OLAP retains data ________
Search-based prompts
Long-term (2 - 5 years)
Table Keys
Attributes

29. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Drilling
Facts
3 project creation interfaces
Column Aliases

30. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Search Object
3 project creation interfaces
Schema

31. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Report Formatting
Types of analysis you can perform with OLAP Services
2 types of Attribute Expression
Project Source

32. Used to "fine-tune" your Project
4 types of Metrics
5 Report display views
4 parts of the Project Design Process
Architect Graphical Interface

33. 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
2 types of Table Keys
Characteristics of a Simple Table Key
4 parts of the Project Design Process

34. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Components of the Logical Data Model
Schema Objects
Long-term (2 - 5 years)

35. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Object Prompts
Report Formatting
Derived Metrics

36. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Schema Object Editor
Lookup Tables
Banding

37. Direct: 2-tier - Server: 3-tier
Data warehouse characteristics
Banding
Report Objects
2 ways you can configure the Project Source to connect to the Metadata database

38. You must select "Other directions" when drilling attributes while viewing a report
Configuration Wizard
4 types of Prompts
To drill through User Hierarchies
Attribute Forms

39. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
To create a Report Prompt
Attribute or its relationship(s)
3 Schema types
Report Definitions

40. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
File types are allowed for exporting a Report
3-Tier Architecture
Project-level options/settings

41. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Project Creation Wizard
Architect Graphical Interface
3 functions of Attribute Forms
The 3 MSTR Tools

42. All report-level options overwrite ___________.
Long-term (2 - 5 years)
Reference Report Objects
Project-level options/settings
Source system characteristics

43. The System Hierarchy is automatically updated whenever you make a change to an __________________.
ETL
Attribute or its relationship(s)
Components of Compound Metrics
Shortcut in MSTR Desktop

44. Prompts to select a single value on which to qualify a date - number or text string.
Characteristics of a Compound Table Key
Value Prompts
4 types of Metrics
Configuration Wizard

45. Enables you to rearrange the columns and rows in a report.
3 Schema types
Data Pivoting
Characteristics of Nested Metrics
3 types of Attributes

46. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Schema Object Editor
Different methods for creating Page-by fields
Reports
Characteristics of a Compound Table Key

47. The unique values of an attribute obtained from the data-warehouse
Facts
Attribute Elements
'View of a Report'
Search-based prompts

48. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
2 types of Attribute Relationships
To "drill down" on a report
Desktop Administrative Functions
MSTR Desktop

49. OLTP retains data ________
Level Prompts
Short-term (2 - 6 months)
Schema Object Editor
Required on the report for Outline Model to work

50. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Shortcut Bar
Column Aliases
Schema Objects
Architect Graphical Interface