ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

Exam Certified Data Engineer Professional topic 1 question 32 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 32
Topic #: 1
[All Certified Data Engineer Professional Questions]

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source tables has been de-duplicated and validated, which statement describes what will occur when this code is executed?

  • A. A batch job will update the enriched_itemized_orders_by_account table, replacing only those rows that have different values than the current version of the table, using accountID as the primary key.
  • B. The enriched_itemized_orders_by_account table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.
  • C. An incremental job will leverage information in the state store to identify unjoined rows in the source tables and write these rows to the enriched_iteinized_orders_by_account table.
  • D. An incremental job will detect if new rows have been written to any of the source tables; if new rows are detected, all results will be recalculated and used to overwrite the enriched_itemized_orders_by_account table.
  • E. No computation will occur until enriched_itemized_orders_by_account is queried; upon query materialization, results will be calculated using the current valid version of data in each of the three tables referenced in the join logic.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by sturcu at Oct. 16, 2023, 11:57 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
arekm
3 months, 2 weeks ago
Selected Answer: B
B - it is a batch overwrite, which means: whatever was there is gone.
upvoted 1 times
...
nedlo
5 months, 3 weeks ago
Selected Answer: B
i agree. Cannot be E because write itself is action
upvoted 1 times
...
AndreFR
8 months ago
Selected Answer: B
B because code has : .mode(“Overwrite”)
upvoted 1 times
...
imatheushenrique
10 months, 2 weeks ago
B is correct
upvoted 1 times
...
AziLa
1 year, 2 months ago
Correct Ans is B
upvoted 2 times
...
Jay_98_11
1 year, 3 months ago
Selected Answer: B
correct
upvoted 2 times
...
sturcu
1 year, 6 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago