Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.