Posted by: Pdfprep
Post Date: November 12, 2020
HOTSPOT
You manage a Microsoft SQL Server instance that has a database named DB1. The instance has a server audit named Audit1. DB1 uses the following schemas:
You need to implement a database audit specification for database DB1 that meets the following requirements:
– Audit only delete statements performed by users in the db_datawriter role.
– Audit insert statements for all tables in Schema1 for all users.
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.
Answer: 
Leave a Reply