Databricks Data Engineer Professional · 5% practice allocation

Databricks Data Engineer Professional: Data Sharing and Federation Practice Questions

5 free sample questions from the Data Sharing and Federation domain, with answers and explanations. The full Data Engineer Professional bank has 311 questions across 10 domains. Questions are scenario-based and written from the official Databricks exam guide.

A company must securely share a set of Delta tables with an external partner organization WITHOUT copying the data or granting access to its whole workspace. Which Databricks capability enables this?

A. Delta Sharing✓ Correct
B. Auto Loader
C. A cluster policy
D. OPTIMIZE ZORDER

Explanation

Delta Sharing is an open protocol for securely sharing live data across organizations and platforms without copying it. Auto Loader (B) ingests files, cluster policies (C) govern compute, and OPTIMIZE ZORDER (D) is a performance operation.

In Unity Catalog Delta Sharing, which object represents the collection of data a provider makes available, and who consumes it?

A. A CHECKPOINT is shared; a STREAM consumes it
B. A WIDGET is shared; a NOTEBOOK consumes it
C. A CLUSTER is shared; a JOB consumes it
D. A SHARE is the collection of shared data; a RECIPIENT consumes it✓ Correct

Explanation

In Unity Catalog, a provider creates a SHARE (a named collection of tables/views) and grants it to a RECIPIENT who consumes the data. The other pairings mix up unrelated compute, notebook, and streaming concepts.

A team needs to query tables that live in an external database (e.g., PostgreSQL) from Databricks WITHOUT first ingesting/copying them. Which capability supports this?

A. VACUUM
B. COPY INTO
C. Lakehouse Federation (querying external sources through Unity Catalog)✓ Correct
D. Delta Sharing recipients

Explanation

Lakehouse Federation lets you query external data sources (like PostgreSQL, MySQL, Snowflake) directly through Unity Catalog without copying the data in. COPY INTO (B) ingests files, Delta Sharing (D) shares Databricks data outward, and VACUUM (A) cleans up old files.

A governance requirement states shared data access must be revocable and auditable. How does Unity Catalog Delta Sharing support this?

A. Shares/grants to recipients can be revoked, and access is governed and audited centrally through Unity Catalog✓ Correct
B. Once shared, access can never be revoked
C. Sharing bypasses all governance
D. Only file-level copies are shared with no tracking

Explanation

Unity Catalog governs Delta Sharing centrally: grants to recipients are revocable and access is auditable. Access is revocable (B is false), sharing is governed not bypassed (C), and it shares live governed data rather than untracked file copies (D).

What is a key advantage of Delta Sharing being an OPEN protocol?

A. It physically copies data to every recipient
B. It only works within a single workspace
C. It requires all recipients to buy the same proprietary tool
D. Recipients can consume shared data using various tools/platforms, not only Databricks✓ Correct

Explanation

As an open protocol, Delta Sharing lets recipients read shared data from many tools and platforms (pandas, Spark, BI tools), not just Databricks. It doesn't require a specific proprietary tool (C), avoids copying data (A), and works across organizations, not one workspace (B).

Test yourself across every Data Engineer Professional domain

The free Data Engineer Professional practice test mixes about 20 questions weighted like the exam. The full 311-question bank adds instant grading, flashcards and a timed mock exam.

Take the free Data Engineer Professional practice test Practice the full bank

Study this domain

Data Sharing and Federation study guide (Data Engineer Professional) →

Other Data Engineer Professional domains

← All Databricks Data Engineer Professional study resources