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. Level of OLAP integration






2. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






5. Grid View - Graph View - Grid/Graph View - SQL View






6. Used to "fine-tune" your Project






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






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






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






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






11. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






18. The actual column name for a fact. Every fact must have at least 1 expression.






19. User requirements - Existing source data - Technical and performance considerations






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






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






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






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






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






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






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






27. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






29. It contains the ID and DESC columns of all higher-level attributes






30. More storage - Complex SQL - Simple ETL






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






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






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






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






35. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






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






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






40. Primary keys






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






42. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






44. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






45. Enables you to select and display subsets of a report as separate pages.






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






47. Must have a one-to-one relationship with all other forms.






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






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






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