The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P10: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | New Features in SQL Server 2008 Chapter 1 27 16. Within your application you need to log all changes to one table. DDL and DML changes must be logged. What s the best approach to solve this problem A. Use the built-in auditing capability B. Create a DDL trigger C. Create a DML trigger D. This cannot be accomplished 17. You have a server that supports Hot Add CPU. The current CPU utilization is 95 to 100 percent most of the time. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed. What should you do A. Use the Hot Add CPU feature to add another CPU B. Use the Hot Add CPU feature to add two CPUs C. Add more memory to the server D. Schedule an outage and add another CPU to the server 18. You are contemplating using data compression on a table. You would like to know how much space this will save. How can you determine the savings A. View the table properties B. Enable compression then check the table size C. Use sp_estimate_data_compression_savings D. Use sp_check_compression 19. You have a server that supports Hot Add Memory. Performance is sluggish and you believe adding more memory will help. The server is mission-critical and cannot be shut down. SQL Server 2008 Standard Edition is installed. What should you do A. Use the Hot Add CPU feature to add another CPU B. Use the Hot Add CPU feature to add two CPUs C. Add more memory to the server. D. Schedule an outage and add memory to the server. 28 Chapter 1 New Features in SQL Server 2008 20. You have a SQL Server 2008 installation and you want to create a high-availability solution. What are the ideal approach es to solve this problem A. Backup and restore B. Replication C. Mirroring D. Clustering New Features in SQL Server 2008 Chapter 1 29 Self Test Quick Answer Key 1. C 11. A 2. D 12. A 3. B 13. D 4. B 14. B 5. B 15. B 6. B 16. A 7. D 17. D 8. A 18. C 9. A 19. D 10. D 20. C and
