A Delta table `orders` has a column `customer_id` as STRING. A federated PostgreSQL table `customers` has `id` as INTEGER. An analyst needs to join these tables. The analyst writes: `ON orders.customer_id = CAST(customers.id AS STRING)`. The query is extremely slow. What is the best way to improve performance?

Create an index on the PostgreSQL table's `id` column.

Use a subquery to cast the PostgreSQL table to STRING first.

Keep the cast but add a hint to force a broadcast join.

Change the Delta table column to INTEGER and join directly on `orders.customer_id = customers.id`.

An analyst needs to set up a federated connection to a MySQL database. The analyst has the hostname, port, database name, username, and password. What additional information is typically required to create the connection in Databricks SQL?

The MySQL server's SSL certificate.

The JDBC driver class and URL format.

The MySQL server's IP address and MAC address.

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

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 21–22

21expert · hard
A Delta table `orders` has a column `customer_id` as STRING. A federated PostgreSQL table `customers` has `id` as INTEGER. An analyst needs to join these tables. The analyst writes: `ON orders.customer_id = CAST(customers.id AS STRING)`. The query is extremely slow. What is the best way to improve performance?
Select an answer first
22application · medium
An analyst needs to set up a federated connection to a MySQL database. The analyst has the hostname, port, database name, username, and password. What additional information is typically required to create the connection in Databricks SQL?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

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

Questions 21–22

An analyst needs to set up a federated connection to a MySQL database. The analyst has the hostname, port, database name, username, and password. What additional information is typically required to create the connection in Databricks SQL?

Keep studying — Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses