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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.

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

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

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

5. Primary keys

6. Enables you to rearrange the columns and rows in a report.

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

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

9. MS Excel - MS Word - MS Access - PDF - HTML - Plain text

10. Simple - Derived

11. All Attributes must have an _______.

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

13. To see data at completely different levels - other than that of the original Grid or Graph

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

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

16. Direct: 2-tier - Server: 3-tier

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

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

19. Metrics you create within a report using only those objects in the report.

20. User requirements - Existing source data - Technical and performance considerations

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

22. Grid View - Graph View - Grid/Graph View - SQL View

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

24. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)

25. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition

26. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling

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

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

29. Enables you to select which tables from the data-warehouse to store in the Metadata database

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

31. A development environment to create BI applications - allowing users to edit the Metadata database

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

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

34. A condition data must meet in order to be included in a report. Does affect the SQL.

35. OLAP retains data ________

36. The Attribute Form maps to different column names in multiple tables

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

38. Extraction - transformation - loading


40. Less storage - Simple SQL - Complex ETL

41. Used to "fine-tune" your Project

42. Simple - Compound - Nested - Derived

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

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

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

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

47. A Project Source can house ________ . A single Metadata can be used by multiple Projects.

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

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

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