Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

PII Deletion From a Data Lake

HardPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is PII Deletion From a Data Lake. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

How would you delete PII from a data lake based on requests to do so?

Describe a practical Databricks design covering request intake, identity resolution, data discovery, deletion across Delta Lake tables and derived datasets, and verification. Explain how you would handle partitioned data, streaming and batch pipelines, backups, late-arriving records, retries, auditability, and preventing deleted records from being reintroduced. Discuss appropriate use of Unity Catalog, Delta Lake, Databricks Workflows, and data lineage. State the assumptions, deletion SLA, retention constraints, and evidence required to demonstrate completion.