A junior data engineer is migrating a workload from a relational database system to the Databricks Lakehouse. The source system uses a star schema, leveraging foreign key constraints and multi-table inserts to validate records on write.
Which consideration will impact the decisions made by the engineer while migrating this workload?
When migrating a workload from a relational database system to the Databricks Lakehouse, it is important to note that Databricks does not enforce foreign key constraints. While Databricks leverages Delta Lake, which ensures ACID compliance for transactions within a single table, it does not support foreign key constraints. The lack of foreign key enforcement will impact how the engineer handles data integrity and relationships between tables during the migration.
D is correct