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. OLTP retains data ________

2. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations

3. Facts associated to the same column name in 1 or more tables

4. Used to modify a Report

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

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

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

8. Specifies a condition data must meet in order to be included in a report

9. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.

10. Store info about attributes - including IDs and any descriptions. Used for easier browsing.

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

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

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

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

15. Simple - Compound - Nested - Derived

16. All report-level options overwrite ___________.

17. A subset of a report that users can manipulate without altering the SQL

18. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.

19. Grid View - Graph View - Grid/Graph View - SQL View

20. More storage - Complex SQL - Simple ETL

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

22. The logical associations between attributes that exist based on a business rule

23. User reporting requirements - Query performance - Data volume - DB Maintenance

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

25. An environment in which the MSTR Desktop connects directly to the Metadata database.

26. You can e-mail reports by going to _____

27. Must have Subtotals enabled - or you won't see any data for higher-level attributes

28. Create the Project Source - Create the Database Instance


30. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell

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

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

33. Subtotals reflect accumulations at selected attribute levels

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

35. It creates the System Hierarchy - when you define Attributes and their corresponding relationships

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

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

38. The default entry-points.

39. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked

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

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

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

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

44. Enables you to search for a specific Object or group of Objects that meet a certain criteria.

45. View Filters are saved with the _____________.

46. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports

47. Descriptive data that provides context for Facts.

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

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

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