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. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






3. Tables - Facts - Attributes - Hierarchies






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






5. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






8. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






10. OLTP data storage measure






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






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






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






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






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






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






17. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






19. All Attributes must have an _______.






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






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






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






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






24. Used to modify a Report






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






26. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






27. A shortcut to an existing Object in a Project






28. Folder List - Object Viewer - Shortcut Bar






29. Level of OLAP integration






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






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






32. Used to "fine-tune" your Project






33. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






35. Less storage - Simple SQL - Complex ETL






36. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






38. Primary keys






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






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






41. View Filters are saved with the _____________.






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






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






44. Create the Project Source - Create the Database Instance






45. Specifies what info to retrieve from a data-warehouse - and how to display it






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






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






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






49. OLAP retains data ________






50. OLTP retains data ________