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. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






3. Simple - Derived






4. View Filters are saved with the _____________.






5. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






7. More storage - Complex SQL - Simple ETL






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






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






10. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






13. Template - Filter - View of a Report






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






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






16. Used to "fine-tune" your Project






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






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






19. Columns - Tables






20. Metrics that perform multiple aggregations; one calculation inside of another.






21. OLAP retains data ________






22. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






23. Descriptive data that provides context for Facts.






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






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






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






27. Tables - Facts - Attributes - Hierarchies






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






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






30. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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






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






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






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






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






36. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






38. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






41. OLAP data storage measure






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






43. The unique values of an attribute obtained from the data-warehouse






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






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






46. All Attributes must have an _______.






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






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






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






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