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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






4. Level of OLTP integration






5. What tool do you use to create the Metadata shell?






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






7. Less storage - Simple SQL - Complex ETL






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






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






10. View Filters can only ___________.






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






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






13. Facts - Attributes - Hierarchies






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






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






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






17. OLAP data storage measure






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






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






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






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






22. Groupings of directly related attributes. Also commonly known as "dimensions".






23. Extraction - transformation - loading






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






25. Grid View - Graph View - Grid/Graph View - SQL View






26. ID columns - Description columns - Fact columns






27. Simple - Derived






28. OLAP retains data ________






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






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






31. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






32. Used to "fine-tune" your Project






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






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






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






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






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






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






39. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






41. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






42. All report-level options overwrite ___________.






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






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






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






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






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






48. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






49. OLTP retains data ________






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