Databricks Certified Data Engineer Associate Practice Test 75
Question 740
At Cloud gaming cooperative, the match-session events workflow depends on match_session_events_urban. Engineers report that match_session_events_urban test run overwrites production tables because both deployment targets share one catalog; the evidence is that resolved bundle targets point to the same UC prefix. They require that development tests must not mutate production data. The team has not selected a remedy. It first needs evidence that distinguishes the actual dependency or data fault. Which pre-change diagnostic will resolve the uncertainty?
- Use identical production destinations and hope developers avoid dangerous input at Cloud gaming cooperative
- Deploy a nonproduction copy with unique resource namespace and service identity
- Segregate dev/test/prod catalog settings using bundle target overrides
- Compare target resolution, workspace URL and catalog bindings for match_session_events_urban
Explanation
Correct Answer
D:Compare target resolution, workspace URL and catalog bindings for match_session_events_urban directly investigates the evidence (resolved bundle targets point to the same UC prefix) and distinguishes possible causes of match_session_events_urban test run overwrites production tables because both deployment targets share one catalog. It establishes what must be corrected without assuming a fix before verifying the stated business requirement: development tests must not mutate production data.
Incorrect Answers
A:Shared output targets defeat environment isolation. The proposed action (Use identical production destinations and hope developers avoid dangerous input at Cloud gaming cooperative) does not meet the requirement that development tests must not mutate production data, nor does it constitute the required pre-change investigation.
B:Deploy a nonproduction copy with unique resource namespace and service identity may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the required pre-change investigation, especially given the evidence that resolved bundle targets point to the same UC prefix. Here, the relevant situation is: the match-session events workflow depends on match_session_events_urban. Engineers report that….
C:Segregate dev/test/prod catalog settings using bundle target overrides is a plausible lasting design once chosen, but it does not perform the required pre-change investigation at this stage. In the match_session_events_urban scenario, the observed evidence is that resolved bundle targets point to the same UC prefix; the requirement remains: development tests must not mutate production data.
Question 741
The smart_meter_readings_metro pipeline at Community energy cooperative has this failure: BI users query smart_meter_readings_metro through engineering notebook compute with unpredictable startup and permissions. The team observed that query history shows short read-only dashboards competing with development Spark sessions. Business requirement: analysts need governed SQL concurrency and stable refresh latency. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. What test most directly proves the requirement is satisfied?
- Migrate one dashboard and verify warehouse permissions and query plans
- Run representative concurrent queries and compare latency and spend
- Grant BI users unrestricted notebook cluster administration at Community energy cooperative
- Classify smart_meter_readings_metro query mix, concurrency and compute isolation requirements
Explanation
Correct Answer
B:Run representative concurrent queries and compare latency and spend directly tests the behavior that should change following the correction. With the observed evidence (query history shows short read-only dashboards competing with development Spark sessions), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that analysts need governed SQL concurrency and stable refresh latency.
Incorrect Answers
A:Migrate one dashboard and verify warehouse permissions and query plans may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that query history shows short read-only dashboards competing with development Spark sessions. This matters here because the smart_meter_readings_metro pipeline at Community energy cooperative has this failure: BI users query….
C:Broad compute administration is not necessary to query governed bi data. The proposed action (Grant BI users unrestricted notebook cluster administration at Community energy cooperative) does not meet the requirement that analysts need governed SQL concurrency and stable refresh latency, nor does it constitute the post-change acceptance test.
D:Classify smart_meter_readings_metro query mix, concurrency and compute isolation requirements could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The smart_meter_readings_metro workflow still requires that analysts need governed SQL concurrency and stable refresh latency.
Question 742
Consider the consent_related_data_changes_west workload at Research clinical trial group: the consent_related_data_changes_west relational source emits inserts and updates but the lakehouse target retains multiple current versions. Inspection found that change records carry primary keys and update sequence numbers. The governed outcome must ensure that the destination must represent the latest source state without losing required history. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. How should the team verify the original fault has been addressed?
- Inspect key uniqueness, update order and delete semantics in consent_related_data_changes_west
- Append every change as a new current row without keys at Research clinical trial group
- Apply multiple out-of-order changes and verify deterministic final state
- Introduce change capture on a small table and reconcile the initial snapshot
Explanation
Correct Answer
C:Apply multiple out-of-order changes and verify deterministic final state directly tests the behavior that should change after the correction. With the observed evidence (change records carry primary keys and update sequence numbers), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that the destination must represent the latest source state without losing required history. This matters here because consider the consent_related_data_changes_west workload at Research clinical trial group: the….
Incorrect Answers
A:Inspect key uniqueness, update order and delete semantics in consent_related_data_changes_west could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The consent_related_data_changes_west workflow still requires that the destination must represent the latest source state without losing required history.
B:An append-only current-state table does not resolve updates or deletes. The proposed action (Append every change as a new current row without keys at Research clinical trial group) does not meet the requirement that the destination must represent the latest source state without losing required history, nor does it constitute the post-change acceptance test.
D:Introduce change capture on a small table and reconcile the initial snapshot may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that change records carry primary keys and update sequence numbers. This matters here because consider the consent_related_data_changes_west workload at Research clinical trial group: the….
Question 743
At International language school, the class enrollment data workflow depends on class_enrollment_data_delta. Engineers report that the class_enrollment_data_delta partner API returns 100 rows per page but the batch stores only the first page; the evidence is that response metadata includes a next cursor that the client ignores. They require that all authorized records must be imported without exceeding API limits. The failure and requirements have been diagnosed; the team must select the lasting pipeline or governance approach. Which platform or PySpark choice best fits the stated semantics?
- Stop after one successful HTTP 200 response at International language school
- Inspect response cursor, throttle status and stable identity for class_enrollment_data_delta
- Implement cursor pagination with bounded retries and idempotent destination keys
- Monitor page completeness, retries and expired cursors for class_enrollment_data_delta
Explanation
Correct Answer
C:Implement cursor pagination with bounded retries and idempotent destination keys is the intended durable approach for class_enrollment_data_delta: it addresses the verified problem (the class_enrollment_data_delta partner API returns 100 rows per page but the batch stores only the first page) while preserving the required behavior (all authorized records must be imported without exceeding API limits). A diagnostic or monitoring step alone would not create this target-state behavior.
Incorrect Answers
A:A successful first page does not establish completeness. The proposed action (Stop after one successful HTTP 200 response at International language school) does not meet the requirement that all authorized records must be imported without exceeding API limits, nor does it constitute the target approach.
B:Inspect response cursor, throttle status and stable identity for class_enrollment_data_delta could clarify the original fault, but the available evidence already establishes its scope; it is not the target approach now requested. The class_enrollment_data_delta workflow still requires that all authorized records must be imported without exceeding API limits.
D:Monitor page completeness, retries and expired cursors for class_enrollment_data_delta would help detect future recurrence, but metrics alone do not deliver the target approach. The class_enrollment_data_delta requirement is that all authorized records must be imported without exceeding API limits.
Question 744
Consider the turbine_sensor_messages_east workload at Renewable energy operator: the turbine_sensor_messages_east SQL source is polled hourly but every run extracts its entire ten-year table. Inspection found that source query logs show full scans despite an indexed updated_at column. The governed outcome must ensure that new and changed rows must load with a replay-safe high-water mark. The team has not selected a remedy. It first needs evidence that distinguishes the actual dependency or data fault. Which evidence-gathering action should precede an architectural change?
- Verify update timestamp semantics, primary keys and late-arrival window for turbine_sensor_messages_east
- Run an initial backfill, then advance a tested watermark only after successful commit
- Use bounded incremental JDBC reads with a persisted watermark and merge keys
- Advance the stored watermark before persisting the extracted batch at Renewable energy operator
Explanation
Correct Answer
A:Verify update timestamp semantics, primary keys and late-arrival window for turbine_sensor_messages_east directly investigates the evidence (source query logs show full scans despite an indexed updated_at column) and distinguishes possible causes of the turbine_sensor_messages_east SQL source is polled hourly but every run extracts its entire ten-year table. It establishes what must be corrected without assuming a fix before verifying the stated business requirement: new and changed rows must load with a replay-safe high-water mark.
Incorrect Answers
B:Run an initial backfill, then advance a tested watermark only after successful commit may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the required pre-change investigation, especially given the evidence that source query logs show full scans despite an indexed updated_at column. This matters here because consider the turbine_sensor_messages_east workload at Renewable energy operator: the turbine_sensor_messages_east….
C:Use bounded incremental JDBC reads with a persisted watermark and merge keys is a plausible lasting design once chosen, but it does not perform the required pre-change investigation at this stage. In the turbine_sensor_messages_east scenario, the observed evidence is that source query logs show full scans despite an indexed updated_at column; the requirement remains: new and changed rows must load with a replay-safe high-water mark.
D:Premature watermark advancement can lose rows on failure. The proposed action (Advance the stored watermark before persisting the extracted batch at Renewable energy operator) does not meet the requirement that new and changed rows must load with a replay-safe high-water mark, nor does it constitute the required pre-change investigation.
Question 745
At City library association, the borrower circulation events workflow depends on borrower_circulation_events_south. Engineers report that the borrower_circulation_events_south SQL source is polled hourly but every run extracts its entire ten-year table; the evidence is that source query logs show full scans despite an indexed updated_at column. They require that new and changed rows must load with a replay-safe high-water mark. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. Which post-change acceptance check is strongest?
- Modify an old row and verify incremental fetch plus merge applies its update
- Run an initial backfill, then advance a tested watermark only after successful commit
- Advance the stored watermark before persisting the extracted batch at City library association
- Verify update timestamp semantics, primary keys and late-arrival window for borrower_circulation_events_south
Explanation
Correct Answer
A:Modify an old row and verify incremental fetch plus merge applies its update directly tests the behavior that should change following the correction. With the observed evidence (source query logs show full scans despite an indexed updated_at column), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that new and changed rows must load with a replay-safe high-water mark.
Incorrect Answers
B:Run an initial backfill, then advance a tested watermark only after successful commit may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that source query logs show full scans despite an indexed updated_at column. Here, the relevant situation is: the borrower circulation events workflow depends on borrower_circulation_events_south. Engineers report that the….
C:Premature watermark advancement can lose rows on failure. The proposed action (Advance the stored watermark before persisting the extracted batch at City library association) does not meet the requirement that new and changed rows must load with a replay-safe high-water mark, nor does it constitute the post-change acceptance test.
D:Verify update timestamp semantics, primary keys and late-arrival window for borrower_circulation_events_south could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The borrower_circulation_events_south workflow still requires that new and changed rows must load with a replay-safe high-water mark.
Question 746
At Environmental inspection office, the compute workload selection workflow handles sampling field notes. The problem is that an interactive notebook cluster runs sampling_field_notes_urban every minute even when analysts are offline. Evidence: billing shows idle all-purpose compute for a deterministic scheduled transformation. Constraint: the pipeline needs reproducible cost-controlled scheduled runs. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. Which test should pass before the new flow is accepted?
- Migrate a limited workload to an automated job on the chosen compute
- Compare time of execution, compute utilization and job latency for sampling_field_notes_urban
- Resize the interactive cluster to its maximum size and keep it on overnight at Environmental inspection office
- Verify scheduled execution succeeds and compute releases after the run
Explanation
Correct Answer
D:Verify scheduled execution succeeds and compute releases following the run directly tests the behavior that should change after the correction. With the observed evidence (billing shows idle all-purpose compute for a deterministic scheduled transformation), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that the pipeline needs reproducible cost-controlled scheduled runs.
Incorrect Answers
A:Migrate a limited workload to an automated job on the chosen compute may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that billing shows idle all-purpose compute for a deterministic scheduled transformation. Here, the relevant situation is: the compute workload selection workflow handles sampling field notes. The problem is that an interactive notebook….
B:Compare time of execution, compute utilization and job latency for sampling_field_notes_urban could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The sampling_field_notes_urban workflow still requires that the pipeline needs reproducible cost-controlled scheduled runs.
C:Larger always-on interactive compute increases waste without fixing scheduling. The proposed action (Resize the interactive cluster to its maximum size and keep it on overnight at Environmental inspection office) does not meet the requirement that the pipeline needs reproducible cost-controlled scheduled runs, nor does it constitute the post-change acceptance test.
Question 747
At Optical instrument maker, the derived column withColumn workflow handles device calibration readings. The problem is that device_calibration_readings_urban needs a normalized discount amount but the pipeline overwrites the source field. Evidence: code review shows an arithmetic expression replacing original gross_sales. Constraint: auditors require gross and net amounts independently. The failure and requirements have been diagnosed; the team must select the lasting pipeline or governance approach. What governed target implementation should the engineer design?
- Overwrite the only gross amount and discard source values at Optical instrument maker
- Monitor negative net amounts and source-to-derived reconciliation for device_calibration_readings_urban
- Use withColumn to add a derived net amount while keeping gross_sales unchanged
- Inspect expression dependencies and column lineage for device_calibration_readings_urban
Explanation
Correct Answer
C:Use withColumn to add a derived net amount while keeping gross_sales unchanged is the intended durable approach for device_calibration_readings_urban: it addresses the verified problem (device_calibration_readings_urban needs a normalized discount amount but the pipeline overwrites the source field) while preserving the required behavior (auditors require gross and net amounts independently). A diagnostic or monitoring step alone would not create this target-state behavior.
Incorrect Answers
A:Overwriting original financial evidence breaks reconciliation. The proposed action (Overwrite the only gross amount and discard source values at Optical instrument maker) does not meet the requirement that auditors require gross and net amounts independently, nor does it constitute the target approach.
B:Monitor negative net amounts and source-to-derived reconciliation for device_calibration_readings_urban would help detect future recurrence, but metrics alone do not deliver the target approach. The device_calibration_readings_urban requirement is that auditors require gross and net amounts independently.
D:Inspect expression dependencies and column lineage for device_calibration_readings_urban could clarify the original fault, but the available evidence already establishes its scope; it is not the target approach now requested. The device_calibration_readings_urban workflow still requires that auditors require gross and net amounts independently.
Question 748
Consider the collection_telemetry_south workload at Municipal waste service: collection_telemetry_south ledger export is legally due at 06:00 even when no new records arrive. Inspection found that operators propose a file trigger that may not run on quiet days. The governed outcome must ensure that an empty but valid daily export must still be delivered. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. How should the team verify the original fault has been addressed?
- Deploy cron schedule with a no-new-data success path
- Use only file-arrival triggers for a mandatory daily report at Municipal waste service
- Verify whether output requirement is calendar-driven or source-event-driven for collection_telemetry_south
- Simulate a day without files and verify on-time report generation
Explanation
Correct Answer
D:Simulate a day without files and verify on-time report generation directly tests the behavior that should change following the correction. With the observed evidence (operators propose a file trigger that may not run on quiet days), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that an empty but valid daily export must still be delivered.
Incorrect Answers
A:Deploy cron schedule with a no-new-data success path may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that operators propose a file trigger that may not run on quiet days. This matters here because consider the collection_telemetry_south workload at Municipal waste service: collection_telemetry_south ledger….
B:Quiet source days would skip the required calendar delivery. The proposed action (Use only file-arrival triggers for a mandatory daily report at Municipal waste service) does not meet the requirement that an empty but valid daily export must still be delivered, nor does it constitute the post-change acceptance test.
C:Verify whether output requirement is calendar-driven or source-event-driven for collection_telemetry_south could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The collection_telemetry_south workflow still requires that an empty but valid daily export must still be delivered.
Question 749
A data engineer at Public water district is responsible for pipeline flow metrics. The Unity Catalog audit event issue is that pipeline_flow_metrics_west ownership team cannot explain who changed a sensitive table grant. The supporting evidence is that investigation lacks a query of account audit events around the change. The engineer must ensure that privilege changes require attributable evidence and retention. The new approach is deployed. The current task is to prove correct output and authorized behavior, not just successful installation. What evidence establishes that correct output is maintained?
- Configure audit log access and build an approved privilege-change report
- Identify relevant audit event source, principal, timestamp and target object for pipeline_flow_metrics_west
- Disable audit logs because granting privileges already requires admin at Public water district
- Perform a test grant and verify it appears with actor and object fields
Explanation
Correct Answer
D:Perform a test grant and verify it appears with actor and object fields directly tests the behavior that should change following the correction. With the observed evidence (investigation lacks a query of account audit events around the change), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that privilege changes require attributable evidence and retention.
Incorrect Answers
A:Configure audit log access and build an approved privilege-change report may introduce a correction, but the question does not ask for installation or migration. A rollout alone cannot replace the post-change acceptance test, especially given the evidence that investigation lacks a query of account audit events around the change. This matters here because a data engineer at Public water district is responsible for pipeline flow metrics. The Unity Catalog audit event….
B:Identify relevant audit event source, principal, timestamp and target object for pipeline_flow_metrics_west could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The pipeline_flow_metrics_west workflow still requires that privilege changes require attributable evidence and retention.
C:Administrative permissions do not replace audit evidence. The proposed action (Disable audit logs because granting privileges already requires admin at Public water district) does not meet the requirement that privilege changes require attributable evidence and retention, nor does it constitute the post-change acceptance test.
Question 750
At Satellite imagery startup, the task value passing workflow handles land-cover observations. The problem is that land_cover_observations_highland validation notebook computes the partition date but downstream tasks use yesterday by default. Evidence: logs show successful validation for one date and export for another. Constraint: the exported partition must match the validated partition. The failure and requirements have been diagnosed; the team must select the lasting pipeline or governance approach. What governed target implementation should the engineer design?
- Pass a validated task value to the dependent export task
- Inspect taskValues producer, dependency and dynamic reference in land_cover_observations_highland
- Monitor missing task values and inconsistent task parameters for land_cover_observations_highland
- Hardcode yesterday in every downstream task at Satellite imagery startup
Explanation
Correct Answer
A:Pass a validated task value to the dependent export task is the intended durable approach for land_cover_observations_highland: it addresses the verified problem (land_cover_observations_highland validation notebook computes the partition date but downstream tasks use yesterday by default) while preserving the required behavior (the exported partition must match the validated partition). A diagnostic or monitoring step alone would not create this target-state behavior.
Incorrect Answers
B:Inspect taskValues producer, dependency and dynamic reference in land_cover_observations_highland could clarify the original fault, but the available evidence already establishes its scope; it is not the target approach now requested. The land_cover_observations_highland workflow still requires that the exported partition must match the validated partition.
C:Monitor missing task values and inconsistent task parameters for land_cover_observations_highland would help detect future recurrence, but metrics alone do not deliver the target approach. The land_cover_observations_highland requirement is that the exported partition must match the validated partition.
D:Hardcoded dates can diverge from validated data. The proposed action (Hardcode yesterday in every downstream task at Satellite imagery startup) does not meet the requirement that the exported partition must match the validated partition, nor does it constitute the target approach.