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. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types

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

3. Homogeneous - Heterogeneous

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

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

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

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

8. OLAP data storage measure

9. Used to modify a Report

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

28. Using the Prompt Generation Wizard - Inside the Report Editor

29. ID columns - Description columns - Fact columns

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

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

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

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

34. Template - Filter - View of a Report

35. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions

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

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

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

39. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h

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

41. Schema Objects - Application Objects - Configuration Objects

42. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse

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

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

45. Less storage - Simple SQL - Complex ETL

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

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

48. Attribute Creation Wizard - Attribute Editor

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

50. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.