Home / Data Engineer Associate / Objective 2.5

Domain 2: Data Ingestion and Loading · 21% of the exam · Full exam outline

2.5 Use JDBC/ODBC or REST clients in notebooks to land data into cloud storage or directly into Unity Catalog-governed tables, usually orchestrated and scheduled with Lakeflow Jobs.

Practice questions

Question 1medium

A notebook task joins several Delta tables and appends the result, held in about 400 in-memory partitions, to a PostgreSQL reporting database through JDBC. During the write, the database administrator sees hundreds of simultaneous insert sessions that slow down the application sharing that database. Which change reduces the load on the database?

Included in Master: master every domain.See plans
Question 2easy

A scheduled notebook reads a customer database with spark.read.format("jdbc"). How does Databricks recommend supplying the database username and password?

Included in Master: master every domain.See plans