Youneedtodefineanauthenticationsystemforthemainofficedatabaseadministrators.Thesetupshouldrequiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）
A.CreateaSQLServerloginwithWindowsAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothedb_ownerroleineachdatabase.
B.CreateaSQLServerloginwithSQLServerAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothesysadminrole.
C.CreateaWindowsglobalgroupnamedDBAdmins.Addeachmainofficedatabaseadministrator’s WindowsuseraccounttotheWindowsDBAdminsgroup.CreateaSQLServerloginwithWindowsAuthenticationforthegroup.Addthegrouptotheserveradminfixedserverrole.
D.Addeachmainofficedatabaseadministrator’sWindowsuseraccounttotheWindowsSQLManagersgroup.
参考答案：D
