Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Deep dive into the quiz with AI chat providers.

We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.

Consider a scenario where you need to implement a Delta Lake table to store transaction data. The table should enforce data quality rules such as ensuring that transaction amounts are positive. How would you add constraints to the Delta Lake table to achieve this?

Simulated

Use primary keys and foreign keys to enforce data quality rules.

Apply CHECK constraints to the Delta Lake table to ensure transaction amounts are positive.

Implement a pre-processing step to filter out invalid transaction amounts 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 specific data quality rules at the time of data insertion, ensuring that transaction amounts are positive.

Powered ByGPT-5.2

Comments

Loading comments...