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. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Project Source
3 project creation interfaces
3 Methods of MSTR Desktop navigation
Gigabytes (GB)

2. Must have a one-to-one relationship with all other forms.
Attribute Forms
3 functions of Attribute Forms
2 methods to creating Facts
3-Tier Architecture

3. ID columns - Description columns - Fact columns
Metrics
Advantage of a completely denormalized schema
3 column types of a Physical Schema
Components of a Derived Metric

4. What tool do you use to create the Metadata shell?
Process for creating the Project Metadata
2 types of Table Keys
Attribute Forms
Configuration Wizard

5. Descriptive data that provides context for Facts.
To qualify a Metric in a Set Qualification
Components of a Derived Metric
Minimal or none
Attribute Forms

6. 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.
Unlimited
Advantage of a completely denormalized schema
User Hierarchies
View Filter

7. You can _____________ in the Architect Graphical Interface.
4 tasks of the Attribute Creation Wizard
Rollback your changes
Reference Report Objects
4 basic Schema objects

8. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Terabytes (TB)
Attribute Relationships
Report Definitions
Lookup Tables

9. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
View Filter
Components of a Metric
Process for creating the Project Metadata
3-Tier Architecture

10. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Logical Data Model
Report Template
Factors to consider when designing a logical data model

11. All report-level options overwrite ___________.
3 Schema types
MSTR OLAP Services
Subtotals
Project-level options/settings

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

13. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Using a Search Object
Sorting
Very high; part of ETL process

14. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Page-by
4 types of Report Filters
Derived Attribute Expression

15. Facts - Attributes - Hierarchies
Process for creating the Project Metadata
4 properties you must know in order to create attributes using the Attribute Editor
Schema Objects
Components of the Logical Data Model

16. Columns - Tables
Facts
Application Objects
3 components of a Report
2 components of a Physical Schema

17. 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.
Project-level options/settings
Report Prompts
The 3 MSTR Tools
Heterogeneous Attribute

18. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Heterogeneous Attribute
Source system characteristics
Attribute Forms
Attribute Relationships

19. A user interface for creating and maintaining a BI environment
Components of a MSTR architecture
Lookup Table structure of a completely normalized schema
MSTR Desktop
3 functions of Attribute Forms

20. Reduced number of JOINS in the generated SQL
Configuration Wizard
MSTR applications
Advantage of a completely denormalized schema
Locking and Resizing

21. A new tool for project design tasks - used for fine-tuning a project after initial creation
Terabytes (TB)
2 ways you can configure the Project Source to connect to the Metadata database
Architect Graphical Interface
Report Filter operators

22. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Attributes
Schema Objects
3-Tier Architecture
Facts

23. A development environment to create BI applications - allowing users to edit the Metadata database
Lookup Table structure of a moderately denormalized schema
Types of drilling
Homogeneous Fact
Desktop Architec

24. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Components of a Metric
View Filter
'View of a Report'
Factors to consider when designing a logical data model

25. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
ID form
To "drill down" on a report
2 types of Facts
2 types of Fact Expressions

26. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Physical Schema
Lookup Table structure of a moderately denormalized schema
Display views you can Print by

27. Metrics aggregate on the lowest-level attribute __________.
Lookup Table structure of a moderately denormalized schema
By default
Logical Data Model
2 methods to creating Facts

28. The actual column name for a fact. Every fact must have at least 1 expression.
Level Prompts
Default Project folder structure
Sorting
Fact Expression

29. Creating multiple attributes quickly. Used during the initial project creation.
Schema Objects
Architect Graphical Interface
Attribute Creation Wizard good for
Report Definitions

30. OLAP retains data ________
To save a Report Format
3 types of Attributes
The 3 MSTR Tools
Long-term (2 - 5 years)

31. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Required on the report for Outline Model to work
Outline Mode
Display views you can Print by

32. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Relationship Tables
4 types of Report Filters
Objects you are allowed to Page-by
2 options for Sorting

33. Level of OLAP integration
Display views you can Print by
Simple Metrics
Configuration Wizard
Very high; part of ETL process

34. Specifies what info to retrieve from a data-warehouse - and how to display it
Derived Attribute Expression
Rollback your changes
Report Template
2 ways you can configure the Project Source to connect to the Metadata database

35. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Highest-level attributes
2 types of Attribute Expression
Report Template
To edit the appearance of a Graph in a report

36. Used to "fine-tune" your Project
Minimal or none
Cannot create project objects
Architect Graphical Interface
Search-based prompts

37. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
To create a Report Prompt
Subtotals
Schema Objects
Attribute Forms

38. 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.
Minimal or none
Banding
Attribute Forms
View Filters

39. Simple - Derived
Objects you are allowed to Page-by
2 types of Attribute Expression
2 components of a Physical Schema
Report Filter operators

40. Used to modify a Report
Report Editor
Data warehouse characteristics
Project Source
Reference Report Objects

41. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Shortcut Bar
2 types of Table Keys
2 types of Fact Expressions

42. Extraction - transformation - loading
Banding
Short-term (2 - 6 months)
ETL
Schema Object Editor

43. View Filters can only ___________.
Reference Report Objects
By default
Notes
Reports

44. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Tasks when defining a User Hierarchy
The System
4 factors to consider when designing a data-warehouse schema
Minimal or none

45. It contains the ID column of the parent attribute
Characteristics of Nested Metrics
Lookup Table structure of a completely normalized schema
Lookup Table structure of a completely denormalized schema
Object Prompts

46. Filter definition prompts - Object prompts - Value prompts - Level prompts
Process for creating the Project Metadata
To qualify a Metric in a Set Qualification
4 types of Prompts
Derived Metrics

47. An environment in which the MSTR Desktop connects directly to the Metadata database.
Report Editor
2-Tier Architecture
ETL
2 types of Attribute Relationships

48. Enables you to lock column headers so that they always appear when scrolling
Nested Metrics
Fact Tables
Components of Compound Metrics
Locking and Resizing

49. User requirements - Existing source data - Technical and performance considerations
Page-by
3 functions of Attribute Forms
Factors to consider when designing a logical data model
Lookup Table structure of a completely normalized schema

50. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
To qualify a Metric in a Set Qualification
Application Objects
Thresholding