Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineering team uses a pipeline to ingest Kafka source data into a Multiplex bronze table, partitioned by topic and month. A new engineer notices the 'user_activity' topic contains Personal Identifiable Information (PII) that must be deleted every two months per the company’s SLA. How can table partitioning assist in meeting this requirement?_
A
Table partitioning enables the immediate deletion of files without the need for the VACUUM command.
B
Table partitioning allows delete operations to utilize partition boundaries for efficiency.
C
Table partitioning decreases query latency during the deletion of large data files.
D
Table partitioning prevents time travel access to PII data post-deletion.
E
None of the above. Table partitioning does not support the specified requirement.