Test your basic knowledge |

Certified Project Designer Cpd

Instructions:
  • 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. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






2. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






3. You must select "Other directions" when drilling attributes while viewing a report






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






5. Attribute Creation Wizard - Attribute Editor






6. A shortcut to an existing Object in a Project






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






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






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






10. It contains links to specific folders in the Folder List






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






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






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






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






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






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






17. Primary keys






18. Simple - Derived






19. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






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






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






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






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






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






26. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






28. Simple - Compound - Nested - Derived






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






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






31. OLTP data storage measure






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






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






34. Top menu/dropdowns - Toolbar - Right-click popup menus






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






36. Subtotals reflect accumulations at selected attribute levels






37. All report-level options overwrite ___________.






38. Extraction - transformation - loading






39. Specifies what info to retrieve from a data-warehouse - and how to display it






40. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






42. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






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






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






47. Used to limit a possibly overwhelming set of potential prompt answers






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






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






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