单项选择题
Youneedtodefineanauthenticationsystemforthemainofficedatabaseadministrators.Thesetupshouldrequiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）
A.CreateaSQLServerloginwithWindowsAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothedb_ownerroleineachdatabase.
B.CreateaSQLServerloginwithSQLServerAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothesysadminrole.
C.CreateaWindowsglobalgroupnamedDBAdmins.Addeachmainofficedatabaseadministrator’s WindowsuseraccounttotheWindowsDBAdminsgroup.CreateaSQLServerloginwithWindowsAuthenticationforthegroup.Addthegrouptotheserveradminfixedserverrole.
D.Addeachmainofficedatabaseadministrator’sWindowsuseraccounttotheWindowsSQLManagersgroup.
A.Thesetupshouldrequiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）
A.CreateaSQLServerloginwithWindowsAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothedb_ownerroleineachdatabase.
B.CreateaSQLServerloginwithSQLServerAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothesysadminrole.
C.CreateaWindowsglobalgroupnamedDBAdmins.Addeachmainofficedatabaseadministrator’s
D.CreateaSQLServerloginwithWindowsAuthenticationforthegroup.Addthegrouptotheserveradminfixedserverrole.
E.Addeachmainofficedatabaseadministrator’sWindowsuseraccounttotheWindowsSQLManagersgroup.
