The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P164: 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. | 120 Appendix Self Test Appendix Correct Answer Explanation B. Answer B is correct. Using the CREATE VIEW WITH SCHEMABINDING option ensures that any table or column that the view depends on cannot be dropped or modified until the view itself is dropped. Incorrect Answers Explanations A C D. Answer A is incorrect because a CHECK constraint validates table data not structure. Answer C is incorrect because by default a view is not bound to the underlying table structure. Answer A is incorrect because a DDL trigger would be more complicated than using the WITH SCHEMABINDING option. 2. You have a view named YearlySales that lists all sales for the year. The reporting application your organization uses allows you to query the YearlySales view by CustomerName or by OrderDate. You receive unfavorable feedback from users that report generation is painfully slow. What is the best way to optimize report performance A. Create indexes on CustomerName and OrderDate columns. B. Create a UNIQUE constraint on CustomerName and OrderDate columns. C. Create a DEFAULT constraint on CustomerName and OrderDate columns. D. Create a full-text index on CustomerName and OrderDate columns. Correct Answer Explanation A. Answer A is correct because the index creates a lookup structure that maximizes search performance. Incorrect Answers Explanations B C D. Answer B is incorrect because a UNIQUE constraint would not improve search performance and also would not allow any customer to place an order twice. Answer C is incorrect because a DEFAULT constraint would not improve search performance. Answer D is incorrect because a full-text index is used with text fields containing a large amount of text data. It cannot be used with dates. 3. You have a very large table containing documents stored as a column of varbinary data type. The table is named Documents and is not referenced by FOREIGN KEY constraints. What is the most efficient way of removing all records from this table while leaving the table
