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 11

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.

Question 101

An ERP table is replicated through a managed connector but its ingestion account lacks read access. Which approach most directly satisfies the requirement?

  1. Quarantine malformed records while allowing valid events to proceed under agreed quality rules.
  2. Use an authorized connection identity with the minimum required source permissions.
  3. Preserve the nested data at bronze and explicitly flatten items for the serving table.
  4. Use failOnNewColumns rather than silent schema evolution.

Explanation

Correct Answer

B:

Use an authorized connection identity with the minimum required source permissions. The connector can enumerate and ingest the selected ERP objects without broader rights.

Incorrect Answers

A:

If a customer source mixes valid records with a small number of malformed JSON documents, “Quarantine malformed records while allowing valid events to proceed under agreed quality rules” may be the appropriate response. Use an authorized connection identity with the minimum required source permissions.

C:

When an order feed supplies JSON objects with nested arrays of items, “Preserve the nested data at bronze and explicitly flatten items for the serving table” could be relevant. Use an authorized connection identity with the minimum required source permissions.

D:

If a customer source cannot accept newly introduced columns without explicit schema approval, “Use failOnNewColumns rather than silent schema evolution” may be the appropriate response. Use an authorized connection identity with the minimum required source permissions.

Question 102

An ERP table is replicated through a managed connector but its ingestion account lacks read access. Which configuration or engineering action would most directly implement the requirement?

  1. Configure a one-time COPY INTO statement against the approved Delta table.
  2. Configure the approved client connectivity, access identity, and scheduled notebook load.
  3. Ingest JSON to bronze with controlled schema handling and standardize selected fields in silver.
  4. Grant the connector principal required source-read privileges and configure its connection.

Explanation

Correct Answer

D:

Grant the connector principal required source-read privileges and configure its connection. The connector can enumerate and ingest the selected ERP objects without broader rights.

Incorrect Answers

A:

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. Grant the connector principal required source-read privileges and configure its connection.

B:

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. Grant the connector principal required source-read privileges and configure its connection.

C:

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. Grant the connector principal required source-read privileges and configure its connection.

Question 103

An ERP table is replicated through a managed connector but its ingestion account lacks read access. Which test would establish that the change worked as intended?

  1. The landing job advances through new objects without repeatedly loading earlier files.
  2. Unexpected fields appear in the rescued-data JSON while defined columns keep their schema.
  3. The second execution reports no newly copied rows when no new files arrived.
  4. The connector can enumerate and ingest the selected ERP objects without broader rights.

Explanation

Correct Answer

D:

The connector can enumerate and ingest the selected ERP objects without broader rights.

Incorrect Answers

A:

When a large object-store drop includes millions of files with continual arrivals, “The landing job advances through new objects without repeatedly loading earlier files” could be relevant. The connector can enumerate and ingest the selected ERP objects without broader rights.

B:

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. The connector can enumerate and ingest the selected ERP objects without broader rights.

C:

A data owner receives daily Parquet exports and wants previously copied files skipped on reruns. In those circumstances, “The second execution reports no newly copied rows when no new files arrived” fits. The connector can enumerate and ingest the selected ERP objects without broader rights.

Question 104

An ERP table is replicated through a managed connector but its ingestion account lacks read access. The team observes: The pipeline repeatedly fails authorization before it extracts any rows. Which configuration or design gap best explains the symptom?

  1. The job watches cloud files instead of connecting to the database through ODBC.
  2. The source identity lacks permissions on the selected ERP objects.
  3. The pipeline discarded parse failures without a governed error-record destination.
  4. The job never persisted the inferred schema to a stable schema location.

Explanation

Correct Answer

B:

The source identity lacks permissions on the selected ERP objects. Grant the connector principal required source-read privileges and configure its connection.

Incorrect Answers

A:

If a SQL Server source is accessible only through a company-approved ODBC route, “The job watches cloud files instead of connecting to the database through ODBC” may be the appropriate response. The source identity lacks permissions on the selected ERP objects.

C:

When a customer source mixes valid records with a small number of malformed JSON documents, “The pipeline discarded parse failures without a governed error-record destination” could be relevant. The source identity lacks permissions on the selected ERP objects.

D:

If an Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints, “The job never persisted the inferred schema to a stable schema location” may be the appropriate response. The source identity lacks permissions on the selected ERP objects.

Question 105

An audit team needs stable ownership of data ingested from a managed enterprise application. Which architecture or engineering decision best fits this scenario?

  1. Write connector outputs into the correct governed Unity Catalog catalog and schema.
  2. Maintain an explicit schema location as well as stream progress storage.
  3. Quarantine malformed records while allowing valid events to proceed under agreed quality rules.
  4. Capture event-time and ingestion-time separately to preserve lateness semantics.

