Databricks Certified Data Engineer - Professional
Get started today
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.
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.
Explanation:
Option C is the correct answer because it accurately describes the native support for foreign key constraints in Delta Lake, which can be implemented using the ALTER TABLE statement. This approach is scalable, cost-effective, and complies with data governance policies by ensuring data integrity without the need for external systems or complex application logic. Options A and B suggest alternatives that either do not leverage Delta Lake's native capabilities or introduce unnecessary complexity and cost. Option D proposes a workaround that may not reliably ensure data integrity in all cases.