Microsoft Azure Data Engineer Associate - DP-203
Get started today
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?
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?
Simulated
Explanation:
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.