The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P65: 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. | 302 Chapter 7 Maintaining Your Database 3. You have a very large table named PhoneSurvey. The table contains a Question column and an Answer column both of type char 1000 . Many questions are similar or the same. Many answers are very similar. Many questions re-phrase the answers. Additionally many values in the answer column are null. The table resides on a high-performance system and you are not concerned about query performance. What is the best way to reduce the size of this table as much as possible choose all that apply A. ALTER TABLE PhoneSurvey REBUILD WITH DATA_ COMPRESSION ROW B. ALTER TABLE PhoneSurvey ALTER COLUMN Answer ADD SPARSE C. ALTER TABLE PhoneSurvey ALTER COLUMN Question ADD SPARSE D. ALTER TABLE PhoneSurvey REBUILD WITH DATA_ COMPRESSION PAGE 4. Your organization is worried about the security risks of Database Mail and SQL Mail. You are asked to verify that all servers in your organization have these features disabled. If not you must disable the feature on those servers that don t have it enabled as soon as possible. What is the best way to accomplish this task with minimum administrative effort A. Use Policy-Based Management to create a policy condition for the Server Configuration facet SQLMailEnabled False OR DatabaseMailEnabled False. Create a policy linking this condition with a target set. Evaluate the policy to identify servers that don t comply with this policy. After evaluating the policy apply the policy to reconfigure any noncompliant servers. B. Use Policy-Based Management to create a policy condition for the Server Configuration facet SQLMailEnabled False AND DatabaseMailEnabled False. Create a policy linking this condition with a target set. Evaluate the policy to identify servers that don t comply with this policy. After evaluating the policy apply the policy to reconfigure any noncompliant servers. C. Use Policy-Based Management to create a policy with no conditions. Choose to apply this policy to a target set defined by the .
