CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #68
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
All records from an Apache Kafka producer are being ingested into a single Delta Lake table with the following schema: key BINARY, value BINARY, topic STRING, partition LONG, offset LONG, timestamp LONG There are 5 unique topics being ingested. Only the "registration" topic contains Personal Identifiable Information (PII). The company wishes to restrict access to PII. The company also wishes to only retain records containing PII in this table for 14 days after initial ingestion. However, for non-PII information, it would like to retain these records indefinitely. Which of the following solutions meets the requirements?
Options
- AAll data should be deleted biweekly; Delta Lake's time travel functionality should be leveraged to
- BData should be partitioned by the registration field, allowing ACLs and delete statements to be set
- CBecause the value field is stored as binary data, this information is not considered PII and no
- DSeparate object storage containers should be specified based on the partition field, allowing
- EData should be partitioned by the topic field, allowing ACLs and delete statements to leverage
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.