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

Questions 1–5

1. 1foundation · easy

   What is required in the table reference when writing to a Unity Catalog table?

   • AThe cloud storage path
   • BOnly the table name
   • CThe JDBC connection string
   • DThe full three-level namespace: catalog.schema.table
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   After fetching data from a REST API using the requests library, what is a common next step to load it into a DataFrame?

   • AUse spark.sql to query the API
   • BConvert the JSON response to a Spark DataFrame using spark.createDataFrame
   • CWrite the response directly to a JDBC table
   • DUse spark.read.jdbc with the API URL
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A data engineer is building an ingestion job that calls a third-party REST API with a rate limit of 100 requests per minute. The job needs to fetch 10,000 records, and the API occasionally returns 429 (Too Many Requests) and 500 errors. The job is scheduled hourly. Which approach ensures the job completes reliably without exceeding the rate limit?

   • AUse `spark.read.format("jdbc")` to read from the API.
   • BIncrease the timeout of each request to 5 minutes.
   • CMake all 10,000 requests in a single loop without any delay or retry.
   • DUse a loop that respects the rate limit by adding a delay between requests, and implement retry with exponential backoff for 429 and 500 errors.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Spark DataFrame method is used to read data from an external database via JDBC?

   • Aspark.sql("SELECT * FROM jdbc.table")
   • Bspark.read.jdbc(url, table, properties)
   • Cspark.read.csv(url)
   • Dspark.read.format("jdbc").load(url)
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which of the following is a typical component of a JDBC connection string used in a Databricks notebook?

   • AThe cloud storage path where the data will be written
   • BThe database URL, including the host, port, and database name
   • CThe Databricks workspace URL
   • DThe name of the Unity Catalog table to be created
   Reveal Solution Discussion Select an answer first