Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Consider a scenario where you need to implement a Delta Lake table to store customer data. The table should prevent the insertion of bad data. Which approach would you use to add constraints to the Delta Lake table and why?

Simulated

Use primary keys and foreign keys to enforce data integrity.

Apply CHECK constraints to the Delta Lake table to prevent bad data.

Implement a pre-processing step to filter out bad data before insertion.

Use a combination of primary keys and CHECK constraints.

Explanation:

Option B is correct because Delta Lake supports CHECK constraints directly, which can be used to enforce data quality rules at the time of data insertion, preventing bad data from being written to the table.

Powered ByGPT-5.2

Comments

Loading comments...