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. It contains the ID column of the parent attribute






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






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






5. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






7. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






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






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






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






17. Homogeneous - Heterogeneous






18. A shortcut to an existing Object in a Project






19. Simple - Derived






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






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






22. Used to modify a Report






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






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






25. OLTP retains data ________






26. OLAP retains data ________






27. Schema Objects - Application Objects - Configuration Objects






28. Level of OLAP integration






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






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






31. Simple - Compound - Nested - Derived






32. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






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






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






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






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






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






42. Level of OLTP integration






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






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






45. Compound - Homogeneous - Heterogeneous






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. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






49. How users can share comments for reports to other users






50. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.