Databricks-DE-Pro Data Sharing and Federation Practice Test 2 — 15 Questions

Question 1

Which statement correctly describes the relationship between Unity Catalog and Databricks SQL Warehouses when using Lakehouse Federation?

Accepted Answer

The SQL Warehouse pushes down query predicates to the external database.. Lakehouse Federation allows users to query external databases directly from Databricks SQL Warehouses. The SQL Warehouse acts as the compute engine that translates Spark SQL queries into the native dialect of the external source. Unity Catalog acts as the central governance layer that stores the connection information, credentials, and schema mapping, allowing users to query external data as if it were local tables.

Answer

The SQL Warehouse performs the data ingestion into the Unity Catalog metastore.

Answer

Unity Catalog must store the external data in a managed Delta table.

Answer

All federated queries are executed solely within the Databricks control plane.

Question 2

A Data Engineer is setting up Lakehouse Federation for a PostgreSQL database. Which TWO steps are required to ensure that users can securely query the data using Unity Catalog?

Accepted Answer

Create a connection object with appropriate credentials in Unity Catalog.. To set up Lakehouse Federation, you must first establish a connection object that stores credentials securely in Unity Catalog. Then, you must create a foreign catalog that maps the remote database to a local Unity Catalog structure. These two steps enable Unity Catalog to manage permissions and translate queries for the federated source without exposing raw credentials to end users.

Answer

Ingest all PostgreSQL data into a S3 bucket first.

Answer

Install a custom JDBC driver on every user's local machine.

Answer

Configure a VPC peering connection to the external database.

Question 3

What is the primary difference between sharing data via Delta Sharing compared to sharing data via Databricks-to-Databricks sharing?

Accepted Answer

Delta Sharing allows recipients outside of the Databricks ecosystem to access data.. Delta Sharing is an open protocol that allows sharing data with any client, including those outside the Databricks ecosystem, by using credential files. Databricks-to-Databricks sharing is a proprietary feature that allows seamless data access across different Unity Catalog metastores within the Databricks ecosystem, leveraging built-in authentication and governance features without requiring external credential management or token distribution.

Answer

Delta Sharing is only for real-time streaming data.

Answer

Databricks-to-Databricks sharing requires the recipient to download a credential file.

Answer

Databricks-to-Databricks sharing is limited to within the same cloud region.

Question 4

What is the primary benefit of using Unity Catalog for data federation?

Accepted Answer

It provides a single security model for all data sources.. Unity Catalog acts as a centralized governance layer that provides a unified namespace for both local and external data. By using Unity Catalog, organizations can apply consistent security policies, such as column-level masking or row-level filtering, to federated data sources. This allows users to access disparate systems through a single, secure interface without learning unique security models for each data source.

Answer

It eliminates the need for any network configuration.

Answer

It automatically converts all external data to Delta format.

Answer

It allows the SQL Warehouse to run entirely on the external database.

Question 5

When using Delta Sharing to share data with a recipient, what is the best way to handle updates to the shared data?

Accepted Answer

Updates are automatically visible to the recipient.. Delta Sharing automatically reflects the state of the table at the time of the query. Because the recipient accesses the Delta table directly (or via a managed share), any new data written to the table becomes immediately available to the recipient. There is no need for the provider to manually refresh the share, which ensures data consistency and reduces the maintenance burden for the Data Engineer.

Answer

The provider must recreate the share object.

Answer

The recipient must request a new credential file.

Answer

The provider must run an 'REFRESH SHARE' command.

Question 6

A data engineer at a healthcare company needs to share a Delta table containing patient records with an external research partner. The partner uses a non-Databricks platform and requires read-only access to the latest data, with updates reflected in near real-time. The engineer creates a Delta Share and adds the table. Which additional step is required to allow the partner to access the shared data?

Accepted Answer

