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. Create the Project Source - Create the Database Instance






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






3. Template - Filter - View of a Report






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






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






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






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






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






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






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






11. You can _____________ in the Architect Graphical Interface.






12. Using the Prompt Generation Wizard - Inside the Report Editor






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






14. OLAP retains data ________






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






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






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






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






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






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






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






22. Used to modify a Report






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






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






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






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






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






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






29. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






31. Used to "fine-tune" your Project






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






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






34. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






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






39. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






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






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






45. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






46. All Attributes must have an _______.






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






48. Formula - Level (Dimensionality) - Conditionality - Transformation






49. Used for - Initially populating the Metadata - Creating schema objects






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