Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.