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

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

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

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

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

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

7. OLTP data storage measure

8. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner

9. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...

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

11. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns

12. Facts associated to different column names in 2 or more tables

13. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.

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

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

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

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

18. More storage - Complex SQL - Simple ETL

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

20. How users can share comments for reports to other users

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

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

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

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

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

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

27. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.

28. What tool do you use to create the Metadata DSN connection?

29. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts

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

31. Used for - Initially populating the Metadata - Creating schema objects

32. Simple - Compound - Nested - Derived

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

34. View Filters can only ___________.

35. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)

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

37. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications

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

39. Subtotals reflect accumulations at selected attribute levels

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

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

42. Must have a one-to-one relationship with all other forms.

43. Less storage - Simple SQL - Complex ETL

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

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

46. All Attributes must have an _______.

47. Create the Project Source - Create the Database Instance

48. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema

49. Schema Objects - Application Objects - Configuration Objects

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