Test your basic knowledge |

Certified Project Designer Cpd

  • 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. Used for - Initially populating the Metadata - Creating schema objects

2. The unique values of an attribute obtained from the data-warehouse

3. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View

4. It contains the ID and DESC columns of all higher-level attributes

5. The actual column name for a fact. Every fact must have at least 1 expression.

6. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report

7. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents

8. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics

9. Extraction - transformation - loading

10. Enables you to lock column headers so that they always appear when scrolling

11. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending

12. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)

13. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.

14. Grid View - Graph View - Grid/Graph View - SQL View

15. A method of organizing the appearance of report results in a Grid report based on a criteria

16. Simple - Compound - Nested - Derived

17. Top menu/dropdowns - Toolbar - Right-click popup menus

18. Store info on relationships between 2 or more tables (attributes) - like an Index table.

19. A shortcut to an existing Object in a Project

20. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types

21. Enables you to format report values based on a condition - such as highlights - font colors - etc.

22. To define the level of aggregation for a specific metric - Used for qualifications

23. Used to limit a possibly overwhelming set of potential prompt answers

24. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded

25. Contains info that facilitates the transfer of data from the source systems to the data-warehouse

26. Prompts to select a single value on which to qualify a date - number or text string.

27. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.

28. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts

29. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface

30. A feature that enables users to delivers reports to the history list - cache or mobile

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

32. Columns - Tables

33. It contains the ID column of the parent attribute

34. The Attribute Form maps to the same column name in multiple tables

35. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.

36. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen

37. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.

38. The System Hierarchy is automatically updated whenever you make a change to an __________________.

39. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters

40. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound

41. Specifies what info to retrieve from a data-warehouse - and how to display it

42. OLTP retains data ________

43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar

44. OLAP Services does not add any ______ to the report query.

45. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier

46. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform

47. All report-level options overwrite ___________.

48. Compound - Homogeneous - Heterogeneous

49. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships

50. OLAP data storage measure