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. One that uses 2 or more columns as its ID

2. More storage - Complex SQL - Simple ETL

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

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

5. Schema Objects - Application Objects - Configuration Objects

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

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

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

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

10. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format

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

12. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy

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

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

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

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

17. View Filters can only ___________.

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

19. Used to modify a Report

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

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

22. A new tool for project design tasks - used for fine-tuning a project after initial creation

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

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

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

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

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

28. View Filters are saved with the _____________.

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

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

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

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

33. Attribute Creation Wizard - Attribute Editor

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

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

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

37. Extraction - transformation - loading

38. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data

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

40. A shortcut to an existing Object in a Project

41. Facts - Attributes - Hierarchies

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

43. It contains the ID column of the parent attribute

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

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

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

47. Filter definition prompts - Object prompts - Value prompts - Level prompts

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

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

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