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. A user interface for creating and maintaining a BI environment






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






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






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






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






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






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






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






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






10. Used to "fine-tune" your Project






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






12. Specifies a condition data must meet in order to be included in a report






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






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






15. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






16. Metrics aggregate on the lowest-level attribute __________.






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






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






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






20. It contains the ID column of the parent attribute






21. AND - OR - OR NOT - AND NOT






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






23. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






24. Simple - Compound - Nested - Derived






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






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






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






28. Level of OLAP integration






29. View Filters are saved with the _____________.






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






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






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






33. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






35. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






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






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






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






40. All report-level options overwrite ___________.






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






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






43. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






44. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






45. Columns - Tables






46. ID columns - Description columns - Fact columns






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






48. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






49. Simple - Derived






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