Explanation

Correct Answer

A:

Write connector outputs into the correct governed Unity Catalog catalog and schema. The ingested tables are discoverable under the approved UC namespace and grants.

Incorrect Answers

B:

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. Write connector outputs into the correct governed Unity Catalog catalog and schema.

C:

If a customer source mixes valid records with a small number of malformed JSON documents, “Quarantine malformed records while allowing valid events to proceed under agreed quality rules” may be the appropriate response. Write connector outputs into the correct governed Unity Catalog catalog and schema.

D:

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. Write connector outputs into the correct governed Unity Catalog catalog and schema.

Question 106

An audit team needs stable ownership of data ingested from a managed enterprise application. Which implementation step is most appropriate before production use?

  1. Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.
  2. Configure destination catalog and schema in the Lakeflow Connect pipeline.
  3. Run COPY INTO with a source location and explicit file format against the governed table.
  4. Select failOnNewColumns and institute a reviewed schema-change deployment.

Explanation

Correct Answer

B:

Configure destination catalog and schema in the Lakeflow Connect pipeline. The ingested tables are discoverable under the approved UC namespace and grants.

Incorrect Answers

A:

When an Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints, “Configure cloudFiles.schemaLocation separately from the stream checkpointLocation” could be relevant. Configure destination catalog and schema in the Lakeflow Connect pipeline.

C:

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. Configure destination catalog and schema in the Lakeflow Connect pipeline.

D:

When a customer source cannot accept newly introduced columns without explicit schema approval, “Select failOnNewColumns and institute a reviewed schema-change deployment” could be relevant. Configure destination catalog and schema in the Lakeflow Connect pipeline.

Question 107

An audit team needs stable ownership of data ingested from a managed enterprise application. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?

  1. An order with three items produces three correct item-level silver rows.
  2. The downstream record can trace each document to its source file and metadata.
  3. The stream stops for an unapproved added column until the schema is updated.
  4. The ingested tables are discoverable under the approved UC namespace and grants.

Explanation

Correct Answer

D:

The ingested tables are discoverable under the approved UC namespace and grants.

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. The ingested tables are discoverable under the approved UC namespace and grants.

B:

An application exports documents plus metadata into object storage. In those circumstances, “The downstream record can trace each document to its source file and metadata” fits. The ingested tables are discoverable under the approved UC namespace and grants.

C:

When a customer source cannot accept newly introduced columns without explicit schema approval, “The stream stops for an unapproved added column until the schema is updated” could be relevant. The ingested tables are discoverable under the approved UC namespace and grants.

Question 108

An audit team needs stable ownership of data ingested from a managed enterprise application. The team observes: The data lands in an unapproved development catalog. Which root cause should be addressed first given this evidence?

  1. Unknown fields were ignored rather than rescued for later inspection.
  2. The chosen ingestion method does not support this proprietary source.
  3. The run started without a reliable completion signal for the monthly export.
  4. The connector destination was set to the wrong catalog or schema.

Explanation

Correct Answer

D:

The connector destination was set to the wrong catalog or schema. Configure destination catalog and schema in the Lakeflow Connect pipeline.

Incorrect Answers

A:

A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. In those circumstances, “Unknown fields were ignored rather than rescued for later inspection” fits. The connector destination was set to the wrong catalog or schema.

B:

When a proprietary application has no native managed connector but a supported third-party integration, “The chosen ingestion method does not support this proprietary source” could be relevant. The connector destination was set to the wrong catalog or schema.

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 connector destination was set to the wrong catalog or schema.

Question 109

A managed enterprise-source ingestion has an initial backfill followed by periodic change updates. Which technical design is most appropriate for the stated constraint?

  1. Prefer managed Lakeflow Connect over custom API extraction when source features fit.
  2. Choose COPY INTO for a simple repeatable bulk import.
  3. Keep unexpected fields in a rescued-data column for later triage.
  4. Choose a managed connector workflow supporting an initial snapshot and subsequent sync.

Explanation

Correct Answer

D:

Choose a managed connector workflow supporting an initial snapshot and subsequent sync. Historical rows appear first and later changes are reflected without full custom reimports.

Incorrect Answers

A:

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. Choose a managed connector workflow supporting an initial snapshot and subsequent sync.

B:

If a static set of archive files must be loaded once through SQL with minimal pipeline machinery, “Choose COPY INTO for a simple repeatable bulk import” may be the appropriate response. Choose a managed connector workflow supporting an initial snapshot and subsequent sync.

C:

A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. In those circumstances, “Keep unexpected fields in a rescued-data column for later triage” fits. Choose a managed connector workflow supporting an initial snapshot and subsequent sync.

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.

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.