Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Delta Lake does not natively enforce foreign key constraints. Which of the following best explains why this is the case and how data engineers should handle referential integrity within a Databricks environment?
A
Delta Lake relies solely on ACID transactions to automatically resolve and maintain referential integrity across all tables in a workspace.
B
Foreign key enforcement is an optional metadata feature that must be enabled via Spark SQL configuration settings before it becomes active.
C
Delta Lake's support for primary keys automatically negates the requirement for foreign key constraints, as uniqueness is guaranteed by the storage layer.
D
Delta Lake focuses on row-level constraints; therefore, referential integrity across multiple tables must be managed programmatically by the development team within their ETL pipelines.