How should you complete the Transact-SQL statement?

HOTSPOT

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:

View Answer

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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-auditand-database-audit-specification