The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P140: 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. | Index 677 XML indexing ALTER INDEX usage 483 primary creation 482 secondary type 482 SQL Server 2008 480 syntax 483 usage 483 using ALTER INDEX to DISABLE 483 using DROP INDEX 484 XML path language expression types for 505-506 SQL Server 2008 506 World Wide Web Consortium 504 @XMLTable 506 XML_Table 481-482 XPath expression count 507 XPath number function 507-508 XQuery language 497-498 XQuery method 500-501 Appendix The Real MCTS SQL Server 2008 Exam 432 Self Test Appendix 1 2 Appendix Self Test Appendix Chapter 1 New Features in SQL Server 2008 1. You are setting up security for your new SQL Server 2008 installation. Management is concerned about security. What approach should you take to ensure security settings are optimal A. Use the Surface Area Configuration Tool to secure the installation B. Use the new Security Analysis tool to secure the installation C. Use SQL Server Configuration Manager to secure the installation D. Use Windows Service Manager to enable and disable the appropriate services The correct answer is C. On the Start menu point to All Programs Microsoft SQL Server 2008 Configuration Tools SQL Server Configuration Manager. Answer A is incorrect because the Surface Area Configuration Tool is no longer used to secure SQL Server 2008. Answer B is incorrect because there is no Security Analysis tool in SQL Server 2008. While Answer D may work it s not the best answer. Your answer should be the most correct using the new features even though some of the other answers may technically work. 2. You have been tasked with setting up standards for your SQL Server 2008 installation. You need to enforce a table naming convention. What is the best way to accomplish this in your SQL Server 2008 environment A. Use Windows Group Policy B. Create DDL Triggers C. Create DML Triggers D. Create a Declarative Management Framework policy The correct answer is D. This is the most efficient way to accomplish the task of enforcing a table naming convention. Answer A is
