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. Extraction - transformation - loading






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






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






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






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






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






7. Reduced number of JOINS in the generated SQL






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






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






10. It contains the ID column of all higher-level attributes






11. Descriptive data that provides context for Facts.






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






13. You can _____________ in the Architect Graphical Interface.






14. All Attributes must have an _______.






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






16. Attribute Creation Wizard - Attribute Editor






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






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






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






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






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






22. OLAP retains data ________






23. All report-level options overwrite ___________.






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






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






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






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






28. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






31. Tables - Facts - Attributes - Hierarchies






32. Create the Project Source - Create the Database Instance






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






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






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






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






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






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






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






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






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






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






43. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






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






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






47. Level of OLTP integration






48. Grid View - Graph View - Grid/Graph View - SQL View






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






50. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships