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. The default entry-points.






2. View Filters are saved with the _____________.






3. A user interface for creating and maintaining a BI environment






4. Reduced number of JOINS in the generated SQL






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






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






7. OLAP data storage measure






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






9. A shortcut to an existing Object in a Project






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






11. Level of OLAP integration






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






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






14. View Filters can only ___________.






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






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






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






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






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






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






21. To define the level of aggregation for a specific metric - Used for qualifications






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






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






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






25. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






28. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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






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






35. Used to modify a Report






36. Tables - Facts - Attributes - Hierarchies






37. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


38. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






40. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






41. One that uses 2 or more columns as its ID






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






43. More storage - Complex SQL - Simple ETL






44. You can e-mail reports by going to _____






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






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






47. Create the Project Source - Create the Database Instance






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






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






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