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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






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






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






9. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






10. Folder List - Object Viewer - Shortcut Bar






11. Used to modify a Report






12. AND - OR - OR NOT - AND NOT






13. The System Hierarchy is automatically updated whenever you make a change to an __________________.






14. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






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






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






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






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






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






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






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






24. Primary keys






25. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






26. Using the Prompt Generation Wizard - Inside the Report Editor






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






28. Simple - Compound - Nested - Derived






29. OLAP data storage measure






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






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






32. Reduced number of JOINS in the generated SQL






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






34. Descriptive data that provides context for Facts.






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






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






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






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






39. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






40. Compound - Homogeneous - Heterogeneous






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






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






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






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






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






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






47. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






48. Level of OLTP integration






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






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