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. Metrics aggregate on the lowest-level attribute __________.

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

3. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies

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

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

6. Attribute Creation Wizard - Attribute Editor

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

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

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

10. A shortcut to an existing Object in a Project

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

12. Less storage - Simple SQL - Complex ETL

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

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

15. Simple - Compound - Nested - Derived

16. All Attributes must have an _______.

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

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

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

20. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.

21. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.

22. Specifies a condition data must meet in order to be included in a report

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

24. The logical associations between attributes that exist based on a business rule

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

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

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

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

29. Allow you to interact with the BI system - logically organize data to analyze complex relationships

30. User management - Security profiles - Server parameters - like report length - idle time and report prioritization

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

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

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

34. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface

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

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

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

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

39. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data

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

41. Used to modify a Report

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

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

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

45. Groupings of directly related attributes. Also commonly known as "dimensions".

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

47. Create the Project Source - Create the Database Instance

48. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.

49. Reduced number of JOINS in the generated SQL

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