Answer-first summary for fast verification
Answer: Perform data deduplication during the ETL process (e.g., using `MERGE` or `dropDuplicates`) and apply `NOT NULL` constraints to identifying columns.
Delta Lake does not natively enforce primary key uniqueness constraints. To achieve primary key-like behavior, data engineers must ensure data integrity by deduplicating records before or during the write operation and enforcing `NOT NULL` constraints on the columns that comprise the logical primary key.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What approach can be used to simulate primary key enforcement in a Delta Lake table, given that traditional primary key constraints are not natively enforced at the engine level?
A
Apply foreign key references to maintain referential integrity across multiple tables.
B
Define the primary key constraint explicitly within the Delta schema's metadata for automatic enforcement.
C
Utilize a combination of NOT NULL and UNIQUE constraints within the table definition during creation.
D
Perform data deduplication during the ETL process (e.g., using MERGE or dropDuplicates) and apply NOT NULL constraints to identifying columns.
No comments yet.