Câu 76: Databricks Certified Data Engineer Professional

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?

1. A. Databricks only allows foreign key constraints on hashed identifiers, which avoid collisions in highly-parallel writes.
2. B. Databricks supports Spark SQL and JDBC; all logic can be directly migrated from the source system without refactoring.
3. C. Committing to multiple tables simultaneously requires taking out multiple table locks and can lead to a state of deadlock.
4. D. All Delta Lake transactions are ACID compliant against a single table, and Databricks does not enforce foreign key constraints. — đáp án hiện tại
5. E. Foreign keys must reference a primary key field; multi-table inserts must leverage Delta Lake’s upsert functionality.