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 10

Question 90

A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. Which implementation step is most appropriate before production use?

  1. Capture corrupt-record evidence and apply an explicit reject or quarantine path.
  2. Create the required governed Delta target and use COPY INTO to load the approved cloud path.
  3. Read the stream with an appropriate source and durable checkpoint, then write to a Delta sink.
  4. Configure schema rescue and inspect _rescued_data for the source record.

Explanation

Correct Answer

D:

Configure schema rescue and inspect _rescued_data for the source record. The unexpected nested key and source path can be inspected in the rescue output.

Incorrect Answers

A:

A customer source mixes valid records with a small number of malformed JSON documents. In those circumstances, “Capture corrupt-record evidence and apply an explicit reject or quarantine path” fits. Configure schema rescue and inspect _rescued_data for the source record.

B:

When a platform team must load raw cloud files to a three-part Unity Catalog table using SQL, “Create the required governed Delta target and use COPY INTO to load the approved cloud path” could be relevant. Configure schema rescue and inspect _rescued_data for the source record.

C:

If a fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files, “Read the stream with an appropriate source and durable checkpoint, then write to a Delta sink” may be the appropriate response. Configure schema rescue and inspect _rescued_data for the source record.

Question 91

A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?

  1. The unexpected nested key and source path can be inspected in the rescue output.
  2. Re-executing the same COPY INTO statement does not reload already tracked unchanged source files.
  3. Authorized analysts can query loaded rows under the expected catalog and schema.
  4. Exactly one curated monthly batch is available after the scheduled run.

Explanation

Correct Answer

A:

The unexpected nested key and source path can be inspected in the rescue output.

Incorrect Answers

B:

If an operations team wants a SQL-only one-time load of historical CSV objects stored in an approved S3 prefix, “Re-executing the same COPY INTO statement does not reload already tracked unchanged source files” may be the appropriate response. The unexpected nested key and source path can be inspected in the rescue output.

C:

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. The unexpected nested key and source path can be inspected in the rescue output.

D:

When a finance feed is delivered as one vetted CSV export at the end of each month, “Exactly one curated monthly batch is available after the scheduled run” could be relevant. The unexpected nested key and source path can be inspected in the rescue output.

Question 92

A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. The team observes: The pipeline drops unknown nested attributes without any review trail. Which root cause should be addressed first given this evidence?

  1. A continuously active stream was chosen for an essentially one-off load.
  2. The COPY INTO source selection did not restrict ingestion to JSON input.
  3. Unknown fields were ignored rather than rescued for later inspection.
  4. Ingestion time was used as a replacement for the source event-time field.

Explanation

Correct Answer

C:

Unknown fields were ignored rather than rescued for later inspection. Configure schema rescue and inspect _rescued_data for the source record.

Incorrect Answers

A:

If a static set of archive files must be loaded once through SQL with minimal pipeline machinery, “A continuously active stream was chosen for an essentially one-off load” may be the appropriate response. Unknown fields were ignored rather than rescued for later inspection.

B:

A controlled data import should process only JSON files from a mixed-format landing folder. In those circumstances, “The COPY INTO source selection did not restrict ingestion to JSON input” fits. Unknown fields were ignored rather than rescued for later inspection.

D:

If a vendor's data source sends records with event timestamps older than ingestion time, “Ingestion time was used as a replacement for the source event-time field” may be the appropriate response. Unknown fields were ignored rather than rescued for later inspection.

Question 93

An Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints. Which technical design is most appropriate for the stated constraint?

  1. Use a supported Lakeflow Connect managed connector for the CRM source.
  2. Maintain an explicit schema location as well as stream progress storage.
  3. Constrain the COPY INTO format and source-file selection to the intended JSON dataset.
  4. Land raw semi-structured records before enforcing the stable analytics projection.

Explanation

Correct Answer

B:

Maintain an explicit schema location as well as stream progress storage. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

Incorrect Answers

A:

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. Maintain an explicit schema location as well as stream progress storage.

C:

If 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” may be the appropriate response. Maintain an explicit schema location as well as stream progress storage.

D:

A telemetry source emits JSON lines with heterogeneous optional keys. In those circumstances, “Land raw semi-structured records before enforcing the stable analytics projection” fits. Maintain an explicit schema location as well as stream progress storage.

Question 94

An Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints. Which action should the engineer perform to establish the intended control?

  1. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.
  2. Read the stream with an appropriate source and durable checkpoint, then write to a Delta sink.
  3. Configure the supported connector pipeline and its schedule or update cadence.
  4. Configure the approved client connectivity, access identity, and scheduled notebook load.

Explanation

Correct Answer

A:

Configure cloudFiles.schemaLocation separately from the stream checkpointLocation. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

Incorrect Answers

B:

If a fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files, “Read the stream with an appropriate source and durable checkpoint, then write to a Delta sink” may be the appropriate response. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.

C:

A managed enterprise-source ingestion has an initial backfill followed by periodic change updates. In those circumstances, “Configure the supported connector pipeline and its schedule or update cadence” fits. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.

D:

When a SQL Server source is accessible only through a company-approved ODBC route, “Configure the approved client connectivity, access identity, and scheduled notebook load” could be relevant. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.

Question 95

An Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints. Which observation best proves the workload meets its requirement?

  1. The second execution reports no newly copied rows when no new files arrived.
  2. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.
  3. Records without optional values still load while mandatory fields are validated.
  4. The successful batch count plus quarantine count reconciles to input events.

Explanation

Correct Answer

B:

The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

Incorrect Answers

