A data engineer needs to connect to an Oracle database from a Databricks notebook. The Oracle JDBC driver is not pre-installed. Which steps are required to successfully read data?

Mount the Oracle database as a filesystem using `dbutils.fs.mount`.

Install the Oracle JDBC driver on the cluster using `%pip install` or library configuration, then use `spark.read.format("jdbc")` with the connection string.

Use `spark.read.format("jdbc")` without any driver installation; Spark includes all JDBC drivers by default.

Use `requests.get()` to connect to the Oracle database.

A notebook fetches data from an external REST API that occasionally returns 500 errors. The team wants to make the ingestion more reliable by retrying failed requests. Which approach is most effective?

Use `spark.read.format("jdbc")` to read from the API.

Increase the timeout of the `requests.get()` call to 10 minutes.

Use a single `requests.get()` call and if it fails, let the notebook fail.

Wrap the API call in a `for` loop that retries up to 5 times with exponential backoff, and log failures.

Which of the following is a common strategy for implementing an incremental load from a JDBC source?

Using a watermark column to track the last processed value

Loading all rows and then deduplicating

Deleting the target table before each load

What is the primary purpose of Lakeflow Jobs in Databricks?

To provide a SQL query interface

To schedule and orchestrate notebook-based workflows

To manage Unity Catalog permissions

DatabricksCertified Data Engineer Associate

Domain 2Objective 5

Use JDBC/ODBC or REST Clients in Notebooks to Land Data into Cloud Storage or Directly into UnityCatalog–governed Tables, Usually Orchestrated and Scheduled with Lakeflow Jobs. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 2)

Part of the Data Ingestion and Loading domain, which accounts for 21% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–13 in this domain), expect 1–2 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

8concepts

21%of the exam

Questions 6–10

6application · medium
A data engineer needs to connect to an Oracle database from a Databricks notebook. The Oracle JDBC driver is not pre-installed. Which steps are required to successfully read data?
Select an answer first
7application · medium
A notebook fetches data from an external REST API that occasionally returns 500 errors. The team wants to make the ingestion more reliable by retrying failed requests. Which approach is most effective?
Select an answer first
8foundation · easy
Which of the following is a common strategy for implementing an incremental load from a JDBC source?
Select an answer first
9foundation · easy
What is the primary purpose of Lakeflow Jobs in Databricks?
Select an answer first
10foundation · easy
When writing a DataFrame to cloud storage, which format is commonly used for transactional data lakes?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-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-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.