In order to comply with CCPA and GDPR regulations, a company must delete PII data without losing the ability to perform statistical analysis on historical data. Each Delta table contains both PII and non-PII data. Which technique should the company use to remove PII data while preserving analytical capabilities?

Real Exam

Drop the PII columns from the Delta tables and store their data in a shared location for the compliance team.

11.8%

Perform a DELETE operation followed by a VACUUM operation on all the Delta tables.

10.6%

Anonymize data in PII columns.

60.0%

Use ACLs to set permissions on different columns.

12.9%

Do not delete the PII data from the tables, as it may affect the performance of SQL queries over the Delta tables.

4.7%

Databricks Certified Data Engineer - Professional