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. OLTP retains data ________






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






3. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






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






6. Level of OLTP integration






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






8. A shortcut to an existing Object in a Project






9. Used to modify a Report






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






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






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






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






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






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






16. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






17. View Filters are saved with the _____________.






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






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






20. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






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






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






25. Prompts to select a single value on which to qualify a date - number or text string.






26. More storage - Complex SQL - Simple ETL






27. Must have Subtotals enabled - or you won't see any data for higher-level attributes






28. All report-level options overwrite ___________.






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






30. It contains links to specific folders in the Folder List






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






32. Reduced number of JOINS in the generated SQL






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






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






35. Extraction - transformation - loading






36. Descriptive data that provides context for Facts.






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






38. Compound - Homogeneous - Heterogeneous






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






40. Simple - Compound - Nested - Derived






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






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






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






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






45. Used to "fine-tune" your Project






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






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






48. Attribute Creation Wizard - Attribute Editor






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






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