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. Facts - Attributes - Hierarchies
Components of the Logical Data Model
ETL
Simple Metrics
Lookup Tables

2. Used to create or edit complex attributes - facts - hierarchies - and logical tables
File > Email Reports As
Components of Compound Metrics
Schema Object Editor
MSTR Desktop Architect

3. The logical associations between attributes that exist based on a business rule
5 steps to creating a logical data model
Source system characteristics
Report Subscription
Attribute Relationships

4. AND - OR - OR NOT - AND NOT
Report Filter operators
Heterogeneous Fact
Attributes
Display views you can Print by

5. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Report Prompts
3-Tier Architecture
Relationship Tables
Gigabytes (GB)

6. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Project Creation Wizard
2 options for Sorting
ETL
Process for creating the Project Metadata

7. Enables you to lock column headers so that they always appear when scrolling
3-Tier Architecture
Attribute Elements
Fact Tables
Locking and Resizing

8. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Application Objects
Report Definitions
2 types of Fact Expressions
Homogeneous Fact

9. Template - Filter - View of a Report
3 components of a Report
Derived Metrics
MSTR applications
2 options for Sorting

10. Metrics aggregate on the lowest-level attribute __________.
By default
Attribute or its relationship(s)
Components of a Metric
Hierarchies

11. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
2 options for Sorting
Report Filter
To save a Report Format
Components of a Derived Metric

12. A condition data must meet in order to be included in a report. Does affect the SQL.
New SQL
Report Filter
Types of analysis you can perform with OLAP Services
Using a Search Object

13. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Desktop Designer
To edit the appearance of a Graph in a report
The 3 MSTR Tools
Components of Compound Metrics

14. Enables you to select and display subsets of a report as separate pages.
Compound Metric
Filter Definition Prompts
Page-by
Lookup Table structure of a completely denormalized schema

15. OLAP data storage measure
Drilling
3 Schema types
Terabytes (TB)
Notes

16. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Lookup Table structure of a completely normalized schema
Search-based prompts
4 types of Prompts
Limitations of the Attribute Creation Wizard

17. View Filters can only ___________.
Logical Data Model
Reference Report Objects
To create the Project connectivity
Facts

18. A development environment to create BI applications - allowing users to edit the Metadata database
Drilling
Facts
Desktop Architec
Page-by

19. View Filters are saved with the _____________.
Heterogeneous Attribute
Process for creating the Project Metadata
Report Definitions
Homogeneous Fact

20. More storage - Complex SQL - Simple ETL
Lookup Table structure of a completely denormalized schema
Characteristics of a Compound Table Key
Report Subscription
By default

21. All Attributes must have an _______.
Data warehouse characteristics
Report Editor
Report Template
ID form

22. OLTP retains data ________
View Filters
Short-term (2 - 6 months)
Facts
MSTR Connectivity Wizard

23. Direct: 2-tier - Server: 3-tier
OLTP
2 ways you can configure the Project Source to connect to the Metadata database
Desktop Administrative Functions
Project

24. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
3 types of Attributes
Source system characteristics
Outline Mode
Sorting

25. Schema Objects - Application Objects - Configuration Objects
Terabytes (TB)
Data Pivoting
3 Types of Objects in MSTR Desktop
To "drill down" on a report

26. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
To save a Report Format
Lookup Table structure of a moderately denormalized schema
4 basic Schema objects

27. Primary keys
Table Keys
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
Lookup Table structure of a moderately denormalized schema

28. OLAP retains data ________
Long-term (2 - 5 years)
Thresholding
3-Tier Architecture
Methods are there to creating Attributes

29. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Attribute Creation Wizard good for
Desktop Designer
2 types of Table Keys
2 methods to creating Facts

30. Compound - Homogeneous - Heterogeneous
Drilling
3 types of Attributes
4 types of Report Filters
3 Schema types

31. The unique values of an attribute obtained from the data-warehouse
Attribute Elements
Nested Metrics
2 types of Attribute Relationships
Homogeneous Attribute

32. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Advantage of a completely denormalized schema
Components of a MSTR architecture
Search Object
Filter Definition Prompts

33. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
To "drill down" on a report
Components of a MSTR architecture
Subtotals
Compound Metric

34. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Using a Search Object
Facts
Logical Data Model
4 tasks of the Attribute Creation Wizard

35. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Desktop Analyst
The 3 MSTR Tools
Search Object
Value Prompts

36. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Different methods for creating Page-by fields
Attribute Relationships
Reports
User Hierarchies

37. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Report Filter operators
Project
Lookup Table structure of a completely normalized schema

38. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
3 column types of a Physical Schema
To create a Report Prompt
5 steps to creating a logical data model
Report Formatting

39. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Attribute Forms
The System
Schema Objects
Aggregate a Metric

40. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Long-term (2 - 5 years)
5 steps to creating a logical data model
Report Definitions

41. Filter definition prompts - Object prompts - Value prompts - Level prompts
Lookup Table structure of a moderately denormalized schema
4 types of Prompts
Process for creating the Project Metadata
Sample Metrics commonly performed on Facts

42. A feature that enables users to delivers reports to the history list - cache or mobile
Aggregate a Metric
Hierarchies
Terabytes (TB)
Report Subscription

43. Descriptive data that provides context for Facts.
To drill through User Hierarchies
The System
Attribute or its relationship(s)
Attribute Forms

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

45. Using the Prompt Generation Wizard - Inside the Report Editor
Compound Attribute
File > Email Reports As
Characteristics of a Simple Table Key
To create a Report Prompt

46. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Terabytes (TB)
To edit the appearance of a Graph in a report
Lookup Table structure of a completely normalized schema
Nested Metrics

47. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
3 Methods of MSTR Desktop navigation
Components of a Derived Metric
Filter Definition Prompts
4 properties you must know in order to create attributes using the Attribute Editor

48. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Attribute Forms
Shortcut Bar
Report Formatting
Lookup Table structure of a completely normalized schema

49. Create the Project Source - Create the Database Instance
Components of a Metric
Derived Metrics
2 types of Facts
To create the Project connectivity

50. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Sorting
Page-by
Schema
To "drill down" on a report