Exam 70-764 topic 1 question 128 discussion

Actual exam question from Microsoft's 70-764

Question #: 128
Topic #: 1

You administer a Microsoft SQL Server 2016 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

Suggested Answer: G 🗳️
The SQL Server Audit feature enables you to audit server-level and database-level groups of events and individual events.
Audits can have the following categories of actions:
Server-level. These actions include server operations, such as management changes and logon and logoff operations.
Database-level. These actions encompass data manipulation languages (DML) and data definition language (DDL) operations.
Audit-level. These actions include actions in the auditing process.
References: http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx

by norbert1 at Sept. 10, 2020, 12:14 p.m.

Comments

Submit Cancel

norbert1

4 years, 10 months ago

ok..;-) --> In the Audit destination dropdown menu, you can choose to write the SQL audit trail to a file or to audit events in the Windows Security log or Application event log.

upvoted 1 times

huzein

4 years, 8 months ago

Yes, but you set it when creating a SQL Server Audit, not when creating a Server Audit Specification. Bad formulated question and answers.

upvoted 1 times

...

norbert1

4 years, 10 months ago

i have some kind of doubt - often i saq for auditin you specify a separate file - its not logged into OS Application LOG.. unfortunately i have not gone through autiting in practice until now.. has anyone..?

upvoted 1 times

...