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 12

Question 110

A managed enterprise-source ingestion has an initial backfill followed by periodic change updates. Which action should the engineer perform to establish the intended control?

  1. Parse the items as an array and use explode for one output row per element.
  2. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.
  3. Configure the supported connector pipeline and its schedule or update cadence.
  4. Restore the original checkpointLocation rather than creating an empty path.

Explanation

Correct Answer

C:

Configure the supported connector pipeline and its schedule or update cadence. Historical rows appear first and later changes are reflected without full custom reimports.

Incorrect Answers

A:

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. Configure the supported connector pipeline and its schedule or update cadence.

B:

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. In those circumstances, “Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column” fits. Configure the supported connector pipeline and its schedule or update cadence.

D:

If a streaming ingestion restarts after maintenance and must continue from its last committed progress, “Restore the original checkpointLocation rather than creating an empty path” may be the appropriate response. Configure the supported connector pipeline and its schedule or update cadence.

Question 111

A managed enterprise-source ingestion has an initial backfill followed by periodic change updates. Which observation best proves the workload meets its requirement?

  1. New broker events reach the target without first creating object-store files.
  2. Historical rows appear first and later changes are reflected without full custom reimports.
  3. The downstream record can trace each document to its source file and metadata.
  4. Only the intended JSON records are added; unrelated formats are left out.

Explanation

Correct Answer

B:

Historical rows appear first and later changes are reflected without full custom reimports.

Incorrect Answers

A:

A real-time event feed has no cloud-object landing area and is delivered over an event broker. In those circumstances, “New broker events reach the target without first creating object-store files” fits. Historical rows appear first and later changes are reflected without full custom reimports.

C:

If an application exports documents plus metadata into object storage, “The downstream record can trace each document to its source file and metadata” may be the appropriate response. Historical rows appear first and later changes are reflected without full custom reimports.

D:

A controlled data import should process only JSON files from a mixed-format landing folder. In those circumstances, “Only the intended JSON records are added; unrelated formats are left out” fits. Historical rows appear first and later changes are reflected without full custom reimports.

Question 112

A managed enterprise-source ingestion has an initial backfill followed by periodic change updates. The team observes: Only initial rows are present after new source records are committed. Which underlying cause most directly explains this failure?

  1. The job uses Auto Loader cloudFiles against a broker-only event source.
  2. The managed ingestion schedule or ongoing sync was never activated.
  3. The pipeline discarded parse failures without a governed error-record destination.
  4. The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking.

Explanation

Correct Answer

B:

The managed ingestion schedule or ongoing sync was never activated. Configure the supported connector pipeline and its schedule or update cadence.

Incorrect Answers

A:

When a real-time event feed has no cloud-object landing area and is delivered over an event broker, “The job uses Auto Loader cloudFiles against a broker-only event source” could be relevant. The managed ingestion schedule or ongoing sync was never activated.

C:

A customer source mixes valid records with a small number of malformed JSON documents. In those circumstances, “The pipeline discarded parse failures without a governed error-record destination” fits. The managed ingestion schedule or ongoing sync was never activated.

D:

When 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” could be relevant. The managed ingestion schedule or ongoing sync was never activated.

Question 113

A niche on-premises database lacks a supported managed connector but allows JDBC reads. Which design choice best addresses the stated business and technical requirement?

  1. Land raw semi-structured records before enforcing the stable analytics projection.
  2. Use Auto Loader rescue mode for unforeseen fields.
  3. Use a notebook-based JDBC extraction through a governed ingestion job.
  4. Prefer Auto Loader over a repeated full-directory file scan.

Explanation

Correct Answer

C:

Use a notebook-based JDBC extraction through a governed ingestion job. A representative read succeeds without embedding credentials in notebooks or logs.

Incorrect Answers

A:

If a telemetry source emits JSON lines with heterogeneous optional keys, “Land raw semi-structured records before enforcing the stable analytics projection” may be the appropriate response. Use a notebook-based JDBC extraction through a governed ingestion job.

B:

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. In those circumstances, “Use Auto Loader rescue mode for unforeseen fields” fits. Use a notebook-based JDBC extraction through a governed ingestion job.

D:

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 notebook-based JDBC extraction through a governed ingestion job.

Question 114

A niche on-premises database lacks a supported managed connector but allows JDBC reads. Which setup step most directly realizes the proposed design?

  1. Grant the connector principal required source-read privileges and configure its connection.
  2. Schedule a Lakeflow Job to read and validate the completed monthly export.
  3. Configure a one-time COPY INTO statement against the approved Delta table.
  4. Set up a JDBC client with secret-backed credentials and write results to a UC Delta table.

Explanation

Correct Answer

D:

Set up a JDBC client with secret-backed credentials and write results to a UC Delta table. A representative read succeeds without embedding credentials in notebooks or logs.

Incorrect Answers

A:

An ERP table is replicated through a managed connector but its ingestion account lacks read access. In those circumstances, “Grant the connector principal required source-read privileges and configure its connection” fits. Set up a JDBC client with secret-backed credentials and write results to a UC Delta table.

B:

When a finance feed is delivered as one vetted CSV export at the end of each month, “Schedule a Lakeflow Job to read and validate the completed monthly export” could be relevant. Set up a JDBC client with secret-backed credentials and write results to a UC Delta table.

C:

If a static set of archive files must be loaded once through SQL with minimal pipeline machinery, “Configure a one-time COPY INTO statement against the approved Delta table” may be the appropriate response. Set up a JDBC client with secret-backed credentials and write results to a UC Delta table.

Question 115