A:

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. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

C:

When a JSON API occasionally omits nested optional customer attributes, “Records without optional values still load while mandatory fields are validated” could be relevant. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

D:

If a customer source mixes valid records with a small number of malformed JSON documents, “The successful batch count plus quarantine count reconciles to input events” may be the appropriate response. The _schemas directory captures inferred columns and the checkpoint tracks processing progress.

Question 96

An Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints. The team observes: Schema history vanishes when a deployment changes unrelated job settings. Which underlying cause most directly explains this failure?

  1. The pipeline discarded parse failures without a governed error-record destination.
  2. The job never persisted the inferred schema to a stable schema location.
  3. The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking.
  4. The pipeline treated an array as one scalar field instead of exploding its elements.

Explanation

Correct Answer

B:

The job never persisted the inferred schema to a stable schema location. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.

Incorrect Answers

A:

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 job never persisted the inferred schema to a stable schema location.

C:

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. The job never persisted the inferred schema to a stable schema location.

D:

An order feed supplies JSON objects with nested arrays of items. In those circumstances, “The pipeline treated an array as one scalar field instead of exploding its elements” fits. The job never persisted the inferred schema to a stable schema location.

Question 97

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. Which design choice best addresses the stated business and technical requirement?

  1. Use a scheduled batch ingestion job aligned with the monthly delivery.
  2. Use a supported Lakeflow Connect managed connector for the CRM source.
  3. Quarantine malformed records while allowing valid events to proceed under agreed quality rules.
  4. Prefer managed Lakeflow Connect over custom API extraction when source features fit.

Explanation

Correct Answer

B:

Use a supported Lakeflow Connect managed connector for the CRM source. Incremental changes appear in the governed target under the connector's supported sync behavior.

Incorrect Answers

A:

When 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” could be relevant. Use a supported Lakeflow Connect managed connector for the CRM source.

C:

A customer source mixes valid records with a small number of malformed JSON documents. In those circumstances, “Quarantine malformed records while allowing valid events to proceed under agreed quality rules” fits. Use a supported Lakeflow Connect managed connector for the CRM source.

D:

When a common SaaS application has a vetted managed connector with built-in ingestion state, “Prefer managed Lakeflow Connect over custom API extraction when source features fit” could be relevant. Use a supported Lakeflow Connect managed connector for the CRM source.

Question 98

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. Which setup step most directly realizes the proposed design?

  1. Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.
  2. Create the connector connection and managed ingestion pipeline with UC destinations.
  3. Stage arriving changes and MERGE them into the target using the partner's stable key.
  4. Configure a one-time COPY INTO statement against the approved Delta table.

Explanation

Correct Answer

B:

Create the connector connection and managed ingestion pipeline with UC destinations. Incremental changes appear in the governed target under the connector's supported sync behavior.

Incorrect Answers

A:

If an external service exposes a paginated REST endpoint with rate limits and no managed connector, “Implement cursor handling, throttling backoff, and idempotent writes to the bronze table” may be the appropriate response. Create the connector connection and managed ingestion pipeline with UC destinations.

C:

When a partner publishes corrected records with stable business keys in each incremental delivery, “Stage arriving changes and MERGE them into the target using the partner's stable key” could be relevant. Create the connector connection and managed ingestion pipeline with UC destinations.

D:

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. Create the connector connection and managed ingestion pipeline with UC destinations.

Question 99

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. What is the most relevant verification evidence for this case?

  1. The landing job advances through new objects without repeatedly loading earlier files.
  2. An order with three items produces three correct item-level silver rows.
  3. Incremental changes appear in the governed target under the connector's supported sync behavior.
  4. After the controlled restart the new column appears in the schema and rows are processed.

Explanation

Correct Answer

C:

Incremental changes appear in the governed target under the connector's supported sync behavior.

Incorrect Answers

A:

A large object-store drop includes millions of files with continual arrivals. In those circumstances, “The landing job advances through new objects without repeatedly loading earlier files” fits. Incremental changes appear in the governed target under the connector's supported sync behavior.

B:

When an order feed supplies JSON objects with nested arrays of items, “An order with three items produces three correct item-level silver rows” could be relevant. Incremental changes appear in the governed target under the connector's supported sync behavior.

D:

An Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked. In those circumstances, “After the controlled restart the new column appears in the schema and rows are processed” fits. Incremental changes appear in the governed target under the connector's supported sync behavior.

Question 100

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. The team observes: The custom script breaks on API cursor expiry after thousands of records. What is the most likely mechanism behind the observed defect?

  1. A handwritten REST poller was used instead of the supported managed connector.
  2. Rescue behavior or the required rescued-data column was not configured for this source.
  3. The ingestion was left on an automatic-evolution policy contrary to the approval requirement.
  4. The job uses Auto Loader cloudFiles against a broker-only event source.

Explanation

Correct Answer

A:

A handwritten REST poller was used instead of the supported managed connector. Create the connector connection and managed ingestion pipeline with UC destinations.

Incorrect Answers

B:

If a regulated feed must retain unexpected JSON attributes without changing the approved table schema, “Rescue behavior or the required rescued-data column was not configured for this source” may be the appropriate response. A handwritten REST poller was used instead of the supported managed connector.

C:

A customer source cannot accept newly introduced columns without explicit schema approval. In those circumstances, “The ingestion was left on an automatic-evolution policy contrary to the approval requirement” fits. A handwritten REST poller was used instead of the supported managed connector.

D:

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. A handwritten REST poller was used instead of the supported managed connector.

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.