Microsoft
70-457 · Question #169
You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which…
The correct answer is D. SERVER_ROLE_MEMBER_CHANGE_GROUP. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 database. You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin. Which server-level audit action group should you use?
Options
- ASERVER_STATE_CHANGE_GROUP
- BSERVER_PRINCIPAL_IMPERSONATION_GROUP
- CSUCCESSFUL_LOGIN_GROUP
- DSERVER_ROLE_MEMBER_CHANGE_GROUP
How the community answered
(37 responses)- A3% (1)
- B14% (5)
- C5% (2)
- D78% (29)
Community Discussion
No community discussion yet for this question.