🔥 3-day streak
Microsoft Azure Database Administrator Associate140 / 144
Question 140 of 144

You manage an Azure SQL Database that stores employee salary records. The compliance team requires the ability to query the exact state of any row at any point in the past for historical auditing, without writing custom trigger-based logic. Deleted and updated rows must automatically retain their prior values with system-managed validity periods. Which feature should you implement?

Reviewed for accuracy · Report an issueNext question