Answer-first summary for fast verification
Answer: Anonymize data in PII columns.
The correct approach is to anonymize the data in the PII columns. Anonymization transforms the data in such a way that it cannot be recreated, thus complying with CCPA and GDPR without losing the ability to perform statistical analysis on historical data. More Info: Anonymizing PII Data
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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?
A
Drop the PII columns from the Delta tables and store their data in a shared location for the compliance team.
B
Perform a DELETE operation followed by a VACUUM operation on all the Delta tables.
C
Anonymize data in PII columns.
D
Use ACLs to set permissions on different columns.
E
Do not delete the PII data from the tables, as it may affect the performance of SQL queries over the Delta tables.
No comments yet.