The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P151: 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 55 D. Examine the contents of C Program Files Microsoft SQL Server MSSQL LOG file. Correct Answers Explanations B and C. Both of these approaches will show you the Maintenance Plan history. Incorrect Answers Explanations A and D. Answer A is incorrect because maintenance plans are a feature of the Maintenance container in SQL Server Management Studio Object Browser not a feature of SQL Server Agent. Answer D is incorrect because file does not contain maintenance plan history. 8. Your organization has recently hired a new DBA named Keith. You ask Keith to optimize the maintenance plan you have configured for the ERP database. A few hours later Keith calls you and explains that he cannot see the Maintenance Plans option in the Management folder in SQL Server Management Studio. What is likely to be the problem A. Keith is not a member of the db_owner role for the ERP database. B. Keith is not a member of the sysadmins server role. C. Keith is not a member of the serveradmins server role. D. Keith is connected to SQL Server with a SQL Server login not a Windows Integrated login. Correct Answer Explanation B. You must be a member of the fixed sysadmin server roles to see maintenance plans in the Object Explorer Incorrect Answers Explanations A C and D. Answers A and C are incorrect because it is irrelevant whether Keith is a db_owner for the ERP database or a serveradmin. He must be a sysadmin to see maintenance plans. Answer D is incorrect because users with SQL Server logins or Windows Integrated logins can be members of the sysadmin server role and hence can view and modify Maintenance Plans. 9. A flood in the server room has rendered your primary SQL Server in Washington inoperable and you must wait at least a week for replacement hardware. In the meantime you must prepare a customer activity report based on the Sales database. You restore the Sales database to a SQL Server in Moscow. You know that the .
