Databricks Certified Data Engineer Associate Free Practice Exam Questions

136 real Databricks Certified Data Engineer Associate exam questions with answers and AI explanations. Databricks certification prep — page 7 of 14.

  1. Question 73: An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, t…
  2. Question 74: A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it…
  3. Question 75: A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query…
  4. Question 76: A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job’s current run. The da…
  5. Question 77: A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start. Which action can…
  6. Question 78: Which SQL keyword can be used to convert a table from a long format to a wide format?
  7. Question 80: A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice th…
  8. Question 81: What describes the relationship between Gold tables and Silver tables?
  9. Question 82: What is used by Spark to record the offset range of the data being processed in each trigger in order for Structured Streaming to reliably track the exact prog…
  10. Question 83: What describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delt…