ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam
Go to Exam

Exam 70-462 topic 3 question 4 discussion

Actual exam question from Microsoft's 70-462
Question #: 4
Topic #: 3
[All 70-462 Questions]

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server database named Contoso on a server named Server01.
You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01.
What should you create?

  • A. A Database Audit Specification
  • B. A Policy
  • C. An Alert
  • D. A SQL Profiler Trace
  • E. A Resource Pool
  • F. An Extended Event session
  • G. A Server Audit Specification
Show Suggested Answer Hide Answer
Suggested Answer: G 🗳️
Reference:
http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx
by Fame at Sept. 12, 2020, 5:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Fame
4 years, 8 months ago
G. A Server Audit Specification
upvoted 1 times
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago