Exam 70-764 topic 1 question 24 discussion

HOTSPOT -
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table.

You need to configure auditing for the Adventure Works environment.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Suggested Answer:
Box 1: CREATE SERVER AUDIT -
Create the server audit.
You must implement auditing to record access to data that is considered sensitive by the company.

Create database audit -

Box 2: ALTER SERVER AUDIT -
Enable the server audit.

Box 3: CREATE DATABASE AUDIT -
Create the database audit specification.

Box 4: FOR SERVER AUDIIT -
You must implement auditing for all objects in the ADVSchema.
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification