Databricks Certified Data Engineer Associate Exam Dumps, Practice Test Questions

100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Databricks Certified Data Engineer Associate Premium Bundle
$79.97
$59.98

Certified Data Engineer Associate Premium Bundle

  • Premium File: 280 Questions & Answers. Last update: Nov 9, 2026
  • Training Course: 38 Video Lectures
  • Study Guide: 432 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

Certified Data Engineer Associate Premium Bundle

Databricks Certified Data Engineer Associate Premium Bundle
  • Premium File: 280 Questions & Answers. Last update: Nov 9, 2026
  • Training Course: 38 Video Lectures
  • Study Guide: 432 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$79.97
$59.98

Databricks Certified Data Engineer Associate Practice Test 13

Question 120

An external service exposes a paginated REST endpoint with rate limits and no managed connector. The team observes: Records beyond the first page are missing despite a successful notebook run. Which configuration or design gap best explains the symptom?

  1. The destination was an unqualified legacy table, not the required UC namespace.
  2. The run started without a reliable completion signal for the monthly export.
  3. The transformation treated a nonessential nested field as mandatory.
  4. The REST client fetched only the initial page and ignored continuation tokens.

Explanation

Correct Answer

D:

The REST client fetched only the initial page and ignored continuation tokens. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.

Incorrect Answers

A:

A platform team must load raw cloud files to a three-part Unity Catalog table using SQL. In those circumstances, “The destination was an unqualified legacy table, not the required UC namespace” fits. The REST client fetched only the initial page and ignored continuation tokens.

B:

When a finance feed is delivered as one vetted CSV export at the end of each month, “The run started without a reliable completion signal for the monthly export” could be relevant. The REST client fetched only the initial page and ignored continuation tokens.

C:

If a JSON API occasionally omits nested optional customer attributes, “The transformation treated a nonessential nested field as mandatory” may be the appropriate response. The REST client fetched only the initial page and ignored continuation tokens.

Question 121

A SQL Server source is accessible only through a company-approved ODBC route. Which architecture or engineering decision best fits this scenario?

  1. Use a supported Lakeflow Connect managed connector for the CRM source.
  2. Prefer Auto Loader over a repeated full-directory file scan.
  3. Use a controlled ODBC-based extraction rather than pretending it is a file-arrival source.
  4. Constrain the COPY INTO format and source-file selection to the intended JSON dataset.

Explanation

Correct Answer

C:

Use a controlled ODBC-based extraction rather than pretending it is a file-arrival source. An end-to-end test imports sample rows via ODBC into the governed target.

Incorrect Answers

A:

When a CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination, “Use a supported Lakeflow Connect managed connector for the CRM source” could be relevant. Use a controlled ODBC-based extraction rather than pretending it is a file-arrival source.

B:

If a large object-store drop includes millions of files with continual arrivals, “Prefer Auto Loader over a repeated full-directory file scan” may be the appropriate response. Use a controlled ODBC-based extraction rather than pretending it is a file-arrival source.

D:

When a controlled data import should process only JSON files from a mixed-format landing folder, “Constrain the COPY INTO format and source-file selection to the intended JSON dataset” could be relevant. Use a controlled ODBC-based extraction rather than pretending it is a file-arrival source.

Question 122

A SQL Server source is accessible only through a company-approved ODBC route. Which implementation step is most appropriate before production use?

  1. Configure the supported connector connection and its governed destination.
  2. Configure a one-time COPY INTO statement against the approved Delta table.
  3. Configure the approved client connectivity, access identity, and scheduled notebook load.
  4. Keep the COPY INTO target and source identity stable across reruns.

Explanation

Correct Answer

C:

Configure the approved client connectivity, access identity, and scheduled notebook load. An end-to-end test imports sample rows via ODBC into the governed target.

Incorrect Answers

A:

If a common SaaS application has a vetted managed connector with built-in ingestion state, “Configure the supported connector connection and its governed destination” may be the appropriate response. Configure the approved client connectivity, access identity, and scheduled notebook load.

B:

A static set of archive files must be loaded once through SQL with minimal pipeline machinery. In those circumstances, “Configure a one-time COPY INTO statement against the approved Delta table” fits. Configure the approved client connectivity, access identity, and scheduled notebook load.

D:

If a data owner receives daily Parquet exports and wants previously copied files skipped on reruns, “Keep the COPY INTO target and source identity stable across reruns” may be the appropriate response. Configure the approved client connectivity, access identity, and scheduled notebook load.

Question 123

A SQL Server source is accessible only through a company-approved ODBC route. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?

  1. Authorized analysts can query loaded rows under the expected catalog and schema.
  2. Incremental changes appear in the governed target under the connector's supported sync behavior.
  3. The second execution reports no newly copied rows when no new files arrived.
  4. An end-to-end test imports sample rows via ODBC into the governed target.

Explanation

Correct Answer

D:

An end-to-end test imports sample rows via ODBC into the governed target.

Incorrect Answers

A:

A platform team must load raw cloud files to a three-part Unity Catalog table using SQL. In those circumstances, “Authorized analysts can query loaded rows under the expected catalog and schema” fits. An end-to-end test imports sample rows via ODBC into the governed target.

B:

When a CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination, “Incremental changes appear in the governed target under the connector's supported sync behavior” could be relevant. An end-to-end test imports sample rows via ODBC into the governed target.

C:

If a data owner receives daily Parquet exports and wants previously copied files skipped on reruns, “The second execution reports no newly copied rows when no new files arrived” may be the appropriate response. An end-to-end test imports sample rows via ODBC into the governed target.

Question 124

A SQL Server source is accessible only through a company-approved ODBC route. The team observes: No source rows arrive although object-store notifications are healthy. Which root cause should be addressed first given this evidence?

  1. The job watches cloud files instead of connecting to the database through ODBC.
  2. The pipeline uses a scheduled batch job instead of a streaming ingestion path.
  3. The stream's checkpoint was replaced rather than reused for the same source.
  4. The transformation treated a nonessential nested field as mandatory.

Explanation

Correct Answer

A:

The job watches cloud files instead of connecting to the database through ODBC. Configure the approved client connectivity, access identity, and scheduled notebook load.

Incorrect Answers

B:

If a fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files, “The pipeline uses a scheduled batch job instead of a streaming ingestion path” may be the appropriate response. The job watches cloud files instead of connecting to the database through ODBC.

C:

A point-of-sale system publishes a new immutable object-store file every five minutes. In those circumstances, “The stream's checkpoint was replaced rather than reused for the same source” fits. The job watches cloud files instead of connecting to the database through ODBC.

D:

When a JSON API occasionally omits nested optional customer attributes, “The transformation treated a nonessential nested field as mandatory” could be relevant. The job watches cloud files instead of connecting to the database through ODBC.

Question 125

A large object-store drop includes millions of files with continual arrivals. Which technical design is most appropriate for the stated constraint?

  1. Prefer Auto Loader over a repeated full-directory file scan.
  2. Use a supported Lakeflow Connect managed connector for the CRM source.
  3. Maintain an explicit schema location as well as stream progress storage.
  4. Capture event-time and ingestion-time separately to preserve lateness semantics.

Explanation

Correct Answer

A:

Prefer Auto Loader over a repeated full-directory file scan. The landing job advances through new objects without repeatedly loading earlier files.

Incorrect Answers

B:

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. In those circumstances, “Use a supported Lakeflow Connect managed connector for the CRM source” fits. Prefer Auto Loader over a repeated full-directory file scan.

C:

When an Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints, “Maintain an explicit schema location as well as stream progress storage” could be relevant. Prefer Auto Loader over a repeated full-directory file scan.

D:

If a vendor's data source sends records with event timestamps older than ingestion time, “Capture event-time and ingestion-time separately to preserve lateness semantics” may be the appropriate response. Prefer Auto Loader over a repeated full-directory file scan.

Question 126

A large object-store drop includes millions of files with continual arrivals. Which action should the engineer perform to establish the intended control?

  1. Use Auto Loader discovery and a durable progress checkpoint for incremental processing.
  2. Use a supported binary-file or text ingestion source and persist content identifiers.
  3. Parse the items as an array and use explode for one output row per element.
  4. Restore the original checkpointLocation rather than creating an empty path.

Explanation

Correct Answer

A:

Use Auto Loader discovery and a durable progress checkpoint for incremental processing. The landing job advances through new objects without repeatedly loading earlier files.

Incorrect Answers

B:

When an application exports documents plus metadata into object storage, “Use a supported binary-file or text ingestion source and persist content identifiers” could be relevant. Use Auto Loader discovery and a durable progress checkpoint for incremental processing.

C:

If an order feed supplies JSON objects with nested arrays of items, “Parse the items as an array and use explode for one output row per element” may be the appropriate response. Use Auto Loader discovery and a durable progress checkpoint for incremental processing.

D:

A streaming ingestion restarts after maintenance and must continue from its last committed progress. In those circumstances, “Restore the original checkpointLocation rather than creating an empty path” fits. Use Auto Loader discovery and a durable progress checkpoint for incremental processing.

Question 127

A large object-store drop includes millions of files with continual arrivals. Which observation best proves the workload meets its requirement?

  1. Previously unseen optional keys do not erase the original raw record.
  2. The connector can enumerate and ingest the selected ERP objects without broader rights.
  3. The landing job advances through new objects without repeatedly loading earlier files.
  4. A delayed source event retains its original business event time in the bronze record.

Explanation

Correct Answer

C:

The landing job advances through new objects without repeatedly loading earlier files.

Incorrect Answers

A:

When a telemetry source emits JSON lines with heterogeneous optional keys, “Previously unseen optional keys do not erase the original raw record” could be relevant. The landing job advances through new objects without repeatedly loading earlier files.

B:

If an ERP table is replicated through a managed connector but its ingestion account lacks read access, “The connector can enumerate and ingest the selected ERP objects without broader rights” may be the appropriate response. The landing job advances through new objects without repeatedly loading earlier files.

D:

When a vendor's data source sends records with event timestamps older than ingestion time, “A delayed source event retains its original business event time in the bronze record” could be relevant. The landing job advances through new objects without repeatedly loading earlier files.

Question 128

A large object-store drop includes millions of files with continual arrivals. The team observes: The full directory is rescanned and load time grows with historical file count. Which underlying cause most directly explains this failure?

  1. The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking.
  2. The pipeline appended update records without matching them to existing keys.
  3. The connector destination was set to the wrong catalog or schema.
  4. A naive batch file scan was chosen instead of incremental Auto Loader discovery.

Explanation

Correct Answer

D:

A naive batch file scan was chosen instead of incremental Auto Loader discovery. Use Auto Loader discovery and a durable progress checkpoint for incremental processing.

Incorrect Answers

A:

If an operations team wants a SQL-only one-time load of historical CSV objects stored in an approved S3 prefix, “The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking” may be the appropriate response. A naive batch file scan was chosen instead of incremental Auto Loader discovery.

B:

A partner publishes corrected records with stable business keys in each incremental delivery. In those circumstances, “The pipeline appended update records without matching them to existing keys” fits. A naive batch file scan was chosen instead of incremental Auto Loader discovery.

C:

When an audit team needs stable ownership of data ingested from a managed enterprise application, “The connector destination was set to the wrong catalog or schema” could be relevant. A naive batch file scan was chosen instead of incremental Auto Loader discovery.

Question 129

A common SaaS application has a vetted managed connector with built-in ingestion state. Which design choice best addresses the stated business and technical requirement?

  1. Use a notebook-based JDBC extraction through a governed ingestion job.
  2. Use an authorized connection identity with the minimum required source permissions.
  3. Keep unexpected fields in a rescued-data column for later triage.
  4. Prefer managed Lakeflow Connect over custom API extraction when source features fit.

Explanation

Correct Answer

D:

Prefer managed Lakeflow Connect over custom API extraction when source features fit. New SaaS source changes appear without custom pagination code.

Incorrect Answers

A:

A niche on-premises database lacks a supported managed connector but allows JDBC reads. In those circumstances, “Use a notebook-based JDBC extraction through a governed ingestion job” fits. Prefer managed Lakeflow Connect over custom API extraction when source features fit.

B:

When an ERP table is replicated through a managed connector but its ingestion account lacks read access, “Use an authorized connection identity with the minimum required source permissions” could be relevant. Prefer managed Lakeflow Connect over custom API extraction when source features fit.

C:

If a JSON source contains additional nested keys that are not part of a strongly typed downstream contract, “Keep unexpected fields in a rescued-data column for later triage” may be the appropriate response. Prefer managed Lakeflow Connect over custom API extraction when source features fit.

Question 130

A common SaaS application has a vetted managed connector with built-in ingestion state. Which setup step most directly realizes the proposed design?

  1. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.
  2. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.
  3. Ingest JSON to bronze with controlled schema handling and standardize selected fields in silver.
  4. Configure the supported connector connection and its governed destination.

Explanation

Correct Answer

D:

Configure the supported connector connection and its governed destination. New SaaS source changes appear without custom pagination code.

Incorrect Answers

A:

When an Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked, “Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema” could be relevant. Configure the supported connector connection and its governed destination.

B:

If a regulated feed must retain unexpected JSON attributes without changing the approved table schema, “Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column” may be the appropriate response. Configure the supported connector connection and its governed destination.

C:

A telemetry source emits JSON lines with heterogeneous optional keys. In those circumstances, “Ingest JSON to bronze with controlled schema handling and standardize selected fields in silver” fits. Configure the supported connector connection and its governed destination.

Certified Data Engineer Associate Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.