🔥 3-day streak
Microsoft Azure Database Administrator Associate52 / 144
Question 52 of 144

You manage an Azure SQL Managed Instance hosting an OLTP database. The compliance team requires a downstream ETL process to incrementally extract all INSERT, UPDATE, and DELETE operations made to a Customers table, including the actual column values before and after each change. The solution must retain the historical change data in system tables that the ETL job can query on a schedule, without modifying the application or the Customers table schema. Which feature should you enable?

Reviewed for accuracy · Report an issueNext question