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 8

Question 70

A controlled data import should process only JSON files from a mixed-format landing folder. Which configuration or engineering action would most directly implement the requirement?

  1. Configure schema rescue and inspect _rescued_data for the source record.
  2. Specify FILEFORMAT = JSON and an appropriate source path or file pattern.
  3. Schedule a Lakeflow Job to read and validate the completed monthly export.
  4. Stage arriving changes and MERGE them into the target using the partner's stable key.

Explanation

Correct Answer

B:

Specify FILEFORMAT = JSON and an appropriate source path or file pattern. Only the intended JSON records are added; unrelated formats are left out.

Incorrect Answers

A:

When a JSON source contains additional nested keys that are not part of a strongly typed downstream contract, “Configure schema rescue and inspect _rescued_data for the source record” could be relevant. Specify FILEFORMAT = JSON and an appropriate source path or file pattern.

C:

A finance feed is delivered as one vetted CSV export at the end of each month. In those circumstances, “Schedule a Lakeflow Job to read and validate the completed monthly export” fits. Specify FILEFORMAT = JSON and an appropriate source path or file pattern.

D:

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. Specify FILEFORMAT = JSON and an appropriate source path or file pattern.

Question 71

A controlled data import should process only JSON files from a mixed-format landing folder. Which test would establish that the change worked as intended?

  1. An order with three items produces three correct item-level silver rows.
  2. Partner-sourced records pass lineage and permission checks in the target.
  3. Only the intended JSON records are added; unrelated formats are left out.
  4. Records without optional values still load while mandatory fields are validated.

Explanation

Correct Answer

C:

Only the intended JSON records are added; unrelated formats are left out.

Incorrect Answers

A:

If an order feed supplies JSON objects with nested arrays of items, “An order with three items produces three correct item-level silver rows” may be the appropriate response. Only the intended JSON records are added; unrelated formats are left out.

B:

A proprietary application has no native managed connector but a supported third-party integration. In those circumstances, “Partner-sourced records pass lineage and permission checks in the target” fits. Only the intended JSON records are added; unrelated formats are left out.

D:

If a JSON API occasionally omits nested optional customer attributes, “Records without optional values still load while mandatory fields are validated” may be the appropriate response. Only the intended JSON records are added; unrelated formats are left out.

Question 72

A controlled data import should process only JSON files from a mixed-format landing folder. The team observes: Malformed-format errors arise from unrelated files in the shared prefix. Which configuration or design gap best explains the symptom?

  1. The transformation treated a nonessential nested field as mandatory.
  2. The COPY INTO source selection did not restrict ingestion to JSON input.
  3. The run started without a reliable completion signal for the monthly export.
  4. The REST client fetched only the initial page and ignored continuation tokens.

Explanation

Correct Answer

B:

The COPY INTO source selection did not restrict ingestion to JSON input. Specify FILEFORMAT = JSON and an appropriate source path or file pattern.

Incorrect Answers

A:

A JSON API occasionally omits nested optional customer attributes. In those circumstances, “The transformation treated a nonessential nested field as mandatory” fits. The COPY INTO source selection did not restrict ingestion to JSON input.

C:

If 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” may be the appropriate response. The COPY INTO source selection did not restrict ingestion to JSON input.

D:

An external service exposes a paginated REST endpoint with rate limits and no managed connector. In those circumstances, “The REST client fetched only the initial page and ignored continuation tokens” fits. The COPY INTO source selection did not restrict ingestion to JSON input.

Question 73

An Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked. Which architecture or engineering decision best fits this scenario?

  1. Use Auto Loader schema inference and managed column evolution with restart handling.
  2. Use a continuously updating Structured Streaming ingestion pattern.
  3. Write connector outputs into the correct governed Unity Catalog catalog and schema.
  4. Keep binary or text document payloads linked to their metadata in governed bronze records.

Explanation

Correct Answer

A:

Use Auto Loader schema inference and managed column evolution with restart handling. After the controlled restart the new column appears in the schema and rows are processed.

Incorrect Answers

B:

If a fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files, “Use a continuously updating Structured Streaming ingestion pattern” may be the appropriate response. Use Auto Loader schema inference and managed column evolution with restart handling.

C:

An audit team needs stable ownership of data ingested from a managed enterprise application. In those circumstances, “Write connector outputs into the correct governed Unity Catalog catalog and schema” fits. Use Auto Loader schema inference and managed column evolution with restart handling.

D:

When an application exports documents plus metadata into object storage, “Keep binary or text document payloads linked to their metadata in governed bronze records” could be relevant. Use Auto Loader schema inference and managed column evolution with restart handling.

Question 74

An Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked. Which implementation step is most appropriate before production use?

  1. Capture corrupt-record evidence and apply an explicit reject or quarantine path.
  2. Run COPY INTO with a source location and explicit file format against the governed table.
  3. Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
  4. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.

Explanation

Correct Answer

D:

Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema. After the controlled restart the new column appears in the schema and rows are processed.

Incorrect Answers

A:

If a customer source mixes valid records with a small number of malformed JSON documents, “Capture corrupt-record evidence and apply an explicit reject or quarantine path” may be the appropriate response. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.

B:

An operations team wants a SQL-only one-time load of historical CSV objects stored in an approved S3 prefix. In those circumstances, “Run COPY INTO with a source location and explicit file format against the governed table” fits. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.

C:

When a real-time event feed has no cloud-object landing area and is delivered over an event broker, “Configure an approved Structured Streaming source for the broker and Delta target checkpoint” could be relevant. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.

Question 75

An Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?

  1. After the controlled restart the new column appears in the schema and rows are processed.
  2. Re-executing the same COPY INTO statement does not reload already tracked unchanged source files.
  3. The landing job advances through new objects without repeatedly loading earlier files.
  4. Incremental changes appear in the governed target under the connector's supported sync behavior.

Explanation

Correct Answer

A:

After the controlled restart the new column appears in the schema and rows are processed.

Incorrect Answers

B:

When 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” could be relevant. After the controlled restart the new column appears in the schema and rows are processed.

C:

If a large object-store drop includes millions of files with continual arrivals, “The landing job advances through new objects without repeatedly loading earlier files” may be the appropriate response. After the controlled restart the new column appears in the schema and rows are processed.

D:

A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. In those circumstances, “Incremental changes appear in the governed target under the connector's supported sync behavior” fits. After the controlled restart the new column appears in the schema and rows are processed.

Question 76

An Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked. The team observes: An UnknownFieldException occurs when a new JSON field first arrives. Which root cause should be addressed first given this evidence?

  1. The REST client fetched only the initial page and ignored continuation tokens.
  2. The transformation treated a nonessential nested field as mandatory.
  3. The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking.
  4. In addNewColumns mode a new field triggers a deliberate stream stop pending restart.

Explanation

Correct Answer

D:

In addNewColumns mode a new field triggers a deliberate stream stop pending restart. Persist cloudFiles.schemaLocation and choose addNewColumns for an inferred source schema.

Incorrect Answers

A:

When an external service exposes a paginated REST endpoint with rate limits and no managed connector, “The REST client fetched only the initial page and ignored continuation tokens” could be relevant. In addNewColumns mode a new field triggers a deliberate stream stop pending restart.

B:

If a JSON API occasionally omits nested optional customer attributes, “The transformation treated a nonessential nested field as mandatory” may be the appropriate response. In addNewColumns mode a new field triggers a deliberate stream stop pending restart.

C:

An operations team wants a SQL-only one-time load of historical CSV objects stored in an approved S3 prefix. In those circumstances, “The team used plain INSERT FROM FILES without COPY INTO's loaded-file tracking” fits. In addNewColumns mode a new field triggers a deliberate stream stop pending restart.

Question 77

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. Which technical design is most appropriate for the stated constraint?

  1. Use null-safe extraction and a stable target schema for optional nested fields.
  2. Capture event-time and ingestion-time separately to preserve lateness semantics.
  3. Use Auto Loader rescue mode for unforeseen fields.
  4. Use a supported Lakeflow Connect managed connector for the CRM source.

Explanation

Correct Answer

C:

Use Auto Loader rescue mode for unforeseen fields. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Incorrect Answers

A:

If a JSON API occasionally omits nested optional customer attributes, “Use null-safe extraction and a stable target schema for optional nested fields” may be the appropriate response. Use Auto Loader rescue mode for unforeseen fields.

B:

A vendor's data source sends records with event timestamps older than ingestion time. In those circumstances, “Capture event-time and ingestion-time separately to preserve lateness semantics” fits. Use Auto Loader rescue mode for unforeseen fields.

D:

If 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” may be the appropriate response. Use Auto Loader rescue mode for unforeseen fields.

Question 78

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. Which action should the engineer perform to establish the intended control?

  1. Capture corrupt-record evidence and apply an explicit reject or quarantine path.
  2. Schedule a Lakeflow Job to read and validate the completed monthly export.
  3. Use a supported binary-file or text ingestion source and persist content identifiers.
  4. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.

Explanation

Correct Answer

D:

Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

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. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.

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 cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.

C:

If an application exports documents plus metadata into object storage, “Use a supported binary-file or text ingestion source and persist content identifiers” may be the appropriate response. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.

Question 79

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. Which observation best proves the workload meets its requirement?

  1. Authorized analysts can query loaded rows under the expected catalog and schema.
  2. Reruns skip already processed files while added archive files can be loaded.
  3. The landing job advances through new objects without repeatedly loading earlier files.
  4. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Explanation

Correct Answer

D:

Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Incorrect Answers

A:

When a platform team must load raw cloud files to a three-part Unity Catalog table using SQL, “Authorized analysts can query loaded rows under the expected catalog and schema” could be relevant. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

B:

If a static set of archive files must be loaded once through SQL with minimal pipeline machinery, “Reruns skip already processed files while added archive files can be loaded” may be the appropriate response. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

C:

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. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.

Question 80

A regulated feed must retain unexpected JSON attributes without changing the approved table schema. The team observes: A new field is neither available in defined columns nor in rescued data. Which underlying cause most directly explains this failure?

  1. Schema handling was too strict at the raw landing boundary for this variable payload.
  2. The pipeline uses a scheduled batch job instead of a streaming ingestion path.
  3. Ingestion time was used as a replacement for the source event-time field.
  4. Rescue behavior or the required rescued-data column was not configured for this source.

Explanation

Correct Answer

D:

Rescue behavior or the required rescued-data column was not configured for this source. Set cloudFiles.schemaEvolutionMode to rescue and keep a rescued-data column.

Incorrect Answers

A:

If a telemetry source emits JSON lines with heterogeneous optional keys, “Schema handling was too strict at the raw landing boundary for this variable payload” may be the appropriate response. Rescue behavior or the required rescued-data column was not configured for this source.

B:

A fraud scoring table must incorporate arriving events with low latency rather than waiting for nightly files. In those circumstances, “The pipeline uses a scheduled batch job instead of a streaming ingestion path” fits. Rescue behavior or the required rescued-data column was not configured for this source.

C:

When 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” could be relevant. Rescue behavior or the required rescued-data column was not configured for this source.

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.