Question

A data privacy solutions engineer discovers that a marketing analytics team routinely exports customer datasets from the production data warehouse into ad-hoc spreadsheets and personal cloud drives to build campaign models. Each export creates uncontrolled copies of personal data that persist indefinitely, outside any retention schedule or access control. Which action should the engineer prioritize to address the underlying data persistence risk?

Accepted Answer

Provide analysts a governed analytics environment where queries run against controlled datasets without exporting raw personal data, and disable local export capability

Answer

Encrypt all exported spreadsheets and personal cloud drive folders used by the marketing team

Answer

Issue a policy reminder instructing analysts to delete exported files within 30 days of use

Answer

Increase the retention period in the data warehouse so analysts do not need to keep local copies