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. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending

2. Subtotals reflect accumulations at selected attribute levels

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

4. Used to "fine-tune" your Project

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

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

7. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations

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

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

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

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

12. Creating multiple attributes quickly. Used during the initial project creation.

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

14. ID columns - Description columns - Fact columns

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

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

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

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

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

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

21. Formula - Level (Dimensionality) - Conditionality - Transformation

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

23. You can _____________ in the Architect Graphical Interface.

24. Enables you to select and display subsets of a report as separate pages.

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

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

27. Level of OLTP integration

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

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

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

31. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.

32. Compound - Homogeneous - Heterogeneous

33. Create the Project Source - Create the Database Instance

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

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 simplified version of Desktop - providing interactive "slice-&-dice" capabilities

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

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

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

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

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

42. The default entry-points.

43. Schema Objects - Application Objects - Configuration Objects

44. Less storage - Simple SQL - Complex ETL

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

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

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

48. Used to modify a Report

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

50. OLAP retains data ________