You administer a Microsoft SQL Server 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?
Suggested Answer:Explanation🗳️
The SERVER_ROLE_MEMBER_CHANGE_GROUP event is raised whenever a login is added or removed from a fixed server role. This event is raised for the sp_addsrvrolemember and sp_dropsrvrolemember stored procedures. Equivalent to the Audit Add Login to Server Role Event Class. Incorrect Answers: A. The SERVER_STATE_CHANGE_GROUP event is raised when the SQL Server service state is modified. Equivalent to the Audit Server Starts and Stops Event Class. B. The SERVER_PRINCIPAL_IMPERSONATION_GROUP event is raised when there is an impersonation within server scope, such as EXECUTE AS <login>. Equivalent to the Audit Server Principal Impersonation Event Class. C. The SUCCESSFUL_LOGIN_GROUP Indicates that a principal has successfully logged in to SQL Server. Events in this class are raised by new connections or by connections that are reused from a connection pool. Equivalent to the Audit Login Event Class. References: http://technet.microsoft.com/en-us/library/cc280663.aspx
This section is not available anymore. Please use the main Exam Page.70-462 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Fame
4 years, 8 months agoSelam
5 years, 3 months ago