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. Grid View - Graph View - Grid/Graph View - SQL View

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

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

4. Schema Objects - Application Objects - Configuration Objects

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

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

7. OLTP data storage measure

8. It contains the ID column of all higher-level attributes

9. A feature that enables users to delivers reports to the history list - cache or mobile

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

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

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

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

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

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

16. Template - Filter - View of a Report

17. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships

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

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

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

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

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

23. Less storage - Simple SQL - Complex ETL

24. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.

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

26. More storage - Complex SQL - Simple ETL

27. Level of OLAP integration

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

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

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

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

32. The Attribute Form Expression that maps to a single column - no matter the number of tables

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

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

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

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

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

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

39. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships

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

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

42. Create the Project Source - Create the Database Instance

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

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

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

46. Level of OLTP integration

47. The default entry-points.

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

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

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