Exam Certified Data Engineer Professional topic 1 question 159 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 159
Topic #: 1

[All Certified Data Engineer Professional Questions]

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?

A. Databricks only allows foreign key constraints on hashed identifiers, which avoid collisions in highly-parallel writes.
B. Foreign keys must reference a primary key field; multi-table inserts must leverage Delta Lake’s upsert functionality.
C. Committing to multiple tables simultaneously requires taking out multiple table locks and can lead to a state of deadlock.
D. All Delta Lake transactions are ACID compliant against a single table, and Databricks does not enforce foreign key constraints.

Show Suggested Answer

Suggested Answer: D 🗳️

by hpkr at June 12, 2024, 6:32 p.m.

Comments

Submit Cancel

lakime

4 months, 1 week ago

Selected Answer: D

Yes, D is correct, not enforced

upvoted 1 times

...

RandomForest

6 months ago

Selected Answer: D

D is correct as primary and foreign keys are informational only and are not enforced in databricks https://learn.microsoft.com/en-us/azure/databricks/tables/constraints

upvoted 1 times

...

hpkr

1 year, 1 month ago

Selected Answer: D

D is correct

upvoted 3 times

...