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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views

2. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.

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

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

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

6. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save

7. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.

8. Used to create or edit complex attributes - facts - hierarchies - and logical tables

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

10. OLTP data storage measure

11. Compound - Homogeneous - Heterogeneous

12. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.

13. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.

14. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data

15. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling

16. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.

17. Metrics that perform multiple aggregations; one calculation inside of another.

18. One that uses 2 or more columns as its ID

19. What tool do you use to create the Metadata shell?

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

21. It contains links to specific folders in the Folder List

22. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.

23. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form

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

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

26. Simple - Compound - Nested - Derived

27. OLAP retains data ________

28. You must select "Other directions" when drilling attributes while viewing a report

29. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).

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

31. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities

32. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View

33. A user interface for creating and maintaining a BI environment

34. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts

35. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression

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


38. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)

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

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

41. Groupings of directly related attributes. Also commonly known as "dimensions".

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

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

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

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

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

47. User management - Security profiles - Server parameters - like report length - idle time and report prioritization

48. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.

49. A shortcut to an existing Object in a Project

50. Metrics aggregate on the lowest-level attribute __________.