Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Engineer Professional Exam - Topic 3 Question 52 Discussion

A data engineer is configuring Delta Sharing for a Databricks-to-Databricks scenario to optimize read performance. The recipient needs to perform time travel queries and streaming reads on shared sales data.Which configuration will provide the optimal performance while enabling these capabilities?
A) Share tables WITH HISTORY, ensure tables don't have partitioning enabled, and enable CDF before sharing.
B) Share tables WITHOUT HISTORY and enable partitioning for better query performance.
C) Share the entire schema WITHOUT HISTORY and rely on recipient-side caching for performance.
D) Use the open sharing protocol instead of Databricks-to-Databricks sharing for better performance.

Databricks Certified Data Engineer Professional Exam - Topic 3 Question 52 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Professional exam
Question #: 52
Topic #: 3
[All Databricks Certified Data Engineer Professional Questions]

A data engineer is configuring Delta Sharing for a Databricks-to-Databricks scenario to optimize read performance. The recipient needs to perform time travel queries and streaming reads on shared sales data.

Which configuration will provide the optimal performance while enabling these capabilities?

Show Suggested Answer Hide Answer
Suggested Answer: A

The official Delta Sharing guidance specifies that in order for recipients to use time travel queries and streaming reads, providers must share Delta tables WITH HISTORY. Sharing history ensures the Delta log is included, which enables efficient access to table snapshots and incremental data streams. Additionally, Change Data Feed (CDF) must be enabled prior to sharing if downstream consumers require streaming CDC queries. Without history, recipients cannot perform time travel or streaming queries. Open sharing supports static Delta tables but lacks streaming support. Therefore, sharing tables WITH HISTORY and enabling CDF is the required configuration for both performance and functionality.


Contribute your Thoughts:

0/2000 characters
Svetlana
3 days ago
Sharing without history seems risky, I’d stick with A.
upvoted 0 times
...
Ty
8 days ago
Definitely A, CDF is a game changer for streaming reads.
upvoted 0 times
...
Claribel
13 days ago
Surprised that option D is even mentioned, isn't it less efficient?
upvoted 0 times
...
Stanford
18 days ago
I disagree, partitioning can really boost performance.
upvoted 0 times
...
Deeanna
23 days ago
Option A is the way to go for time travel!
upvoted 0 times
...
Noel
28 days ago
I recall that using the open sharing protocol can sometimes enhance performance, but I wonder if it really applies here with Databricks-to-Databricks.
upvoted 0 times
...
Peter
1 month ago
I practiced a similar question where caching was emphasized, but I feel like sharing the entire schema without history might not be optimal.
upvoted 0 times
...
Celestine
1 month ago
I'm not entirely sure, but I remember something about partitioning being beneficial for performance, so maybe option B could be a contender?
upvoted 0 times
...
Santos
1 month ago
I think option A sounds familiar since it mentions sharing with history, which is important for time travel queries.
upvoted 0 times
...

Save Cancel