nerdexam
Microsoft

70-473 · Question #41

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine. You need to ensure that all SQL Server audits are written to the Windows Security log. Which two actions should you

The correct answer is B. Assign the Generate security audits user right. C. Configure the Audit object access policy.. https://msdn.microsoft.com/en-us/library/cc645889.aspx

Design and implement data security

Question

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine. You need to ensure that all SQL Server audits are written to the Windows Security log. Which two actions should you perform? Each correct answer presents part of the solution.

Options

  • AConfigure the Audit policy change policy.
  • BAssign the Generate security audits user right.
  • CConfigure the Audit object access policy.
  • DAssign the Log on as a service user right.
  • EConfigure the Audit the access of global system objects policy.

How the community answered

(52 responses)
  • A
    27% (14)
  • B
    58% (30)
  • D
    10% (5)
  • E
    6% (3)

Explanation

https://msdn.microsoft.com/en-us/library/cc645889.aspx

Topics

#SQL Server auditing#Windows Security log#Group Policy#Security policy

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice