Data Engineer Professional · 5% of the exam

Data Sharing and Federation: free practice questions

5 sample questions from our 5-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Databricks exam.

1. 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.

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

  • A. A SHARE is the collection of shared data; a RECIPIENT consumes it✓ Correct
  • B. A CLUSTER is shared; a JOB consumes it
  • C. A WIDGET is shared; a NOTEBOOK consumes it
  • D. A CHECKPOINT is shared; a STREAM consumes it
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.

3. 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. Lakehouse Federation (querying external sources through Unity Catalog)✓ Correct
  • B. COPY INTO
  • C. Delta Sharing recipients
  • D. VACUUM
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 (C) shares Databricks data outward, and VACUUM (D) cleans up old files.

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

  • A. Recipients can consume shared data using various tools/platforms, not only Databricks✓ Correct
  • B. It requires all recipients to buy the same proprietary tool
  • C. It physically copies data to every recipient
  • D. It only works within a single workspace
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 (B), avoids copying data (C), and works across organizations, not one workspace (D).

5. 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).

0 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free