How do you query a federated data source in Databricks SQL after the connection is set up?

Use the `SELECT` statement with the connection name as the table name.

Use the `LOAD DATA` command to import the data into a temporary table first.

Use the `OPEN` command to open a direct connection to the external system.

Use the `EXTERNAL QUERY` function with the connection name.

How can you handle a data type mismatch when joining a Delta table and a federated source?

Use the `CONVERT` function in the WHERE clause.

Ignore the mismatch; the join will still work.

Drop the column from the query.

Use the `CAST` function to convert one column to the other's data type.

What is a common issue when joining a Delta table with a federated data source?

Data types for the join columns may differ between the two systems.

The federated source must be converted to a Delta table first.

The federated source does not support SQL.

Delta tables cannot be joined with federated sources.

A data analyst needs to query a Snowflake data warehouse from Databricks SQL. The Snowflake administrator provided a JDBC URL, username, password, and the warehouse name. What is the first step the analyst should take in Databricks SQL to enable querying Snowflake?

Add the Snowflake JDBC driver to the SQL warehouse's libraries.

Create a Delta table that points to the Snowflake data.

Use the Databricks CLI to run a command that imports Snowflake data into DBFS.

Create a connection to Snowflake using the provided JDBC details.

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

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 16–20

16foundation · easy
How do you query a federated data source in Databricks SQL after the connection is set up?
Select an answer first
17foundation · easy
How can you handle a data type mismatch when joining a Delta table and a federated source?
Select an answer first
18foundation · easy
What is a common issue when joining a Delta table with a federated data source?
Select an answer first
19foundation · easy
In Databricks SQL, which component is used to store the configuration for connecting to an external database?
Select an answer first
20application · medium
A data analyst needs to query a Snowflake data warehouse from Databricks SQL. The Snowflake administrator provided a JDBC URL, username, password, and the warehouse name. What is the first step the analyst should take in Databricks SQL to enable querying Snowflake?
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.