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. How users can share comments for reports to other users

2. A Project Source can house ________ . A single Metadata can be used by multiple Projects.

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

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

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

6. Used to "fine-tune" your Project

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

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

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

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

11. An environment in which the MSTR Desktop connects directly to the Metadata database.

12. More storage - Complex SQL - Simple ETL

13. Level of OLTP integration

14. The Attribute Form maps to the same column name in multiple tables

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

16. OLTP retains data ________

17. Folder List - Object Viewer - Shortcut Bar

18. Store info about attributes - including IDs and any descriptions. Used for easier browsing.

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

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

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

22. Attribute Creation Wizard - Attribute Editor

23. Simple - Derived

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

25. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations

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

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

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

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

30. Primary keys

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

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

33. Simple - Compound - Nested - Derived

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

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

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

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

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

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

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

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

42. All report-level options overwrite ___________.

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

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

45. View Filters are saved with the _____________.

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

47. All Attributes must have an _______.

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

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

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