100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 140
A static set of archive files must be loaded once through SQL with minimal pipeline machinery. The team observes: A streaming cluster runs indefinitely after the one-time archive import. Which root cause should be addressed first given this evidence?
- The managed ingestion schedule or ongoing sync was never activated.
- The COPY INTO source selection did not restrict ingestion to JSON input.
- The pipeline appended update records without matching them to existing keys.
- A continuously active stream was chosen for an essentially one-off load.
Explanation
Correct Answer
D:A continuously active stream was chosen for an essentially one-off load. Configure a one-time COPY INTO statement against the approved Delta table.
Incorrect Answers
A:If a managed enterprise-source ingestion has an initial backfill followed by periodic change updates, “The managed ingestion schedule or ongoing sync was never activated” may be the appropriate response. A continuously active stream was chosen for an essentially one-off load.
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. A continuously active stream was chosen for an essentially one-off load.
C:When a partner publishes corrected records with stable business keys in each incremental delivery, “The pipeline appended update records without matching them to existing keys” could be relevant. A continuously active stream was chosen for an essentially one-off load.
Question 141
A real-time event feed has no cloud-object landing area and is delivered over an event broker. Which technical design is most appropriate for the stated constraint?
- Use a notebook-based JDBC extraction through a governed ingestion job.
- Choose a streaming connector that supports the event source rather than file-notification ingestion.
- Use Auto Loader schema inference and managed column evolution with restart handling.
- Use null-safe extraction and a stable target schema for optional nested fields.
Explanation
Correct Answer
B:Choose a streaming connector that supports the event source rather than file-notification ingestion. New broker events reach the target without first creating object-store files.
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. Choose a streaming connector that supports the event source rather than file-notification ingestion.
C:If an Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked, “Use Auto Loader schema inference and managed column evolution with restart handling” may be the appropriate response. Choose a streaming connector that supports the event source rather than file-notification ingestion.
D:A JSON API occasionally omits nested optional customer attributes. In those circumstances, “Use null-safe extraction and a stable target schema for optional nested fields” fits. Choose a streaming connector that supports the event source rather than file-notification ingestion.
Question 142
A real-time event feed has no cloud-object landing area and is delivered over an event broker. Which action should the engineer perform to establish the intended control?
- Configure schema rescue and inspect _rescued_data for the source record.
- Store both timestamps and make event-time handling explicit in downstream transformations.
- Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
- Read the stream with an appropriate source and durable checkpoint, then write to a Delta sink.
Explanation
Correct Answer
C:Configure an approved Structured Streaming source for the broker and Delta target checkpoint. New broker events reach the target without first creating object-store files.
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. Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
B:If a vendor's data source sends records with event timestamps older than ingestion time, “Store both timestamps and make event-time handling explicit in downstream transformations” may be the appropriate response. Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
D:When 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” could be relevant. Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
Question 143
A real-time event feed has no cloud-object landing area and is delivered over an event broker. Which observation best proves the workload meets its requirement?
- All pages are ingested once and a rate-limit response is retried safely.
- A recent test event appears in the target within the required latency budget.
- New broker events reach the target without first creating object-store files.
- Records without optional values still load while mandatory fields are validated.
Explanation
Correct Answer
C:New broker events reach the target without first creating object-store files.
Incorrect Answers
A:If an external service exposes a paginated REST endpoint with rate limits and no managed connector, “All pages are ingested once and a rate-limit response is retried safely” may be the appropriate response. New broker events reach the target without first creating object-store files.
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. New broker events reach the target without first creating object-store files.
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. New broker events reach the target without first creating object-store files.
Question 144
A real-time event feed has no cloud-object landing area and is delivered over an event broker. The team observes: No events arrive even though the broker offsets keep advancing. Which underlying cause most directly explains this failure?
- The transformation treated a nonessential nested field as mandatory.
- The checkpoint location changed, making the restarted stream a new query.
- The job uses Auto Loader cloudFiles against a broker-only event source.
- The run started without a reliable completion signal for the monthly export.
Explanation
Correct Answer
C:The job uses Auto Loader cloudFiles against a broker-only event source. Configure an approved Structured Streaming source for the broker and Delta target checkpoint.
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 job uses Auto Loader cloudFiles against a broker-only event source.
B:When a streaming ingestion restarts after maintenance and must continue from its last committed progress, “The checkpoint location changed, making the restarted stream a new query” could be relevant. The job uses Auto Loader cloudFiles against a broker-only event source.
D:A finance feed is delivered as one vetted CSV export at the end of each month. In those circumstances, “The run started without a reliable completion signal for the monthly export” fits. The job uses Auto Loader cloudFiles against a broker-only event source.
Question 145
An order feed supplies JSON objects with nested arrays of items. Which design choice best addresses the stated business and technical requirement?
- Choose a streaming connector that supports the event source rather than file-notification ingestion.
- Write connector outputs into the correct governed Unity Catalog catalog and schema.
- Use an authorized connection identity with the minimum required source permissions.
- Preserve the nested data at bronze and explicitly flatten items for the serving table.
Explanation
Correct Answer
D:Preserve the nested data at bronze and explicitly flatten items for the serving table. An order with three items produces three correct item-level silver rows.
Incorrect Answers
A:When a real-time event feed has no cloud-object landing area and is delivered over an event broker, “Choose a streaming connector that supports the event source rather than file-notification ingestion” could be relevant. Preserve the nested data at bronze and explicitly flatten items for the serving table.
B:If an audit team needs stable ownership of data ingested from a managed enterprise application, “Write connector outputs into the correct governed Unity Catalog catalog and schema” may be the appropriate response. Preserve the nested data at bronze and explicitly flatten items for the serving table.
C:An ERP table is replicated through a managed connector but its ingestion account lacks read access. In those circumstances, “Use an authorized connection identity with the minimum required source permissions” fits. Preserve the nested data at bronze and explicitly flatten items for the serving table.
Question 146
An order feed supplies JSON objects with nested arrays of items. Which setup step most directly realizes the proposed design?
- Parse the items as an array and use explode for one output row per element.
- Configure cloudFiles.schemaLocation separately from the stream checkpointLocation.
- Keep the COPY INTO target and source identity stable across reruns.
- Configure the supported connector pipeline and its schedule or update cadence.
Explanation
Correct Answer
A:Parse the items as an array and use explode for one output row per element. An order with three items produces three correct item-level silver rows.
Incorrect Answers
B:An Auto Loader job reads many new files and needs to persist inferred schema changes independently of checkpoints. In those circumstances, “Configure cloudFiles.schemaLocation separately from the stream checkpointLocation” fits. Parse the items as an array and use explode for one output row per element.
C:When 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” could be relevant. Parse the items as an array and use explode for one output row per element.
D:If a managed enterprise-source ingestion has an initial backfill followed by periodic change updates, “Configure the supported connector pipeline and its schedule or update cadence” may be the appropriate response. Parse the items as an array and use explode for one output row per element.
Question 147
An order feed supplies JSON objects with nested arrays of items. What is the most relevant verification evidence for this case?
- Partner-sourced records pass lineage and permission checks in the target.
- The ingested tables are discoverable under the approved UC namespace and grants.
- After the controlled restart the new column appears in the schema and rows are processed.
- An order with three items produces three correct item-level silver rows.
Explanation
Correct Answer
D:An order with three items produces three correct item-level silver rows.
Incorrect Answers
A: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. An order with three items produces three correct item-level silver rows.
B:When an audit team needs stable ownership of data ingested from a managed enterprise application, “The ingested tables are discoverable under the approved UC namespace and grants” could be relevant. An order with three items produces three correct item-level silver rows.
C:If an Auto Loader JSON feed adds optional fields during the quarter and schema changes must be tracked, “After the controlled restart the new column appears in the schema and rows are processed” may be the appropriate response. An order with three items produces three correct item-level silver rows.
Question 148
An order feed supplies JSON objects with nested arrays of items. The team observes: Only the first line item appears for each multi-item order. What is the most likely mechanism behind the observed defect?
- Rescue behavior or the required rescued-data column was not configured for this source.
- The pipeline treated an array as one scalar field instead of exploding its elements.
- Unknown fields were ignored rather than rescued for later inspection.
- The chosen ingestion method does not support this proprietary source.
Explanation
Correct Answer
B:The pipeline treated an array as one scalar field instead of exploding its elements. Parse the items as an array and use explode for one output row per element.
Incorrect Answers
A:When 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” could be relevant. The pipeline treated an array as one scalar field instead of exploding its elements.
C: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 pipeline treated an array as one scalar field instead of exploding its elements.
D: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 pipeline treated an array as one scalar field instead of exploding its elements.
Question 149
A JSON API occasionally omits nested optional customer attributes. Which approach most directly satisfies the requirement?
- Use a notebook-based JDBC extraction through a governed ingestion job.
- Use null-safe extraction and a stable target schema for optional nested fields.
- Choose COPY INTO for a simple repeatable bulk import.
- Use a continuously updating Structured Streaming ingestion pattern.
Explanation
Correct Answer
B:Use null-safe extraction and a stable target schema for optional nested fields. Records without optional values still load while mandatory fields are validated.
Incorrect Answers
A:If a niche on-premises database lacks a supported managed connector but allows JDBC reads, “Use a notebook-based JDBC extraction through a governed ingestion job” may be the appropriate response. Use null-safe extraction and a stable target schema for optional nested fields.
C:When 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” could be relevant. Use null-safe extraction and a stable target schema for optional nested fields.
D: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 null-safe extraction and a stable target schema for optional nested fields.
Question 150
A JSON API occasionally omits nested optional customer attributes. Which configuration or engineering action would most directly implement the requirement?
- Configure schema rescue and inspect _rescued_data for the source record.
- Implement cursor handling, throttling backoff, and idempotent writes to the bronze table.
- Parse nested keys with supported accessors and apply an explicit missing-value rule.
- Create the connector connection and managed ingestion pipeline with UC destinations.
Explanation
Correct Answer
C:Parse nested keys with supported accessors and apply an explicit missing-value rule. Records without optional values still load while mandatory fields are validated.
Incorrect Answers
A:A JSON source contains additional nested keys that are not part of a strongly typed downstream contract. In those circumstances, “Configure schema rescue and inspect _rescued_data for the source record” fits. Parse nested keys with supported accessors and apply an explicit missing-value rule.
B:When 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” could be relevant. Parse nested keys with supported accessors and apply an explicit missing-value rule.
D:A CRM administrator wants managed incremental ingestion into governed Databricks tables without writing custom REST pagination. In those circumstances, “Create the connector connection and managed ingestion pipeline with UC destinations” fits. Parse nested keys with supported accessors and apply an explicit missing-value rule.
Certified Data Engineer Associate Practice Tests