U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - 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

Currently there are no comments in this discussion, be the first to comment!


Save Cancel