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

2. It contains links to specific folders in the Folder List
Simple Metrics
Shortcut Bar
Architect Graphical Interface
4 basic Schema objects

3. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Objects you are allowed to Page-by
Desktop Administrative Functions
Tasks when defining a User Hierarchy
Level Prompts

4. All Attributes must have an _______.
Compound Metric
ID form
Physical Schema
2 types of Table Keys

5. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Types of analysis you can perform with OLAP Services
Aggregate a Metric
To save a Report Format

6. Extraction - transformation - loading
ETL
Schema Object Editor
Project Source
Schema Objects

7. A feature that enables users to delivers reports to the history list - cache or mobile
Project
Homogeneous Fact
Report Subscription
Desktop Analyst

8. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Locking and Resizing
Project Source
3-Tier Architecture

9. Groupings of directly related attributes. Also commonly known as "dimensions".
Physical Schema
Banding
Components of a Metric
Hierarchies

10. A new tool for project design tasks - used for fine-tuning a project after initial creation
Project-level options/settings
Architect Graphical Interface
Schema
5 steps to creating a logical data model

11. The unique values of an attribute obtained from the data-warehouse
3 types of Attributes
Report Formatting
Attribute Elements
Subtotals

12. User requirements - Existing source data - Technical and performance considerations
Architect Graphical Interface
Report Filter
Factors to consider when designing a logical data model
To qualify a Metric in a Set Qualification

13. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
2 types of Attribute Expression
4 types of Report Filters
2-Tier Architecture

14. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Report Template
2 methods to creating Facts
Required on the report for Outline Model to work
Facts

15. A user interface for creating and maintaining a BI environment
Nested Metrics
3 project creation interfaces
4 types of Metrics
MSTR Desktop

16. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Locking and Resizing
Reports
Thresholding
New SQL

17. Columns - Tables
Highest-level attributes
2 components of a Physical Schema
4 factors to consider when designing a data-warehouse schema
Desktop Designer

18. It contains the ID column of the parent attribute
Rollback your changes
Lookup Table structure of a completely normalized schema
Limitations of the Attribute Creation Wizard
Attribute Elements

19. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Report Editor
Architect Graphical Interface
Attribute or its relationship(s)

20. One that uses 2 or more columns as its ID
Limitations of the Attribute Creation Wizard
OLTP
Compound Attribute
2 ways you can configure the Project Source to connect to the Metadata database

21. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Heterogeneous Attribute
2 types of Facts
Components of Compound Metrics

22. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
2 types of Attribute Expression
Report Filter
Attribute Relationships

23. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Components of a MSTR architecture
Cannot create project objects
Compound Attribute
Process for creating the Project Metadata

24. OLAP Services does not add any ______ to the report query.
New SQL
Locking and Resizing
Unlimited
Project

25. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Sample Metrics commonly performed on Facts
ID form
5 steps to creating a logical data model
Notes

26. OLTP data storage measure
To "drill down" on a report
3-Tier Architecture
File > Email Reports As
Gigabytes (GB)

27. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Warehouse Catalog
4 parts of the Project Design Process
Components of a Derived Metric
Simple Attribute Expression

28. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Attribute or its relationship(s)
Subtotals
2 types of Fact Expressions
4 properties you must know in order to create attributes using the Attribute Editor

29. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Stored
Components of a Derived Metric
Components of the Logical Data Model
To edit the appearance of a Graph in a report

30. You can e-mail reports by going to _____
To create the Project connectivity
Attribute Forms
File > Email Reports As
Using a Search Object

31. A condition data must meet in order to be included in a report. Does affect the SQL.
2 types of Table Keys
Report Filter
Lookup Table structure of a moderately denormalized schema
Metrics

32. AND - OR - OR NOT - AND NOT
View Filters
Report Filter operators
Schema Objects
Objects you are allowed to Page-by

33. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Homogeneous Fact
Column Aliases
Minimal or none

34. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Rollback your changes
Simple Metrics
To qualify a Metric in a Set Qualification

35. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Attribute Relationships
MSTR Desktop Architect
Outline Mode

36. Homogeneous - Heterogeneous
2 types of Facts
2-Tier Architecture
Logical Data Model
Report Editor

37. 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
ETL
Table Keys
Architect Graphical Interface

38. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Attribute Relationships
4 factors to consider when designing a data-warehouse schema
To save a Report Format
2 components of a Physical Schema

39. OLAP retains data ________
Attribute Forms
Components of Compound Metrics
To save a Report Format
Long-term (2 - 5 years)

40. Enables you to lock column headers so that they always appear when scrolling
Components of a Metric
Locking and Resizing
Attribute Elements
Filter Definition Prompts

41. Level of OLTP integration
Using a Search Object
Hierarchies
Project Source
Minimal or none

42. Facts associated to the same column name in 1 or more tables
Logical Data Model
5 steps to creating a logical data model
Schema Objects
Homogeneous Fact

43. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Search Object
Default Project folder structure
3 types of Attributes

44. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Subtotals
Different methods for creating Page-by fields
Page-by
3 components of a Report

45. Create the Project Source - Create the Database Instance
The System
Metrics
Tasks when defining a User Hierarchy
To create the Project connectivity

46. The logical associations between attributes that exist based on a business rule
Configuration Wizard
Attribute Relationships
Banding
Desktop Analyst

47. Specifies a condition data must meet in order to be included in a report
Simple Attribute Expression
Attributes
Report Filter
Hierarchies

48. Descriptive data that provides context for Facts.
Application Objects
Attribute Forms
Different methods for creating Page-by fields
Display views you can Print by

49. What tool do you use to create the Metadata shell?
Objects you are allowed to Page-by
Configuration Wizard
Simple Attribute Expression
Advantage of a completely denormalized schema

50. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
4 types of Report Filters
2 ways you can configure the Project Source to connect to the Metadata database
Object Prompts