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. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






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






5. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






6. AND - OR - OR NOT - AND NOT






7. More storage - Complex SQL - Simple ETL






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






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






10. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






11. Folder List - Object Viewer - Shortcut Bar






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






13. Used to "fine-tune" your Project






14. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






16. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






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






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






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






21. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






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






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






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






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






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






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






29. What tool do you use to create the Metadata DSN connection?






30. It contains the ID column of the parent attribute






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






32. Must have Subtotals enabled - or you won't see any data for higher-level attributes






33. Primary keys






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






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






36. View Filters can only ___________.






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






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






39. Less storage - Simple SQL - Complex ETL






40. OLTP retains data ________






41. Facts - Attributes - Hierarchies






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






43. A shortcut to an existing Object in a Project






44. You can _____________ in the Architect Graphical Interface.






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






46. Level of OLAP integration






47. Compound - Homogeneous - Heterogeneous






48. Attribute Creation Wizard - Attribute Editor






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






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