Create a recipient object and provide the recipient with the activation link or credential file.. For a non-Databricks recipient to access a Delta Share, the provider must create a recipient object in Unity Catalog. This generates an activation link or credential file that the recipient uses to authenticate. The share must contain the table, and the recipient is granted access to the share. This process ensures secure, read-only access without requiring the recipient to have a Databricks account.

Answer

Configure a Databricks SQL warehouse and share its connection string with the recipient.

Answer

Grant the recipient's user account SELECT privileges on the shared table.

Answer

Generate a bearer token for the recipient and provide it along with the share name.

Question 7

A Data Engineer is using Lakehouse Federation to query an external PostgreSQL database from Databricks. The engineer creates a foreign catalog named 'pg_catalog' using a connection that specifies the host, port, and credentials. Users report that queries against the foreign catalog fail with a permission error, even though the connection works when tested. The engineer confirms that the connection has the correct credentials and that the PostgreSQL user has SELECT privileges on the required tables. What is the most likely cause?

Accepted Answer

The users have not been granted USE on the foreign catalog and SELECT on the tables.. In Lakehouse Federation, the connection stores credentials to access the external database, but end users must still have Unity Catalog privileges to query the foreign catalog. Specifically, they need USE on the foreign catalog and SELECT on the tables. Without these, queries fail with permission errors. The connection test succeeds because it uses the stored credentials directly, bypassing user-level Unity Catalog checks. The correct answer addresses the missing Unity Catalog grants.

Answer

The PostgreSQL database is not in the same region as the Databricks workspace.

Answer

The connection uses a service principal instead of a user account.

Answer

The foreign catalog was created without specifying the 'postgresql' database type.

Question 8

A data engineering team maintains a Unity Catalog metastore in a Databricks workspace. They need to provide an external partner with read-only access to a specific Delta table, but the partner's analytics platform is not Databricks and does not support the Delta Lake protocol. The partner can consume Parquet files over a REST API. Which Unity Catalog feature should the team use to share the table?

Accepted Answer

Delta Sharing. Delta Sharing is the correct choice because it is the only Unity Catalog feature designed to share Delta tables externally using an open REST protocol. It supports recipients on non-Databricks platforms by serving data as Parquet, which aligns with the partner's capabilities. The other options serve different purposes: Volumes store files, Lakehouse Federation queries external systems, and the SQL Connector is a client library.

Answer

Unity Catalog Volumes

Answer

Databricks SQL Connector for Python

Answer

Lakehouse Federation

Question 9

A data engineer at a healthcare company needs to share a Delta table containing patient records with an external research partner. The partner must only see aggregated statistics, not individual patient rows. The engineer wants to enforce this at the data sharing layer without creating a separate physical copy of the table. Which approach should the engineer take?

Accepted Answer

Create a view that aggregates the data and share the view through Delta Sharing.. Delta Sharing allows sharing views that can perform aggregation and filtering, enabling fine-grained control over what data is exposed. Sharing an aggregated view ensures the partner sees only summary statistics, not raw patient records. This approach avoids data duplication and maintains centralized governance. The other options either do not support the required granularity or are not designed for external sharing.

Answer

Create a Delta Share and add the table with a partition filter that excludes sensitive columns.

Answer

Export the aggregated data to a CSV file and provide it to the partner via a secure file transfer.

Answer

Use Lakehouse Federation to create a foreign catalog pointing to the partner's database and grant SELECT on the aggregated columns.

Question 10

A data engineer is setting up a Delta Share to provide a partner with access to a specific table. The partner uses Databricks and wants to query the shared data using their own Databricks workspace. What is the correct sequence of actions for the data engineer to enable this Databricks-to-Databricks sharing?

Accepted Answer

Create a share, add the table, create a recipient of type Databricks, and grant the recipient access to the share.. Databricks-to-Databricks sharing uses Unity Catalog to create a share, add tables, and define a recipient using the partner's Databricks sharing identifier. The recipient is then granted access to the share. The partner mounts the share in their workspace, enabling them to query the data with their own compute. This method avoids credential files and ensures secure, real-time access.

