Databricks Certified Data Engineer Associate Practice Test 47
Question 460
At Online apparel cooperative, the customer order changes workflow depends on customer_order_changes_west. Engineers report that customer_order_changes_west 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 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?
- Deploy a nonproduction copy with unique resource namespace and service identity
- Run destructive test inputs and verify production table remains unchanged
- Compare target resolution, workspace URL and catalog bindings for customer_order_changes_west
- Use identical production destinations and hope developers avoid dangerous input at Online apparel cooperative
Explanation
Correct Answer
B:Run destructive test inputs and verify production table remains unchanged directly tests the behavior that should change after the correction. With the observed evidence (resolved bundle targets point to the same UC prefix), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that development tests must not mutate production data.
Incorrect Answers
A: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 post-change acceptance test, especially given the evidence that resolved bundle targets point to the same UC prefix.
C:Compare target resolution, workspace URL and catalog bindings for customer_order_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 customer_order_changes_west workflow still requires that development tests must not mutate production data.
D:Shared output targets defeat environment isolation. The proposed action (Use identical production destinations and hope developers avoid dangerous input at Online apparel cooperative) does not meet the requirement that development tests must not mutate production data, nor does it constitute the post-change acceptance test.
Question 461
At Community energy cooperative, the smart meter readings workflow depends on smart_meter_readings_central. Engineers report that smart_meter_readings_central automation configuration contains an API password committed to Git; the evidence is that repository scan detects a plaintext production secret in bundle variables. They require that configuration must remain reproducible without exposing secrets. The first acceptance run passed. The current task is to detect future regressions and changes over time. Which ongoing alert or metric is most relevant?
- Monitor exposed credentials and unexpected secret-version access for smart_meter_readings_central
- Scan the repo and deploy in staging to verify secrets are not printed
- Reference approved secret storage or injected CI variables rather than plaintext passwords
- Hide the password by renaming its variable key at Community energy cooperative
Explanation
Correct Answer
A:Monitor exposed credentials and unexpected secret-version access for smart_meter_readings_central creates recurring visibility into the failure mode (smart_meter_readings_central automation configuration contains an API password committed to Git). Unlike a single successful test, the measure can reveal drift, lag, or new failures after later source and deployment changes while configuration must remain reproducible without exposing secrets.
Incorrect Answers
B:Scan the repo and deploy in staging to verify secrets are not printed is a one-time acceptance check. It does not supply continuing operational detection for smart_meter_readings_central; a passing test cannot substitute for the specific task now required.
C:Reference approved secret storage or injected CI variables rather than plaintext passwords is a plausible lasting design once chosen, but it does not perform continuing operational detection at this stage. In the smart_meter_readings_central scenario, the observed evidence is that repository scan detects a plaintext production secret in bundle variables; the requirement remains: configuration must remain reproducible without exposing secrets.
D:Renaming a plaintext secret does not protect it. The proposed action (Hide the password by renaming its variable key at Community energy cooperative) does not meet the requirement that configuration must remain reproducible without exposing secrets, nor does it constitute continuing operational detection.
Question 462
Consider the customer_order_changes_west workload at Online apparel cooperative: customer_order_changes_west contractor group needs read-only curated aggregates but can edit source tables. Inspection found that privilege audit shows broad write grants inherited from a project role. The governed outcome must ensure that group must query approved output without data modification. 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?
- Grant ALL PRIVILEGES on the entire catalog to a read-only group at Online apparel cooperative
- Replace broad grants through a staged permission change with rollback
- Run SELECT and attempted INSERT as contractor to confirm read-only behavior
- Identify group membership, inherited privileges and accessible tables for customer_order_changes_west
Explanation
Correct Answer
C:Run SELECT and attempted INSERT as contractor to confirm read-only behavior directly tests the behavior that should change following the correction. With the observed evidence (privilege audit shows broad write grants inherited from a project role), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that group must query approved output without data modification.
Incorrect Answers
A:All privileges violate read-only requirement. The proposed action (Grant ALL PRIVILEGES on the entire catalog to a read-only group at Online apparel cooperative) does not meet the requirement that group must query approved output without data modification, nor does it constitute the post-change acceptance test.
B:Replace broad grants through a staged permission change with rollback 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 privilege audit shows broad write grants inherited from a project role. This matters here because consider the customer_order_changes_west workload at Online apparel cooperative: customer_order_changes_west….
D:Identify group membership, inherited privileges and accessible tables for customer_order_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 customer_order_changes_west workflow still requires that group must query approved output without data modification.
Question 463
The clinical_appointment_reports_island pipeline at Regional hospital network has this failure: clinical_appointment_reports_island failed halfway through a historical backfill, and a rerun doubles completed partitions. The team observed that run log records successfully committed early dates before failure. Business requirement: recovery must replay only incomplete work or be provably idempotent. 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?
- List committed partitions, failed tasks and source batch identifiers for clinical_appointment_reports_island
- Restart from the failure boundary and verify no partition is doubled
- Resume the backfill on a tested subset without changing good partitions
- Append the entire historical dataset on every restart at Regional hospital network
Explanation
Correct Answer
B:Restart from the failure boundary and verify no partition is doubled directly tests the behavior that should change following the correction. With the observed evidence (run log records successfully committed early dates before failure), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that recovery must replay only incomplete work or be provably idempotent.
Incorrect Answers
A:List committed partitions, failed tasks and source batch identifiers for clinical_appointment_reports_island could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The clinical_appointment_reports_island workflow still requires that recovery must replay only incomplete work or be provably idempotent.
C:Resume the backfill on a tested subset without changing good partitions 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 run log records successfully committed early dates before failure. This matters here because the clinical_appointment_reports_island pipeline at Regional hospital network has this failure:….
D:Unconditional append duplicates earlier successful partitions. The proposed action (Append the entire historical dataset on every restart at Regional hospital network) does not meet the requirement that recovery must replay only incomplete work or be provably idempotent, nor does it constitute the post-change acceptance test.
Question 464
At Retail pharmacy network, the inventory adjustments workflow depends on inventory_adjustments_rural. Engineers report that inventory_adjustments_rural managed table has manual OPTIMIZE jobs colliding with platform-managed maintenance; the evidence is that table maintenance history shows overlapping compaction attempts. They require that the maintenance policy must avoid redundant cost and scheduling conflict. 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?
- Disable the overlapping manual maintenance after verifying managed policy
- Manually VACUUM all data files before retention safeguards are checked at Retail pharmacy network
- Compare file counts, query results and maintenance cost across a full cycle
- Inspect table eligibility, predictive optimization configuration and maintenance history for inventory_adjustments_rural
Explanation
Correct Answer
C:Compare file counts, query results and maintenance cost across a full cycle directly tests the behavior that should change following the correction. With the observed evidence (table maintenance history shows overlapping compaction attempts), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that the maintenance policy must avoid redundant cost and scheduling conflict.
Incorrect Answers
A:Disable the overlapping manual maintenance after verifying managed policy 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 table maintenance history shows overlapping compaction attempts. Here, the relevant situation is: the inventory adjustments workflow depends on inventory_adjustments_rural. Engineers report that….
B:Unguarded vacuum can remove files needed for recovery. The proposed action (Manually VACUUM all data files before retention safeguards are checked at Retail pharmacy network) does not meet the requirement that the maintenance policy must avoid redundant cost and scheduling conflict, nor does it constitute the post-change acceptance test.
D:Inspect table eligibility, predictive optimization configuration and maintenance history for inventory_adjustments_rural could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The inventory_adjustments_rural workflow still requires that the maintenance policy must avoid redundant cost and scheduling conflict.
Question 465
The property_reservation_updates_island pipeline at Multi-region rental platform has this failure: property_reservation_updates_island notebook occasionally fails on transient service throttling. The team observed that task failure records show HTTP 429 followed by a successful manual retry. Business requirement: safe retries must not create duplicate output or run indefinitely. 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?
- Inject a temporary failure and verify eventual success without duplicated rows
- Inspect transient error types, output idempotency and historical retry behavior for property_reservation_updates_island
- Enable retries on a noncritical task and use replay-safe output writes
- Set infinite immediate retries for every failure including invalid SQL at Multi-region rental platform
Explanation
Correct Answer
A:Inject a temporary failure and verify eventual success without duplicated rows directly tests the behavior that should change after the correction. With the observed evidence (task failure records show HTTP 429 followed by a successful manual retry), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that safe retries must not create duplicate output or run indefinitely.
Incorrect Answers
B:Inspect transient error types, output idempotency and historical retry behavior for property_reservation_updates_island could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The property_reservation_updates_island workflow still requires that safe retries must not create duplicate output or run indefinitely.
C:Enable retries on a noncritical task and use replay-safe output writes 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 task failure records show HTTP 429 followed by a successful manual retry.
D:Unbounded retries can overload services and conceal deterministic defects. The proposed action (Set infinite immediate retries for every failure including invalid SQL at Multi-region rental platform) does not meet the requirement that safe retries must not create duplicate output or run indefinitely, nor does it constitute the post-change acceptance test.
Question 466
The citizen_service_applications_central pipeline at Local government portal has this failure: citizen_service_applications_central analysts need occasional queries of an external warehouse without full bulk ingestion. The team observed that source data is large but analytics needs a small live subset. Business requirement: governance should provide on-demand read access without an unnecessary copy. The team has not selected a remedy. It first needs evidence that distinguishes the actual dependency or data fault. What should the engineer inspect to establish the failure mechanism?
- Use Lakehouse Federation connection and foreign catalog for suitable source queries
- Assess external connector support, latency and predicate pushdown for citizen_service_applications_central
- Configure a scoped connection and grant access to a test foreign table
- Copy the entire external database daily regardless of query demand at Local government portal
Explanation
Correct Answer
B:Assess external connector support, latency and predicate pushdown for citizen_service_applications_central directly investigates the evidence (source data is large but analytics needs a small live subset) and distinguishes possible causes of citizen_service_applications_central analysts need occasional queries of an external warehouse without full bulk ingestion. It establishes what must be corrected without assuming a fix before verifying the stated business requirement: governance should provide on-demand read access without an unnecessary copy.
Incorrect Answers
A:Use Lakehouse Federation connection and foreign catalog for suitable source queries is a plausible lasting design once chosen, but it does not perform the required pre-change investigation at this stage. In the citizen_service_applications_central scenario, the observed evidence is that source data is large but analytics needs a small live subset; the requirement remains: governance should provide on-demand read access without an unnecessary copy.
C:Configure a scoped connection and grant access to a test foreign table 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 data is large but analytics needs a small live subset. This matters here because the citizen_service_applications_central pipeline at Local government portal has this failure:….
D:Full-copy ingestion is not required for selective federated querying. The proposed action (Copy the entire external database daily regardless of query demand at Local government portal) does not meet the requirement that governance should provide on-demand read access without an unnecessary copy, nor does it constitute the required pre-change investigation.
Question 467
A data engineer at International coffee retailer is responsible for point-of-sale receipts. The source method selection issue is that the point_of_sale_receipts_east producer is a managed enterprise database but engineers plan a custom nightly file scraper. The supporting evidence is that evaluation finds supported managed CDC connector and tight freshness targets. The engineer must ensure that data must reach Unity Catalog with near-real-time change capture. 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?
- Use monthly manual CSV downloads for a near-real-time feed at International coffee retailer
- Pilot managed CDC for a bounded table before removing the nightly export
- Compare connector support, freshness SLA, cost and source load for point_of_sale_receipts_east
- Update and delete source rows and validate resulting Delta state
Explanation
Correct Answer
D:Update and delete source rows and validate resulting Delta state directly tests the behavior that should change after the correction. With the observed evidence (evaluation finds supported managed CDC connector and tight freshness targets), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that data must reach Unity Catalog with near-real-time change capture.
Incorrect Answers
A:Manual batch exports cannot meet continuous change freshness. The proposed action (Use monthly manual CSV downloads for a near-real-time feed at International coffee retailer) does not meet the requirement that data must reach Unity Catalog with near-real-time change capture, nor does it constitute the post-change acceptance test.
B:Pilot managed CDC for a bounded table before removing the nightly export 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 evaluation finds supported managed CDC connector and tight freshness targets.
C:Compare connector support, freshness SLA, cost and source load for point_of_sale_receipts_east could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The point_of_sale_receipts_east workflow still requires that data must reach Unity Catalog with near-real-time change capture.
Question 468
At Air quality nonprofit, the Spark SQL NULL semantics workflow handles pollution measurements. The problem is that pollution_measurements_central SQL filter misses transactions where the nullable flag was never populated. Evidence: the predicate uses flag = NULL and always yields unknown. Constraint: the analysis must distinguish missing from explicitly false flag values. 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?
- Inspect null frequency and three-valued SQL logic for pollution_measurements_central
- Monitor unknown-flag rate and predicate regression for pollution_measurements_central
- Use IS NULL for missing flags and IS NOT NULL for populated fields
- Use flag = NULL and assume it matches missing values at Air quality nonprofit
Explanation
Correct Answer
C:Use IS NULL for missing flags and IS NOT NULL for populated fields is the intended durable approach for pollution_measurements_central: it addresses the verified problem (pollution_measurements_central SQL filter misses transactions where the nullable flag was never populated) while preserving the required behavior (the analysis must distinguish missing from explicitly false flag values). A diagnostic or monitoring step alone would not create this target-state behavior.
Incorrect Answers
A:Inspect null frequency and three-valued SQL logic for pollution_measurements_central could clarify the original fault, but the available evidence already establishes its scope; it is not the target approach now requested. The pollution_measurements_central workflow still requires that the analysis must distinguish missing from explicitly false flag values.
B:Monitor unknown-flag rate and predicate regression for pollution_measurements_central would help detect future recurrence, but metrics alone do not deliver the target approach. The pollution_measurements_central requirement is that the analysis must distinguish missing from explicitly false flag values.
D:Sql equality against null is not true. The proposed action (Use flag = NULL and assume it matches missing values at Air quality nonprofit) does not meet the requirement that the analysis must distinguish missing from explicitly false flag values, nor does it constitute the target approach.
Question 469
A data engineer at Multi-region rental platform is responsible for property reservation updates. The Auto Loader checkpoint issue is that a streaming file reader for property_reservation_updates_highland reprocesses historical data after every job restart. The supporting evidence is that the streaming query creates a new checkpoint directory on each run. The engineer must ensure that a restart must resume discovered files instead of replaying all existing input. 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?
- Deploy the stream with a durable checkpoint and restart the same logical query
- Restart after a micro-batch and confirm no duplicate file ingestion
- Delete checkpoint state as part of each successful load at Multi-region rental platform
- Inspect checkpoint continuity, discovery progress and input file identifiers
Explanation
Correct Answer
B:Restart after a micro-batch and confirm no duplicate file ingestion directly tests the behavior that should change after the correction. With the observed evidence (the streaming query creates a new checkpoint directory on each run), the acceptance result must demonstrate actual data or permission correctness, while retaining the requirement that a restart must resume discovered files instead of replaying all existing input.
Incorrect Answers
A:Deploy the stream with a durable checkpoint and restart the same logical query 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 the streaming query creates a new checkpoint directory on each run.
C:Deleting checkpoint progress can cause full replay. The proposed action (Delete checkpoint state as part of each successful load at Multi-region rental platform) does not meet the requirement that a restart must resume discovered files instead of replaying all existing input, nor does it constitute the post-change acceptance test.
D:Inspect checkpoint continuity, discovery progress and input file identifiers could clarify the original fault, but the available evidence already establishes its scope; it is not the post-change acceptance test now requested. The property_reservation_updates_highland workflow still requires that a restart must resume discovered files instead of replaying all existing input.
Question 470
Consider the shipment_manifests_west workload at Coastal freight alliance: shipment_manifests_west access exception uses a DENY policy without verifying feature support and scope. Inspection found that review finds the target resource is outside the supported ABAC deny-policy securable types. The governed outcome must ensure that authorization must use supported policy semantics without assuming beta behavior. The target approach is approved. The current task is to introduce it safely with bounded scope and rollback. Which staged rollout best preserves the existing workload?
- Use supported UC grants and only supported ABAC deny policies where available
- Pilot the policy in a test catalog and confirm evaluation result
- Assume any DENY syntax universally applies to all Unity Catalog objects at Coastal freight alliance
- Test denied and permitted identities on the exact target object
Explanation
Correct Answer
B:Pilot the policy in a test catalog and confirm evaluation result provides a bounded way to introduce the approved solution into shipment_manifests_west and detect an early mismatch. The existing signal is review finds the target resource is outside the supported ABAC deny-policy securable types; a staged change protects the service requirement (authorization must use supported policy semantics without assuming beta behavior) and makes rollback practical.
Incorrect Answers
A:Use supported UC grants and only supported ABAC deny policies where available is a plausible lasting design once chosen, but it does not perform the controlled implementation step at this stage. In the shipment_manifests_west scenario, the observed evidence is that review finds the target resource is outside the supported ABAC deny-policy securable types; the requirement remains: authorization must use supported policy semantics without assuming beta behavior.
C:Beta deny policy semantics are not universal to every securable type. The proposed action (Assume any DENY syntax universally applies to all Unity Catalog objects at Coastal freight alliance) does not meet the requirement that authorization must use supported policy semantics without assuming beta behavior, nor does it constitute the controlled implementation step.
D:Test denied and permitted identities on the exact target object is a one-time acceptance check. It does not supply the controlled implementation step for shipment_manifests_west; a passing test cannot substitute for the specific task now required.