Certified Data Engineer Associate Practice Test 15
Question 140
At a freight port operator, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `course_enrollments` is in scope, and the target must retain every valid late-arriving event. Before release, which acceptance test would actually demonstrate that the root problem is controlled?
- Review a platform-level availability report for `course_enrollments` without testing whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
- Run only a normal, unchanged `course_enrollments` sample and review secret access audit.
- Rotate the database credential and verify the job still retrieves it securely without exposing it in source code
- Check that the intended configuration exists for `course_enrollments` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
C:Rotate the database credential and verify the job still retrieves it securely without exposing it in source code. This reproduces the scenario-dependent condition, verifies secret access audit, JDBC effective role, notebook revisions, and scheduled job result, and directly tests whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `course_enrollments` without testing whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. Aggregate availability does not establish the behavior of affected `course_enrollments` records. It cannot replace the direct exercise: rotate the database credential and verify the job still retrieves it securely without exposing it in source code.
B:Run only a normal, unchanged `course_enrollments` sample and review secret access audit. A normal sample does not challenge hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
D:Check that the intended configuration exists for `course_enrollments` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
Question 141
At a parcel sorting company, a REST customer API imposes strict page limits and throttles large pulls, leaving the daily bronze dataset incomplete. The dataset `vehicle_arrivals` is in scope, and an interrupted delivery must be recoverable without data loss. What evidence should the engineer collect to establish the cause rather than a coincidental symptom?
- Compare the current configuration and the signed change approval, without source-row evidence
- Review completed run status and aggregate cluster health without record-level correlation
- Correlate pagination tokens, 429 responses across affected and unaffected `R034-CASE-029` runs.
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
Explanation
Correct Answer
C:Correlate pagination tokens, 429 responses across affected and unaffected `R034-CASE-029` runs.. By joining pagination tokens, 429 responses, source total, and destination row counts by page across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: a one-page REST response does not represent the complete source data, and throttling requires controlled retry. It also sets a measurable baseline for simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice.
Incorrect Answers
A:Compare the current configuration and the signed change approval, without source-row evidence. A desired configuration and approval ticket are not runtime proof. In this case they omit pagination tokens, 429 responses, source total, and destination row counts by page, the direct means of distinguishing a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
B:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with a one-page REST response does not represent the complete source data, and throttling requires controlled retry. This check never observes the affected `vehicle_arrivals` records or their causal path.
D:Inspect normal-period success metrics for the stated dataset without reproducing the source error. A healthy-run trend can be useful, but it does not expose a one-page REST response does not represent the complete source data, and throttling requires controlled retry. The failing-path pagination tokens, 429 responses, source total, and destination row counts by page has to be correlated before attributing cause.
Question 142
At a parcel sorting company, a REST customer API imposes strict page limits and throttles large pulls, leaving the daily bronze dataset incomplete. The dataset `vehicle_arrivals` is in scope, and an interrupted delivery must be recoverable without data loss. Which platform configuration or data-engineering change is most defensible?
- Increase the API page size above its published maximum; use that approach for `vehicle_arrivals`.
- Run the exact same first-page request repeatedly without a cursor; use that approach for `vehicle_arrivals`.
- Page through the API with bounded rate-limited retries and persist the ingestion watermark before scheduled Delta writes
- Ignore HTTP 429 responses and mark the job successful; use that approach for `vehicle_arrivals`.
Explanation
Correct Answer
C:Page through the API with bounded rate-limited retries and persist the ingestion watermark before scheduled Delta writes. This directly addresses a one-page REST response does not represent the complete source data, and throttling requires controlled retry. The design should be accepted only after simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice; the related operational boundary is to accept longer bounded extraction time to respect the source API contract and preserve completeness.
Incorrect Answers
A:Increase the API page size above its published maximum; use that approach for `vehicle_arrivals`. An unsupported page size will be rejected or truncated, not retrieve a complete source. For `vehicle_arrivals`, this cannot remove the causal limitation: a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
B:Run the exact same first-page request repeatedly without a cursor; use that approach for `vehicle_arrivals`. Repeated first-page reads duplicate early records while omitting later pages. For `vehicle_arrivals`, this cannot remove the causal limitation: a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
D:Ignore HTTP 429 responses and mark the job successful; use that approach for `vehicle_arrivals`. Throttled pages are missing, causing silent gaps in the destination. For `vehicle_arrivals`, this cannot remove the causal limitation: a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
Question 143
At a parcel sorting company, a REST customer API imposes strict page limits and throttles large pulls, leaving the daily bronze dataset incomplete. The dataset `vehicle_arrivals` is in scope, and an interrupted delivery must be recoverable without data loss. A teammate proposes: "Ignore HTTP 429 responses and mark the job successful." Which technical limitation is the decisive reason not to approve that specific proposal?
- Throttled pages are missing, causing silent gaps in the destination. The proposal does not repair `vehicle_arrivals`.
- Repeated first-page reads duplicate early records while omitting later pages. This would apply to an alternative change for `vehicle_arrivals`.
- Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct.
- An unsupported page size will be rejected or truncated, not retrieve a complete source. This would apply to another option for `vehicle_arrivals`.
Explanation
Correct Answer
A:Throttled pages are missing, causing silent gaps in the destination. The proposal does not repair `vehicle_arrivals`. This identifies the known limitation of the exact proposed action. Throttled pages are missing, causing silent gaps in the destination. The underlying problem remains a one-page REST response does not represent the complete source data, and throttling requires controlled retry; Page through the API with bounded rate-limited retries and persist the ingestion watermark before scheduled Delta writes instead targets that failure.
Incorrect Answers
B:Repeated first-page reads duplicate early records while omitting later pages. This would apply to an alternative change for `vehicle_arrivals`. This failure applies to the separate proposal "Run the exact same first-page request repeatedly without a cursor".
C:Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct. The case provides a concrete failing data or control path; a mere alternate theory does not address a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
D:An unsupported page size will be rejected or truncated, not retrieve a complete source. This would apply to another option for `vehicle_arrivals`. This limitation belongs to the different alternative "Increase the API page size above its published maximum". The stem calls for the specific failure of "Ignore HTTP 429 responses and mark the job successful".
Question 144
At a parcel sorting company, a REST customer API imposes strict page limits and throttles large pulls, leaving the daily bronze dataset incomplete. The dataset `vehicle_arrivals` is in scope, and an interrupted delivery must be recoverable without data loss. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Run the exact same first-page request repeatedly without a cursor
- Ignore HTTP 429 responses and mark the job successful
- Accept longer bounded extraction time to respect the source API contract and preserve completeness
- Increase the API page size above its published maximum
Explanation
Correct Answer
C:Accept longer bounded extraction time to respect the source API contract and preserve completeness. This explicitly bounds the compromise while still addressing a one-page REST response does not represent the complete source data, and throttling requires controlled retry. Acceptance relies on simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice rather than simply declaring the change complete.
Incorrect Answers
A:Run the exact same first-page request repeatedly without a cursor. Repeated first-page reads duplicate early records while omitting later pages. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
B:Ignore HTTP 429 responses and mark the job successful. Throttled pages are missing, causing silent gaps in the destination. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
D:Increase the API page size above its published maximum. An unsupported page size will be rejected or truncated, not retrieve a complete source. Monitoring after deployment does not make this approach a safe bounded tradeoff for `vehicle_arrivals`.
Question 145
At a parcel sorting company, a REST customer API imposes strict page limits and throttles large pulls, leaving the daily bronze dataset incomplete. The dataset `vehicle_arrivals` is in scope, and an interrupted delivery must be recoverable without data loss. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Run only a normal, unchanged `vehicle_arrivals` sample and review pagination tokens.
- Review a platform-level availability report for `vehicle_arrivals` without testing whether a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
- Check that the intended configuration exists for `vehicle_arrivals` and that a healthy run succeeded, without inducing the earlier failure.
- Simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice
Explanation
Correct Answer
D:Simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice. This reproduces the scenario-dependent condition, verifies pagination tokens, 429 responses, source total, and destination row counts by page, and directly tests whether a one-page REST response does not represent the complete source data, and throttling requires controlled retry is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Run only a normal, unchanged `vehicle_arrivals` sample and review pagination tokens. A normal sample does not challenge a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
B:Review a platform-level availability report for `vehicle_arrivals` without testing whether a one-page REST response does not represent the complete source data, and throttling requires controlled retry. Aggregate availability does not establish the behavior of affected `vehicle_arrivals` records. It cannot replace the direct exercise: simulate a 429 midway through a multi-page pull and verify no page is skipped or loaded twice.
C:Check that the intended configuration exists for `vehicle_arrivals` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was a one-page REST response does not represent the complete source data, and throttling requires controlled retry.
Question 146
At a hospital analytics group, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `payment_decisions` is in scope, and the target must retain every valid late-arriving event. Which correlated observation is the strongest basis for the change decision?
- Compare the saved configuration with the signed change ticket for `payment_decisions` while omitting source and output records.
- Review aggregate cluster availability and job completion for `payment_decisions` without correlating the observed error path.
- Correlate secret access audit, JDBC effective role across affected and unaffected `R034-CASE-030` runs.
- Examine only a normal successful run of `payment_decisions` and trend secret access audit without recreating the fault.
Explanation
Correct Answer
C:Correlate secret access audit, JDBC effective role across affected and unaffected `R034-CASE-030` runs.. By joining secret access audit, JDBC effective role, notebook revisions, and scheduled job result across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. It also sets a measurable baseline for rotate the database credential and verify the job still retrieves it securely without exposing it in source code.
Incorrect Answers
A:Compare the saved configuration with the signed change ticket for `payment_decisions` while omitting source and output records. A desired configuration and approval ticket are not runtime proof. In this case they omit secret access audit, JDBC effective role, notebook revisions, and scheduled job result, the direct means of distinguishing hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
B:Review aggregate cluster availability and job completion for `payment_decisions` without correlating the observed error path. A successful aggregate platform state can coexist with hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. This check never observes the affected `payment_decisions` records or their causal path.
D:Examine only a normal successful run of `payment_decisions` and trend secret access audit without recreating the fault. A healthy-run trend can be useful, but it does not expose hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. The failing-path secret access audit, JDBC effective role, notebook revisions, and scheduled job result has to be correlated before attributing cause.
Question 147
At a hospital analytics group, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `payment_decisions` is in scope, and the target must retain every valid late-arriving event. What implementation should the engineer select for the failing workflow?
- Publish the notebook to all analysts with its password redacted only in comments; use that approach for `payment_decisions`.
- Use a least-privilege credential retrieved through an approved secret facility and schedule the read through Lakeflow Jobs
- Use the same privileged database account for every analyst and job; use that approach for `payment_decisions`.
- Copy the JDBC password into a shared Delta configuration table; use that approach for `payment_decisions`.
Explanation
Correct Answer
B:Use a least-privilege credential retrieved through an approved secret facility and schedule the read through Lakeflow Jobs. This directly addresses hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. The design should be accepted only after rotate the database credential and verify the job still retrieves it securely without exposing it in source code; the related operational boundary is to retain automated access with a dedicated read-only service identity and auditable rotation.
Incorrect Answers
A:Publish the notebook to all analysts with its password redacted only in comments; use that approach for `payment_decisions`. Comments do not remove secrets from the executable connection string or revision history. For `payment_decisions`, this cannot remove the causal limitation: hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
C:Use the same privileged database account for every analyst and job; use that approach for `payment_decisions`. A shared admin principal broadens privilege and prevents meaningful attribution. For `payment_decisions`, this cannot remove the causal limitation: hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
D:Copy the JDBC password into a shared Delta configuration table; use that approach for `payment_decisions`. A readable data table is not a controlled secret store. For `payment_decisions`, this cannot remove the causal limitation: hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
Question 148
At a hospital analytics group, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `payment_decisions` is in scope, and the target must retain every valid late-arriving event. A teammate proposes: "Publish the notebook to all analysts with its password redacted only in comments." Which technical limitation is the decisive reason not to approve that specific proposal?
- Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct.
- Comments do not remove secrets from the executable connection string or revision history. The proposal does not repair `payment_decisions`.
- A readable data table is not a controlled secret store. This would apply to another option for `payment_decisions`.
- A shared admin principal broadens privilege and prevents meaningful attribution. This would apply to an alternative change for `payment_decisions`.
Explanation
Correct Answer
B:Comments do not remove secrets from the executable connection string or revision history. The proposal does not repair `payment_decisions`. This identifies the known limitation of the exact proposed action. Comments do not remove secrets from the executable connection string or revision history. The underlying problem remains hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations; Use a least-privilege credential retrieved through an approved secret facility and schedule the read through Lakeflow Jobs instead targets that failure.
Incorrect Answers
A:Insufficient executor memory is the primary fault; source-file handling and ingestion checkpoints are correct. The case provides a concrete failing data or control path; a mere alternate theory does not address hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
C:A readable data table is not a controlled secret store. This would apply to another option for `payment_decisions`. This limitation belongs to the different alternative "Copy the JDBC password into a shared Delta configuration table". The stem calls for the specific failure of "Publish the notebook to all analysts with its password redacted only in comments".
D:A shared admin principal broadens privilege and prevents meaningful attribution. This would apply to an alternative change for `payment_decisions`. This failure applies to the separate proposal "Use the same privileged database account for every analyst and job".
Question 149
At a hospital analytics group, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `payment_decisions` is in scope, and the target must retain every valid late-arriving event. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Copy the JDBC password into a shared Delta configuration table; monitor results only after launch of `payment_decisions`.
- Retain automated access with a dedicated read-only service identity and auditable rotation
- Publish the notebook to all analysts with its password redacted only in comments; monitor results only after launch of `payment_decisions`.
- Use the same privileged database account for every analyst and job; monitor results only after launch of `payment_decisions`.
Explanation
Correct Answer
B:Retain automated access with a dedicated read-only service identity and auditable rotation. This explicitly bounds the compromise while still addressing hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. Acceptance relies on rotate the database credential and verify the job still retrieves it securely without exposing it in source code rather than simply declaring the change complete.
Incorrect Answers
A:Copy the JDBC password into a shared Delta configuration table; monitor results only after launch of `payment_decisions`. A readable data table is not a controlled secret store. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
C:Publish the notebook to all analysts with its password redacted only in comments; monitor results only after launch of `payment_decisions`. Comments do not remove secrets from the executable connection string or revision history. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
D:Use the same privileged database account for every analyst and job; monitor results only after launch of `payment_decisions`. A shared admin principal broadens privilege and prevents meaningful attribution. Monitoring after deployment does not make this approach a safe bounded tradeoff for `payment_decisions`.
Question 150
At a hospital analytics group, a finance notebook connects to an external JDBC source with credentials embedded directly in shared code. The dataset `payment_decisions` is in scope, and the target must retain every valid late-arriving event. What verification provides evidence of correct behavior under the original adverse condition?
- Review a platform-level availability report for `payment_decisions` without testing whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
- Run only a normal, unchanged `payment_decisions` sample and review secret access audit.
- Rotate the database credential and verify the job still retrieves it securely without exposing it in source code
- Check that the intended configuration exists for `payment_decisions` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
C:Rotate the database credential and verify the job still retrieves it securely without exposing it in source code. This reproduces the scenario-dependent condition, verifies secret access audit, JDBC effective role, notebook revisions, and scheduled job result, and directly tests whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Review a platform-level availability report for `payment_decisions` without testing whether hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations. Aggregate availability does not establish the behavior of affected `payment_decisions` records. It cannot replace the direct exercise: rotate the database credential and verify the job still retrieves it securely without exposing it in source code.
B:Run only a normal, unchanged `payment_decisions` sample and review secret access audit. A normal sample does not challenge hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.
D:Check that the intended configuration exists for `payment_decisions` and that a healthy run succeeded, without inducing the earlier failure. Installed configuration and a healthy run are insufficient to prove the failure mode is gone. The original issue was hard-coded JDBC credentials leak in notebook revisions and can outlive approved rotations.