Answer-first summary for fast verification
Answer: Apply CHECK constraints to the Delta Lake table to ensure log entries are in the correct format.
Option B is correct because Delta Lake supports CHECK constraints directly, which can be used to enforce specific data quality rules at the time of data insertion, ensuring that log entries are in the correct format.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Consider a scenario where you need to implement a Delta Lake table to store log data. The table should enforce data quality rules such as ensuring that log entries are in the correct format. How would you add constraints to the Delta Lake table to achieve this?
A
Use primary keys and foreign keys to enforce data quality rules.
B
Apply CHECK constraints to the Delta Lake table to ensure log entries are in the correct format.
C
Implement a pre-processing step to filter out invalid log entries before insertion.
D
Use a combination of primary keys and CHECK constraints.
No comments yet.