HOTSPOTNote: 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:
Answer: 
Explanation:
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.
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-auditand-database-audit-specification