How can you configure a Delta Lake table ingesting records from multiple Kafka topics (with schema: key BINARY, value BINARY, topic STRING, partition LONG, offset LONG, timestamp LONG) to meet these requirements:

Restrict access to PII data (only present in the "registration" topic)

Retain PII records for only 14 days

Retain non-PII records indefinitely (5 unique topics are being ingested)?

Exam-Like

All data should be deleted biweekly; Delta Lake's time travel functionality should be leveraged to maintain a history of non-PII information.

15.1%

Data should be partitioned by the registration field, allowing ACLs and delete statements to be set for the PII directory.

17.6%

Data should be partitioned by the topic field, allowing ACLs and delete statements to leverage partition boundaries.

58.0%

Separate object storage containers should be specified based on the partition field, allowing isolation at the storage level.

9.2%

Databricks Certified Data Engineer - Professional