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 shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
Column Aliases
Long-term (2 - 5 years)
Characteristics of a Simple Table Key

2. Allow you to interact with the BI system - logically organize data to analyze complex relationships
3-Tier Architecture
Characteristics of a Compound Table Key
Page-by
MSTR applications

3. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Lookup Tables
To drill through User Hierarchies
Report Prompts
Sorting

4. Prompts to select a single value on which to qualify a date - number or text string.
Attribute Forms
Physical Schema
Value Prompts
Application Objects

5. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Rollback your changes
Configuration Wizard
Tasks when defining a User Hierarchy

6. OLAP data storage measure
Notes
Report Formatting
Report Filter
Terabytes (TB)

7. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Banding
Derived Attribute Expression
Methods are there to creating Attributes
4 properties you must know in order to create attributes using the Attribute Editor

8. Direct: 2-tier - Server: 3-tier
3 column types of a Physical Schema
Types of analysis you can perform with OLAP Services
4 parts of the Project Design Process
2 ways you can configure the Project Source to connect to the Metadata database

9. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Schema Object Editor
To "drill down" on a report
To edit the appearance of a Graph in a report
Project Creation Wizard

10. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
To create a Report Prompt
Report Editor
Report Filter
Facts

11. How users can share comments for reports to other users
Fact Tables
Source system characteristics
Components of Compound Metrics
Notes

12. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To edit the appearance of a Graph in a report
Types of analysis you can perform with OLAP Services
File types are allowed for exporting a Report
MSTR Connectivity Wizard

13. Primary keys
Table Keys
3-Tier Architecture
To create a Report Prompt
2 types of Attribute Expression

14. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
ETL
ETL process
Object Prompts

15. Used for - Initially populating the Metadata - Creating schema objects
3 project creation interfaces
File > Email Reports As
5 Report display views
MSTR Desktop Architect

16. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
File types are allowed for exporting a Report
Unlimited
2 types of Attribute Relationships
4 properties you must know in order to create attributes using the Attribute Editor

17. Facts - Attributes - Hierarchies
Default Project folder structure
Components of the Logical Data Model
Highest-level attributes
Search-based prompts

18. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
3 column types of a Physical Schema
To "drill down" on a report
Locking and Resizing
Stored

19. Creating multiple attributes quickly. Used during the initial project creation.
Project
Lookup Table structure of a completely denormalized schema
Attribute Creation Wizard good for
Sample Metrics commonly performed on Facts

20. Metrics aggregate on the lowest-level attribute __________.
Lookup Table structure of a completely denormalized schema
Heterogeneous Fact
By default
MSTR Desktop

21. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
OLTP
Components of a Metric
MSTR OLAP Services
To save a Report Format

22. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Filter Definition Prompts
File types are allowed for exporting a Report
Display views you can Print by
Components of Compound Metrics

23. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Factors to consider when designing a logical data model
Relationship Tables
Methods are there to creating Attributes

24. Less storage - Simple SQL - Complex ETL
Report Objects
Characteristics of a Simple Table Key
Nested Metrics
Report Filter operators

25. The unique values of an attribute obtained from the data-warehouse
Report Filter
Configuration Wizard
Drilling
Attribute Elements

26. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Characteristics of a Compound Table Key
Simple Metrics
Outline Mode
Methods are there to creating Attributes

27. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
File > Email Reports As
Report Filter
2 components of a Physical Schema

28. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Schema Objects
Column Aliases
Objects you are allowed to Page-by
Gigabytes (GB)

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

30. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Report Filter
The 3 MSTR Tools
Level Prompts
Schema Object Editor

31. A development environment to create BI applications - allowing users to edit the Metadata database
4 tasks of the Attribute Creation Wizard
Desktop Architec
Homogeneous Fact
Warehouse Catalog

32. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Analyst
Components of the Logical Data Model
Using a Search Object
Characteristics of a Simple Table Key

33. Level of OLTP integration
Page-by
Source system characteristics
Attribute or its relationship(s)
Minimal or none

34. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Derived Attribute Expression
Desktop Administrative Functions
2 ways you can configure the Project Source to connect to the Metadata database

35. Subtotals reflect accumulations at selected attribute levels
Subtotals
Components of Compound Metrics
2 types of Fact Expressions
MSTR applications

36. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Reports
2 ways you can configure the Project Source to connect to the Metadata database
Sorting
Physical Schema

37. Formula - Level (Dimensionality) - Conditionality - Transformation
Lookup Table structure of a completely denormalized schema
Components of a Metric
MSTR applications
Desktop Architec

38. View Filters can only ___________.
Report Subscription
Reference Report Objects
4 factors to consider when designing a data-warehouse schema
To edit the appearance of a Graph in a report

39. What tool do you use to create the Metadata shell?
Relationship Tables
Logical Data Model
Report Objects
Configuration Wizard

40. It contains the ID and DESC columns of all higher-level attributes
Default Project folder structure
Lookup Table structure of a completely denormalized schema
2 types of Facts
Data Pivoting

41. Extraction - transformation - loading
Notes
To qualify a Metric in a Set Qualification
Limitations of the Attribute Creation Wizard
ETL

42. Folder List - Object Viewer - Shortcut Bar
Types of drilling
Project
Lookup Tables
3 Sections of the MSTR Desktop interface

43. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Project
Desktop Analyst
Facts
4 types of Prompts

44. Specifies a condition data must meet in order to be included in a report
Hierarchies
Compound Metric
MSTR Desktop
Report Filter

45. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
5 steps to creating a logical data model
Aggregate a Metric
Compound Attribute
To save a Report Format

46. Using the Prompt Generation Wizard - Inside the Report Editor
Components of a Metric
4 types of Prompts
To create a Report Prompt
Components of the Logical Data Model

47. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
2-Tier Architecture
Metrics
The System
Lookup Table structure of a completely denormalized schema

48. ID columns - Description columns - Fact columns
New SQL
3 column types of a Physical Schema
Attribute Elements
Very high; part of ETL process

49. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Architect Graphical Interface
Configuration Wizard
2 methods to creating Facts
Object Prompts

50. Simple - Derived
Project Source
Sample Metrics commonly performed on Facts
Data warehouse characteristics
2 types of Attribute Expression