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 Project Source can house ________ . A single Metadata can be used by multiple Projects.






2. What tool do you use to create the Metadata DSN connection?






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






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






5. Compound - Homogeneous - Heterogeneous






6. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






9. Columns - Tables






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






11. Simple - Derived






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






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






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






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






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






17. Direct: 2-tier - Server: 3-tier






18. Schema Objects - Application Objects - Configuration Objects






19. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






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






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






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






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






26. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






27. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






29. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






32. Used to "fine-tune" your Project






33. Used to modify a Report






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






35. All Attributes must have an _______.






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






37. Grid View - Graph View - Grid/Graph View - SQL View






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






39. Simple - Compound - Nested - Derived






40. Creating multiple attributes quickly. Used during the initial project creation.






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






42. Facts - Attributes - Hierarchies






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






44. Primary keys






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






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






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






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






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






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