A data engineer is optimizing a federated query against a large PostgreSQL table. The query filters on a column that is not indexed in PostgreSQL. The engineer has two options: (1) add an index to the PostgreSQL column, or (2) use a Databricks cluster with more workers. Which option is more likely to improve query performance, and why?

Using a Databricks cluster with more workers, because it will speed up the processing of the transferred data.

Neither option will help, because Lakehouse Federation does not support pushdown for unindexed columns.

Adding an index to the PostgreSQL column, because it will speed up the filter pushdown and reduce the amount of data transferred to Databricks.

Both options are equally effective, so the engineer should choose the cheaper option.

What is a common cause of connectivity failures when using Lakehouse Federation?

The Databricks cluster is not using the latest runtime

The external source is not registered in Unity Catalog

The foreign connection has incorrect network settings or credentials

The user does not have SELECT permission on the foreign catalog

How do you reference a table in a foreign catalog when writing a Spark SQL query?

Using the fully qualified name: catalog.schema.table

Using a special syntax: FEDERATED(catalog.table)

Using the external source name and table name: source.table

Using the connection name and table name: connection.table

What is the purpose of creating a foreign catalog in Unity Catalog?

To create a new database in the external source

To expose an external data source as a catalog in Unity Catalog for querying

To store data from an external source in the Databricks lakehouse

To manage credentials for the external source

DatabricksCertified Data Engineer Professional

Domain 4Objective 2

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

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 6–10

6expert · hard
A data engineer is optimizing a federated query against a large PostgreSQL table. The query filters on a column that is not indexed in PostgreSQL. The engineer has two options: (1) add an index to the PostgreSQL column, or (2) use a Databricks cluster with more workers. Which option is more likely to improve query performance, and why?
Select an answer first
7foundation · easy
What is a common cause of connectivity failures when using Lakehouse Federation?
Select an answer first
8foundation · easy
How do you reference a table in a foreign catalog when writing a Spark SQL query?
Select an answer first
9foundation · easy
What is the purpose of creating a foreign catalog in Unity Catalog?
Select an answer first
10foundation · easy
Which tool can be used to monitor federated query performance in Databricks?
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.

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

Questions 6–10

What is a common cause of connectivity failures when using Lakehouse Federation?

How do you reference a table in a foreign catalog when writing a Spark SQL query?

What is the purpose of creating a foreign catalog in Unity Catalog?

Which tool can be used to monitor federated query performance in Databricks?

Keep studying — Data Sharing and Federation