What is the first step to set up a connection to a federated data source in Databricks SQL?

Create a Delta table that references the external data.

Define a connection in Databricks that specifies the external system's details, such as host, port, and credentials.

Enable the Databricks SQL warehouse to access the internet.

Import the external data into a notebook using Python.

A query joins a large Delta table with a federated SQL Server table. The analyst notices that the query transfers the entire SQL Server table to Databricks before filtering. What is the most likely cause?

The Delta table is too large and needs partitioning.

The filter on the SQL Server table is not being pushed down because it is written in a way that prevents pushdown.

The join type is incorrect and should be changed to a broadcast join.

The SQL warehouse is too small to handle the data.

A company uses Databricks SQL for analytics. They need to query data stored in an external Teradata warehouse without copying it into Databricks. What is the most appropriate way to achieve this?

Use the Databricks REST API to run a query on Teradata and return results.

Export Teradata data to a cloud storage bucket and create an external table in Databricks.

Create a connection to Teradata and use three-part names to query its tables directly.

Use the Teradata connector in Power BI to import data into Databricks.

When querying a federated data source, what does Databricks SQL do with the query?

It downloads the entire external table to Databricks before executing the query.

It requires the user to manually copy the data to Databricks before querying.

It sends the query to the external system for execution and returns the results to Databricks.

It converts the query to a Spark job and runs it on the Databricks cluster.

DatabricksCertified Data Analyst Associate

Domain 4Objective 3

Querying Cross-System Analytics by Joining Data from a Delta Table and a Federated Data Source. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

6concepts

Questions 1–5

1foundation · easy
What is the first step to set up a connection to a federated data source in Databricks SQL?
Select an answer first
2application · medium
A query joins a large Delta table with a federated SQL Server table. The analyst notices that the query transfers the entire SQL Server table to Databricks before filtering. What is the most likely cause?
Select an answer first
3foundation · easy
What SQL syntax is used to join a Delta table with a federated data source in Databricks SQL?
Select an answer first
4application · medium
A company uses Databricks SQL for analytics. They need to query data stored in an external Teradata warehouse without copying it into Databricks. What is the most appropriate way to achieve this?
Select an answer first
5foundation · easy
When querying a federated data source, what does Databricks SQL do with the query?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

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-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.