Databricks Certified Data Engineer - Professional
Comments
Loading comments...
Ultimate access to all questions.
In the context of data modeling using Delta Lake on Azure Databricks, a data engineer is tasked with designing a solution that ensures data integrity across related tables without relying on application logic. The solution must be scalable, cost-effective, and comply with organizational data governance policies. Considering these constraints, which of the following approaches BEST demonstrates how to implement foreign key constraints in Delta Lake to maintain data integrity? Choose the correct option from the four provided.
A
Foreign key constraints are not supported in Delta Lake, so data integrity must be enforced through application logic, which may increase development time and complexity.
B
Creating a Delta Lake table with foreign key constraints requires integrating a third-party library or external system, potentially introducing additional costs and complexity.
C
Delta Lake supports foreign key constraints natively, which can be defined using the ALTER TABLE statement to ensure data integrity without external dependencies.
D
Foreign key constraints can be simulated in Delta Lake using a combination of MERGE INTO and DELETE statements, but this approach may not fully guarantee data integrity under all scenarios.