Databricks-DE-Pro Data Sharing and Federation Practice Question
A data engineer is setting up a Delta Share to provide an external partner with access to a subset of data. The partner will use a non-Databricks client that supports the Delta Sharing protocol. Which two actions are required to enable the partner to access the shared data? (Choose two.)
⚠ Common exam trap
The trap here is thinking that standard Unity Catalog SQL grants like SELECT are used for Delta Sharing recipients, when access is actually controlled at the share level.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a recipient in Unity Catalog and provide the partner with the activation link or credential file.
To enable an external partner to access a Delta Share, two key steps are required: creating a recipient and providing them with the credential file or activation link, and adding the table to a share while granting the recipient access to that share. These actions establish the secure sharing relationship and define the data scope. Other options are either not applicable to non-Databricks clients or not part of the Delta Sharing setup process.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create a recipient in Unity Catalog and provide the partner with the activation link or credential file.
Why this is correct
Creating a recipient in Unity Catalog is essential to establish the sharing relationship. The recipient is issued a credential file or activation link that the partner uses to authenticate to the Delta Sharing server. Without this, the partner cannot access the share. This step is a core part of the Delta Sharing setup process, ensuring secure and controlled access.
- ✗
Configure a Databricks SQL warehouse for the recipient to query the shared data.
Why it's wrong here
The recipient is using a non-Databricks client, so they do not need a Databricks SQL warehouse. Delta Sharing provides a REST API endpoint that the recipient's client connects to directly. A SQL warehouse is only needed if the recipient were using Databricks SQL to query the shared data. Thus, this action is unnecessary and would not facilitate access for the external client.
- ✓
Add the table to the share and grant the recipient access to the share.
Why this is correct
The shared table must be explicitly added to a share, and the recipient must be granted access to that share. This is how Delta Sharing controls which data a recipient can see. Without adding the table to the share and granting the recipient access, the recipient will not be able to query the data, even if they have the credential file.
- ✗
Enable the Delta Sharing server on the Databricks workspace.
Why it's wrong here
Delta Sharing is enabled at the metastore level, not per workspace, and it is typically enabled by default in Unity Catalog. There is no separate server to enable. The sharing is managed through Unity Catalog, and the recipient accesses the data via the metastore's Delta Sharing endpoint. Thus, this step is not required and is not a valid configuration action.
- ✗
Grant the recipient SELECT privileges on the shared table.
Why it's wrong here
Delta Sharing does not use Unity Catalog privilege grants like SELECT on tables for recipients. Access is controlled by adding the table to a share and granting the recipient access to that share. The recipient's permissions are managed at the share level, not through standard SQL grants. Therefore, this action is not required and would not enable access.
About these practice questions
One of 267 original Databricks-DE-Pro practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Pro practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Pro exam.