Answer-first summary for fast verification
Answer: Archive data older than seven years to cold storage and delete it from the active database.
Archiving data older than seven years to cold storage and then deleting it from the active database ensures compliance with legal retention requirements while also maintaining the security and performance of the active database. This approach balances the need for data retention with the need for efficient data management.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with implementing a data retention policy for an Azure SQL Database that contains financial data. The policy must ensure that data is retained for seven years as required by law, but also that older data is securely deleted after this period. How would you implement this policy?
A
Use Azure SQL Database's built-in backup and restore features to retain data for seven years.
B
Schedule regular data deletion jobs to remove data older than seven years from the database.
C
Archive data older than seven years to cold storage and delete it from the active database.
D
Encrypt data older than seven years and then delete the encryption keys to effectively destroy the data.
No comments yet.