The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P146: 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. | 30 Appendix Self Test Appendix section. Answers A B and D are incorrect since these tools do not provide access to change this configuration. 13. When you change the Authentication Mode what action do you need to perform before the mode change takes effect A. Reboot the server operating system. B. Lock out all the database users. C. Restart SQL Server Agent. D. Restart the SQL Server Instance. The correct answer is D. You need to restart the SQL Server instance in order for an authentication mode change to take effect. Answer A is incorrect since although rebooting the server operating system will shut down SQL Server and start it when the operating system cycles back up it is not necessary to do this. Answers B and C are incorrect since taking either of these actions will not cause the authentication mode to change. 14. Jose has ownership of database tables in database A and database B both of which reside in the same instance of SQL Server where cross database ownership chaining has been enabled. Jose uses a database view in database A to join both tables in order to retrieve the needed data. Jose grants Jack permission to use her database view. What other permissions need to be granted in order for Jack to retrieve data using Jose s view A. Jack needs to be granted read permissions to the table in database B that is used by the view. B. Since cross database ownership chaining is enabled in this instance no additional permissions need to be granted. C. The tables used by the view in database A and B need read permissions granted to Jack. D. Jack cannot use Jose s view since she is the owner. Jack will need his own view and permissions. The correct answer is B. With cross database ownership chaining credentials are only checked on the first object request. Since Jack was granted permission by the object s owner Jose s credentials will be used to access the tables in database B. Answer A is incorrect since Jack was granted permission to the view by the object owner
