What is the recommended way to store credentials for a foreign connection?

In a notebook cell as a variable

In a Databricks secret and referenced by the connection

In the foreign catalog definition

In the connection string as plain text

What does a foreign catalog expose to Databricks users?

A set of pre-defined queries against the external source

A connection string to the external source

The schemas and tables from the external data source

A read-only snapshot of the external data

What is the primary purpose of Lakehouse Federation in Databricks?

To replicate data from external systems into the Databricks lakehouse for offline analysis

To replace all external data warehouses with Databricks-managed storage

To provide a unified storage layer for all data across cloud providers

To enable querying external data sources without moving or copying the data into Databricks

A company has a foreign catalog that connects to a Snowflake database. The security team requires that all queries against this foreign catalog be audited. What must the data engineer configure to meet this requirement?

Create a view in Databricks that wraps the foreign table and enable audit logging on the view.

Enable Unity Catalog audit logging and ensure that the foreign catalog and its tables are in a location that is monitored.

Use a service principal for all queries and configure the service principal to log all activity.

Enable Snowflake's query logging and configure the foreign connection to forward logs to Databricks.

DatabricksCertified Data Engineer Professional

Domain 4Objective 2

Configure Lakehouse Federation with Proper Governance Across the Supported Source Systems. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 1)

Part of the Data Sharing and Federation domain, which accounts for 5% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~3–4 in this domain), expect 1–1 from this objective — we provide 25 practice questions to prepare you well beyond it. (estimate)

25questions here

5free pages

9concepts

5%of the exam

Questions 1–5

1foundation · easy
What is the recommended way to store credentials for a foreign connection?
Select an answer first
2foundation · easy
What does a foreign catalog expose to Databricks users?
Select an answer first
3foundation · easy
What is the primary purpose of Lakehouse Federation in Databricks?
Select an answer first
4foundation · easy
Which Unity Catalog feature helps track how federated data is used?
Select an answer first
5application · medium
A company has a foreign catalog that connects to a Snowflake database. The security team requires that all queries against this foreign catalog be audited. What must the data engineer configure to meet this requirement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-PROFESSIONAL

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.