
Ultimate access to all questions.
Delta Lake provides support for several types of constraints, yet foreign key enforcement is notably absent. Why is this the case, and how should data engineers handle referential integrity within a Delta Lake architecture?
A
Delta Lake handles referential integrity automatically by leveraging its underlying ACID transaction layer.
B
Foreign key enforcement is supported but requires manual activation via Spark configuration settings.
C
Delta Lake focuses on row-level constraints; therefore, developers must manage and enforce referential integrity programmatically within their data pipelines.
D
The primary key support in Delta Lake is designed to inherently replace the need for traditional relational foreign keys.