A niche on-premises database lacks a supported managed connector but allows JDBC reads. What is the most relevant verification evidence for this case?

  1. A representative read succeeds without embedding credentials in notebooks or logs.
  2. Previously unseen optional keys do not erase the original raw record.
  3. Records without optional values still load while mandatory fields are validated.
  4. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Explanation

Correct Answer

A:

A representative read succeeds without embedding credentials in notebooks or logs.

Incorrect Answers

B:

If a telemetry source emits JSON lines with heterogeneous optional keys, “Previously unseen optional keys do not erase the original raw record” may be the appropriate response. A representative read succeeds without embedding credentials in notebooks or logs.

C:

A JSON API occasionally omits nested optional customer attributes. In those circumstances, “Records without optional values still load while mandatory fields are validated” fits. A representative read succeeds without embedding credentials in notebooks or logs.

D:

When a regulated feed must retain unexpected JSON attributes without changing the approved table schema, “Unexpected fields appear in the rescued-data JSON while defined columns keep their schema” could be relevant. A representative read succeeds without embedding credentials in notebooks or logs.

Question 116

A niche on-premises database lacks a supported managed connector but allows JDBC reads. The team observes: Credentials appear in a checked-in notebook and permissions cannot be rotated safely. What is the most likely mechanism behind the observed defect?

  1. The stream's checkpoint was replaced rather than reused for the same source.
  2. A continuously active stream was chosen for an essentially one-off load.
  3. The ingestion hard-coded source credentials rather than using a secret-backed identity.
  4. Unknown fields were ignored rather than rescued for later inspection.

Explanation

Correct Answer

C:

The ingestion hard-coded source credentials rather than using a secret-backed identity. Set up a JDBC client with secret-backed credentials and write results to a UC Delta table.

Incorrect Answers

A:

If a point-of-sale system publishes a new immutable object-store file every five minutes, “The stream's checkpoint was replaced rather than reused for the same source” may be the appropriate response. The ingestion hard-coded source credentials rather than using a secret-backed identity.

B:

A static set of archive files must be loaded once through SQL with minimal pipeline machinery. In those circumstances, “A continuously active stream was chosen for an essentially one-off load” fits. The ingestion hard-coded source credentials rather than using a secret-backed identity.

D:

If a JSON source contains additional nested keys that are not part of a strongly typed downstream contract, “Unknown fields were ignored rather than rescued for later inspection” may be the appropriate response. The ingestion hard-coded source credentials rather than using a secret-backed identity.

Question 117

An external service exposes a paginated REST endpoint with rate limits and no managed connector. Which approach most directly satisfies the requirement?

  1. Use a bounded REST extraction in a scheduled notebook with explicit pagination and retry handling.
  2. Use an authorized connection identity with the minimum required source permissions.
  3. Use a scheduled batch ingestion job aligned with the monthly delivery.
  4. Reuse the stream's durable checkpoint with the same logical source and sink.

Explanation

Correct Answer

A:

Use a bounded REST extraction in a scheduled notebook with explicit pagination and retry handling. All pages are ingested once and a rate-limit response is retried safely.

Incorrect Answers

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. Use a bounded REST extraction in a scheduled notebook with explicit pagination and retry handling.

C:

If a finance feed is delivered as one vetted CSV export at the end of each month, “Use a scheduled batch ingestion job aligned with the monthly delivery” may be the appropriate response. Use a bounded REST extraction in a scheduled notebook with explicit pagination and retry handling.

D:

A streaming ingestion restarts after maintenance and must continue from its last committed progress. In those circumstances, “Reuse the stream's durable checkpoint with the same logical source and sink” fits. Use a bounded REST extraction in a scheduled notebook with explicit pagination and retry handling.

Question 118

An external service exposes a paginated REST endpoint with rate limits and no managed connector. Which configuration or engineering action would most directly implement the requirement?

  1. Configure the partner ingestion to land in an approved UC-managed dataset.
  2. Ingest JSON to bronze with controlled schema handling and standardize selected fields in silver.
  3. Stage arriving changes and MERGE them into the target using the partner's stable key.
  4. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.

Explanation

Correct Answer

D:

Implement cursor handling, throttling backoff, and idempotent writes to the bronze table. All pages are ingested once and a rate-limit response is retried safely.

Incorrect Answers

A:

When a proprietary application has no native managed connector but a supported third-party integration, “Configure the partner ingestion to land in an approved UC-managed dataset” could be relevant. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.

B:

If a telemetry source emits JSON lines with heterogeneous optional keys, “Ingest JSON to bronze with controlled schema handling and standardize selected fields in silver” may be the appropriate response. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.

C:

A partner publishes corrected records with stable business keys in each incremental delivery. In those circumstances, “Stage arriving changes and MERGE them into the target using the partner's stable key” fits. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.

Question 119

An external service exposes a paginated REST endpoint with rate limits and no managed connector. Which test would establish that the change worked as intended?

  1. New broker events reach the target without first creating object-store files.
  2. A recent test event appears in the target within the required latency budget.
  3. All pages are ingested once and a rate-limit response is retried safely.
  4. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Explanation

Correct Answer

C:

All pages are ingested once and a rate-limit response is retried safely.

Incorrect Answers

A:

If a real-time event feed has no cloud-object landing area and is delivered over an event broker, “New broker events reach the target without first creating object-store files” may be the appropriate response. All pages are ingested once and a rate-limit response is retried safely.

B:

A fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files. In those circumstances, “A recent test event appears in the target within the required latency budget” fits. All pages are ingested once and a rate-limit response is retried safely.

D:

If a regulated feed must retain unexpected JSON attributes without changing the approved table schema, “Unexpected fields appear in the rescued-data JSON while defined columns keep their schema” may be the appropriate response. All pages are ingested once and a rate-limit response is retried safely.

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.

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.