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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






5. Primary keys






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






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






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






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






10. Simple - Derived






11. All Attributes must have an _______.






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






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






14. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






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






17. You can e-mail reports by going to _____






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






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






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






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






22. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






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






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






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






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






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






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






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






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






35. OLAP retains data ________






36. The Attribute Form maps to different column names in multiple tables






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






38. Extraction - transformation - loading






39. AND - OR - OR NOT - AND NOT






40. Less storage - Simple SQL - Complex ETL






41. Used to "fine-tune" your Project






42. Simple - Compound - Nested - Derived






43. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






44. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






46. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






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






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