YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1isamemberofaMicrosoftActiveDirectorydomain.Youdonothaveanyrightsorprivilegestoperformdomainadministration.However,youhavebeengrantedmembershipinthelocalAdministratorsgrouponSQL1.YouperformmostofthemanagementofSQL1fromyouradministrativeworkstation.However,forsecurityreasons,youwanttotrackallattemptsforinteractivelogonsandnetworkconnectionstoSQL1.Whatshouldyoudo?()A.CreateaGroupPolicyobject(GPO)thatisconfiguredforsuccessandfailureauditingoftheAuditaccountlogoneventssetting.AskthedomainadministratortolinktheGPOtotheobjectcontainingSQL1.B.ConfiguretheSQLServerserviceonSQL1toauditallsuccessfulandfailedlogonattempts.C.EditthelocalsecuritypolicyofSQL1.Then,configuresuccessandfailureauditingontheAuditlogoneventssetting.D.RuntheSQLServerProfileranduseastandarddefaulttemplate.
YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1isamemberofaMicrosoftActiveDirectorydomain.Youdonothaveanyrightsorprivilegestoperformdomainadministration.However,youhavebeengrantedmembershipinthelocalAdministratorsgrouponSQL1.YouperformmostofthemanagementofSQL1fromyouradministrativeworkstation.However,forsecurityreasons,youwanttotrackallattemptsforinteractivelogonsandnetworkconnectionstoSQL1.Whatshouldyoudo?()
A.CreateaGroupPolicyobject(GPO)thatisconfiguredforsuccessandfailureauditingoftheAuditaccountlogoneventssetting.AskthedomainadministratortolinktheGPOtotheobjectcontainingSQL1.
B.ConfiguretheSQLServerserviceonSQL1toauditallsuccessfulandfailedlogonattempts.
C.EditthelocalsecuritypolicyofSQL1.Then,configuresuccessandfailureauditingontheAuditlogoneventssetting.
D.RuntheSQLServerProfileranduseastandarddefaulttemplate.