Answer

Export the table to a cloud storage location and provide the partner with the storage credentials.

Answer

Create a share, add the table, generate a credential file, and send it to the partner.

Answer

Grant the partner's Databricks workspace SELECT privileges on the table, and they can query it directly.

Question 11

A Data Engineer is using Lakehouse Federation to query a Snowflake database from Databricks. The engineer has created a connection and a foreign catalog. Which statement correctly describes how data is accessed when a user queries a table in the foreign catalog?

Accepted Answer

The query is executed on Snowflake, and only the results are returned to Databricks.. Lakehouse Federation enables querying external databases without moving data. When a user queries a foreign catalog table, Databricks pushes the query down to the external database, such as Snowflake. The external database executes the query and returns only the results. This approach minimizes data transfer and leverages the external system's compute. The foreign catalog provides a seamless experience, but the data remains in the source system.

Answer

The data is cached in the Databricks workspace after the first query.

Answer

The data is copied into Delta Lake before the query runs.

Answer

The query is executed on Databricks, and the data is streamed from Snowflake.

Question 12

A data engineer is setting up Lakehouse Federation to query an external MySQL database from Databricks. The engineer creates a connection using the MySQL connector and a foreign catalog. Users in the 'analysts' group report that they can see the foreign catalog but cannot query any tables. The engineer has granted USAGE on the connection to the 'analysts' group. Which TWO additional permissions must be granted to the 'analysts' group to allow them to query tables in the foreign catalog? (Choose two.)

Accepted Answer

USE CATALOG on the foreign catalog. To query foreign tables in a foreign catalog, users need USE CATALOG on the foreign catalog and USE SCHEMA on the specific schemas. USAGE on the connection only allows the catalog to use the connection; it does not grant access to the catalog's objects. These two privileges are the minimum required for read access.

Answer

BROWSE on the foreign catalog

Answer

CREATE on the foreign catalog

Answer

SELECT on the foreign catalog

Question 13

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

Accepted Answer

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

Configure a Databricks SQL warehouse for the recipient to query the shared data.

Answer

Enable the Delta Sharing server on the Databricks workspace.

Answer

Grant the recipient SELECT privileges on the shared table.

Question 14

A data engineer is using Lakehouse Federation to query data from an external PostgreSQL database. The engineer has created a foreign catalog and foreign schema. Which statement accurately describes how the data is accessed during a query?

Accepted Answer

The query is translated into PostgreSQL SQL, executed on the external database, and the results are streamed back to Databricks for further processing.. Lakehouse Federation enables querying external databases without copying data. It uses query pushdown to translate and execute parts of the query on the external system, then streams results back to Databricks for any remaining processing. This approach minimizes data movement and leverages the external database's compute. The other options incorrectly describe data copying or full remote execution.

Answer

The external data is cached in the Databricks workspace's local storage for the duration of the query.

Answer

The query is executed entirely within the external PostgreSQL database, and only the results are returned to Databricks.

Answer

The data is copied into Delta Lake tables in Unity Catalog before the query runs.

Question 15

A data engineer wants to share a Delta table with an external partner who does not have a Databricks account. The partner needs to access the data using Python. Which method should the engineer recommend to the partner for accessing the shared data?

Accepted Answer

Install the delta-sharing Python library and use the provided credential file to read the shared table.. For recipients without a Databricks account, the delta-sharing Python library is the standard way to access shared data. It uses the credential file to authenticate and allows reading the shared table into Python. This method is secure, supports live data, and does not require Databricks infrastructure on the recipient side. Other methods either require Databricks access or are not part of the Delta Sharing protocol.

Answer

Mount the shared table as an external table in their local Spark cluster using the Delta Sharing connector.

Answer

Use the Databricks SQL Connector for Python with the partner's Databricks personal access token.

Answer

Download the shared table as a Parquet file from the Databricks workspace and load it into their Python environment.