The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P141: 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. | Self Test Appendix Appendix 5 8. You want to enforce a standard naming convention for tables and stored procedures. Your company has two SQL Server 2008 servers and 60 SQL Server 2005 servers. You need to use the same solution on all servers. What s the best way to do this in SQL Server 2005 and SQL Server 2008 A. Create a DDL trigger for all servers B. Use the performance data warehouse C. Create DML triggers D. Use the SQL Server 2008 Declarative Management Framework The correct answer is A. This will work on SQL Server 2005 and SQL Server 2008 servers. While Answer D is correct the DMF will allow you to perform the task at hand only on SQL Server 2008 servers. Answer B has nothing to do with enforcing naming conventions. D will not allow you to perform the task of enforcing naming conventions. 9. You have a database table with a varchar 600 field in it. Most of the records in the table have a null value for this field. How can you save space A. Move the data into a second table B. Use sparse columns C. Install a third-party tool on the machine to compress the data D. Use the SQL Server 2008 Declarative Management Framework The correct answer is A. Sparse columns will take up less space for varchar columns. Sparse columns will take up less space for most columns but cannot be used for text ntext image timestamp user-defined data type geometry or geography or varbinary max with the FileStream attribute can be sparse. Answer C is incorrect this is not the best approach. Answer D is incorrect as the Declarative Management Framework will not save you space. 10. You have a database table with a FileStream field in it. Most of the records in the table have a null value for this field. What s the best way to save space A. Move the data into a second table B. Use sparse columns C. Use the SQL Server 2008 Declarative Management Framework D. None of the above 6 Appendix Self Test Appendix The correct answer is D. Answer A is incorrect this will not save space. Answer B is
