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. Top menu/dropdowns - Toolbar - Right-click popup menus






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






3. More storage - Complex SQL - Simple ETL






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






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






6. Facts associated to different column names in 2 or more tables






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






8. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






10. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






13. Primary keys






14. OLTP data storage measure






15. You can _____________ in the Architect Graphical Interface.






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






17. The default entry-points.






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






19. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






22. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






23. View Filters are saved with the _____________.






24. AND - OR - OR NOT - AND NOT






25. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






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






29. A shortcut to an existing Object in a Project






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






31. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






34. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






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






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






38. Grid View - Graph View - Grid/Graph View - SQL View






39. ID columns - Description columns - Fact columns






40. Facts - Attributes - Hierarchies






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






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






43. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






45. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






47. Extraction - transformation - loading






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






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






50. A new tool for project design tasks - used for fine-tuning a project after initial creation