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. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Minimal or none
To save a Report Format
Attribute Forms
Project Creation Wizard

2. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
4 tasks of the Attribute Creation Wizard
Sample Metrics commonly performed on Facts
Schema

3. More storage - Complex SQL - Simple ETL
User Hierarchies
Characteristics of a Compound Table Key
Schema
To create a Report Prompt

4. Simple - Compound - Nested - Derived
4 types of Metrics
Sorting
Column Aliases
Shortcut in MSTR Desktop

5. It contains the ID and DESC columns of all higher-level attributes
Column Aliases
Lookup Table structure of a completely denormalized schema
Report Editor
Report Subscription

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

7. Subtotals reflect accumulations at selected attribute levels
Report Formatting
Subtotals
Report Editor
Short-term (2 - 6 months)

8. View Filters are saved with the _____________.
Report Definitions
Using a Search Object
Attribute Forms
Reference Report Objects

9. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Reports
MSTR Desktop
File types are allowed for exporting a Report
2 methods to creating Facts

10. Metrics aggregate on the lowest-level attribute __________.
By default
4 tasks of the Attribute Creation Wizard
Schema
2 components of a Physical Schema

11. Tables - Facts - Attributes - Hierarchies
Shortcut in MSTR Desktop
4 basic Schema objects
4 properties you must know in order to create attributes using the Attribute Editor
The System

12. Facts associated to the same column name in 1 or more tables
Very high; part of ETL process
Advantage of a completely denormalized schema
Homogeneous Fact
Required on the report for Outline Model to work

13. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Using a Search Object
The 3 MSTR Tools
View Filter
2 types of Table Keys

14. Specifies a condition data must meet in order to be included in a report
Advantage of a completely denormalized schema
Attribute Relationships
Report Filter
Level Prompts

15. All report-level options overwrite ___________.
Reports
Project-level options/settings
Value Prompts
Facts

16. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Application Objects
Rollback your changes
The System
Limitations of the Attribute Creation Wizard

17. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Locking and Resizing
Attribute Elements
OLTP
Sample Metrics commonly performed on Facts

18. How users can share comments for reports to other users
Different methods for creating Page-by fields
2 types of Attribute Relationships
Notes
Data Pivoting

19. Attribute Creation Wizard - Attribute Editor
Warehouse Catalog
Project-level options/settings
Methods are there to creating Attributes
To qualify a Metric in a Set Qualification

20. Template - Filter - View of a Report
By default
3 components of a Report
5 steps to creating a logical data model
4 tasks of the Attribute Creation Wizard

21. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Lookup Table structure of a completely denormalized schema
Fact Tables
Facts
Logical Data Model

22. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
4 types of Prompts
Default Project folder structure
Factors to consider when designing a logical data model

23. A user interface for creating and maintaining a BI environment
Nested Metrics
MSTR applications
4 factors to consider when designing a data-warehouse schema
MSTR Desktop

24. OLAP Services does not add any ______ to the report query.
Level Prompts
New SQL
3 column types of a Physical Schema
Sample Metrics commonly performed on Facts

25. OLAP data storage measure
Terabytes (TB)
Data warehouse characteristics
2 types of Fact Expressions
Long-term (2 - 5 years)

26. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
The System
Lookup Table structure of a moderately denormalized schema
User Hierarchies

27. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
User Hierarchies
3 column types of a Physical Schema
Project Source
Default Project folder structure

28. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
Limitations of the Attribute Creation Wizard
Source system characteristics
Locking and Resizing

29. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Homogeneous Attribute
2 types of Attribute Relationships
Components of Compound Metrics
Report Objects

30. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
4 types of Metrics
Fact Expression
Physical Schema
Sorting

31. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
Application Objects
Report Filter operators
Project Creation Wizard

32. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Metrics
Using a Search Object
3 components of a Report
2 types of Table Keys

33. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
By default
To drill through User Hierarchies
2 options for Sorting

34. It contains links to specific folders in the Folder List
3 Methods of MSTR Desktop navigation
Lookup Table structure of a completely normalized schema
Shortcut Bar
MSTR OLAP Services

35. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Display views you can Print by
Lookup Table structure of a moderately denormalized schema
2 types of Fact Expressions
Column Aliases

36. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Sorting
MSTR applications
Outline Mode
Simple Attribute Expression

37. Level of OLTP integration
Minimal or none
Attribute Forms
2-Tier Architecture
Logical Data Model

38. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
4 types of Prompts
Components of a Derived Metric
By default
Table Keys

39. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Attribute Forms
By default
4 tasks of the Attribute Creation Wizard

40. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
To "drill down" on a report
Architect Graphical Interface
3 Sections of the MSTR Desktop interface

41. ID columns - Description columns - Fact columns
2 types of Table Keys
ETL
Search Object
3 column types of a Physical Schema

42. The Attribute Form maps to different column names in multiple tables
3 types of Attributes
Types of drilling
Outline Mode
Heterogeneous Attribute

43. 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
3 Schema types
Stored
Desktop Designer

44. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Report Template
Compound Attribute
Components of a MSTR architecture
Attribute Forms

45. A new tool for project design tasks - used for fine-tuning a project after initial creation
4 basic Schema objects
'View of a Report'
Architect Graphical Interface
Lookup Table structure of a completely denormalized schema

46. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Search-based prompts
Value Prompts
To drill through User Hierarchies
Cannot create project objects

47. Top menu/dropdowns - Toolbar - Right-click popup menus
2 ways you can configure the Project Source to connect to the Metadata database
User Hierarchies
3 Methods of MSTR Desktop navigation
4 basic Schema objects

48. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Factors to consider when designing a logical data model
Limitations of the Attribute Creation Wizard
4 properties you must know in order to create attributes using the Attribute Editor
Heterogeneous Fact

49. Using the Prompt Generation Wizard - Inside the Report Editor
Objects you are allowed to Page-by
To create a Report Prompt
Required on the report for Outline Model to work
Simple Attribute Expression

50. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Compound Attribute
Application Objects
Default Project folder structure
Long-term (2 - 5 years)