Certified Data Engineer Associate Practice Test 1
Question 1
At a telecom operations group, a shared analytics estate keeps writing Parquet files directly, and a failed overwrite left BI readers with inconsistent versions. The dataset `experiment_samples` is in scope, and workspace users must retain least-privilege access. 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 transaction history, concurrent-reader consistency across affected and unaffected `R034-CASE-001` runs.
- Examine only a normal successful run of `experiment_samples` and trend transaction history without recreating the fault.
Explanation
Correct Answer
C:Correlate transaction history, concurrent-reader consistency across affected and unaffected `R034-CASE-001` runs.. By joining transaction history, concurrent-reader consistency, recovery version, and Unity Catalog grants across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. It also sets a measurable baseline for interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user.
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 transaction history, concurrent-reader consistency, recovery version, and Unity Catalog grants, the direct means of distinguishing bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
B:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. This check never observes the affected `experiment_samples` records or their causal path.
D:Examine only a normal successful run of `experiment_samples` and trend transaction history without recreating the fault. A healthy-run trend can be useful, but it does not expose bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. The failing-path transaction history, concurrent-reader consistency, recovery version, and Unity Catalog grants has to be correlated before attributing cause.
Question 2
At a telecom operations group, a shared analytics estate keeps writing Parquet files directly, and a failed overwrite left BI readers with inconsistent versions. The dataset `experiment_samples` is in scope, and workspace users must retain least-privilege access. Which platform configuration or data-engineering change is most defensible?
- Copy the files to a temporary notebook directory before every query; use that approach for `experiment_samples`.
- Add Unity Catalog grants to files but do not convert the data to Delta; use that approach for `experiment_samples`.
- Keep unversioned Parquet and rely on a nightly folder backup; use that approach for `experiment_samples`.
- Use Delta Lake transactional tables for reliable commits and recovery, with Unity Catalog governing access and discovery
Explanation
Correct Answer
D:Use Delta Lake transactional tables for reliable commits and recovery, with Unity Catalog governing access and discovery. This directly addresses bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. The design should be accepted only after interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user; the related operational boundary is to accept the Delta migration and controlled catalog privileges rather than cheaper but unversioned file copies.
Incorrect Answers
A:Copy the files to a temporary notebook directory before every query; use that approach for `experiment_samples`. A transient notebook copy fragments the source of truth and is not a durable commit protocol. For `experiment_samples`, this cannot remove the causal limitation: bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
B:Add Unity Catalog grants to files but do not convert the data to Delta; use that approach for `experiment_samples`. Governance metadata cannot supply ACID commits or Delta time travel to untransactional files. For `experiment_samples`, this cannot remove the causal limitation: bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
C:Keep unversioned Parquet and rely on a nightly folder backup; use that approach for `experiment_samples`. A nightly copy cannot provide a consistent transactional snapshot to concurrent readers. For `experiment_samples`, this cannot remove the causal limitation: bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
Question 3
At a telecom operations group, a shared analytics estate keeps writing Parquet files directly, and a failed overwrite left BI readers with inconsistent versions. The dataset `experiment_samples` is in scope, and workspace users must retain least-privilege access. A teammate proposes: "Add Unity Catalog grants to files but do not convert the data to Delta." Which technical limitation is the decisive reason not to approve that specific proposal?
- A transient notebook copy fragments the source of truth and is not a durable commit protocol. This would apply to an alternative change for `experiment_samples`.
- A nightly copy cannot provide a consistent transactional snapshot to concurrent readers. This would apply to another option for `experiment_samples`.
- Governance metadata cannot supply ACID commits or Delta time travel to untransactional files. The proposal does not repair `experiment_samples`.
- The anomaly is entirely a compute sizing problem; the file format and catalog design are not involved.
Explanation
Correct Answer
C:Governance metadata cannot supply ACID commits or Delta time travel to untransactional files. The proposal does not repair `experiment_samples`. This identifies the known limitation of the exact proposed action. Governance metadata cannot supply ACID commits or Delta time travel to untransactional files. The underlying problem remains bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges; Use Delta Lake transactional tables for reliable commits and recovery, with Unity Catalog governing access and discovery instead targets that failure.
Incorrect Answers
A:A transient notebook copy fragments the source of truth and is not a durable commit protocol. This would apply to an alternative change for `experiment_samples`. This failure applies to the separate proposal "Copy the files to a temporary notebook directory before every query".
B:A nightly copy cannot provide a consistent transactional snapshot to concurrent readers. This would apply to another option for `experiment_samples`. This limitation belongs to the different alternative "Keep unversioned Parquet and rely on a nightly folder backup". The stem calls for the specific failure of "Add Unity Catalog grants to files but do not convert the data to Delta".
D:The anomaly is entirely a compute sizing problem; the file format and catalog design are not involved. The case provides a concrete failing data or control path; a mere alternate theory does not address bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
Question 4
At a telecom operations group, a shared analytics estate keeps writing Parquet files directly, and a failed overwrite left BI readers with inconsistent versions. The dataset `experiment_samples` is in scope, and workspace users must retain least-privilege access. What risk-and-cost compromise should the owner accept instead of the proposed shortcuts?
- Keep unversioned Parquet and rely on a nightly folder backup
- Add Unity Catalog grants to files but do not convert the data to Delta
- Copy the files to a temporary notebook directory before every query; monitor results only after launch of `experiment_samples`.
- Accept the Delta migration and controlled catalog privileges rather than cheaper but unversioned file copies
Explanation
Correct Answer
D:Accept the Delta migration and controlled catalog privileges rather than cheaper but unversioned file copies. This explicitly bounds the compromise while still addressing bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. Acceptance relies on interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user rather than simply declaring the change complete.
Incorrect Answers
A:Keep unversioned Parquet and rely on a nightly folder backup. A nightly copy cannot provide a consistent transactional snapshot to concurrent readers. Monitoring after deployment does not make this approach a safe bounded tradeoff for `experiment_samples`.
B:Add Unity Catalog grants to files but do not convert the data to Delta. Governance metadata cannot supply ACID commits or Delta time travel to untransactional files. Monitoring after deployment does not make this approach a safe bounded tradeoff for `experiment_samples`.
C:Copy the files to a temporary notebook directory before every query; monitor results only after launch of `experiment_samples`. A transient notebook copy fragments the source of truth and is not a durable commit protocol. Monitoring after deployment does not make this approach a safe bounded tradeoff for `experiment_samples`.
Question 5
At a telecom operations group, a shared analytics estate keeps writing Parquet files directly, and a failed overwrite left BI readers with inconsistent versions. The dataset `experiment_samples` is in scope, and workspace users must retain least-privilege access. Which direct test could falsify the proposed fix instead of only confirming deployment?
- Check that the intended configuration exists for `experiment_samples` and that a healthy run succeeded, without inducing the earlier failure.
- Review a platform-level availability report for `experiment_samples` without testing whether bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
- Run only a normal, unchanged `experiment_samples` sample and review transaction history.
- Interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user
Explanation
Correct Answer
D:Interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user. This reproduces the scenario-dependent condition, verifies transaction history, concurrent-reader consistency, recovery version, and Unity Catalog grants, and directly tests whether bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges is resolved. Observed results, not intent, determine approval.
Incorrect Answers
A:Check that the intended configuration exists for `experiment_samples` 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 bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
B:Review a platform-level availability report for `experiment_samples` without testing whether bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges. Aggregate availability does not establish the behavior of affected `experiment_samples` records. It cannot replace the direct exercise: interrupt a write and verify readers see one committed version; restore the previous Delta version and test a denied user.
C:Run only a normal, unchanged `experiment_samples` sample and review transaction history. A normal sample does not challenge bare Parquet overwrites provide neither the coordinated Delta commit log nor centrally governed object privileges.
Question 6
At a city utilities office, teams have copied the same customer table into several workspaces and cannot explain which analyst accessed which field. The dataset `supplier_orders` is in scope, and the control board requires an auditable data lineage. Which correlated observation is the strongest basis for the change decision?
- Correlate table ownership, catalog lineage across affected and unaffected `R034-CASE-002` runs.
- Compare the current configuration and the signed change approval, without source-row evidence
- Inspect normal-period success metrics for the stated dataset without reproducing the source error
- Review completed run status and aggregate cluster health without record-level correlation
Explanation
Correct Answer
A:Correlate table ownership, catalog lineage across affected and unaffected `R034-CASE-002` runs.. By joining table ownership, catalog lineage, actual effective grants, and sample cross-workspace access across the affected and unaffected conditions, the investigation directly tests the recorded mechanism: workspace-specific copies and ACLs prevent coherent governance and lineage across teams. It also sets a measurable baseline for query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write.
Incorrect Answers
B: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 table ownership, catalog lineage, actual effective grants, and sample cross-workspace access, the direct means of distinguishing workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
C: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 workspace-specific copies and ACLs prevent coherent governance and lineage across teams. The failing-path table ownership, catalog lineage, actual effective grants, and sample cross-workspace access has to be correlated before attributing cause.
D:Review completed run status and aggregate cluster health without record-level correlation. A successful aggregate platform state can coexist with workspace-specific copies and ACLs prevent coherent governance and lineage across teams. This check never observes the affected `supplier_orders` records or their causal path.
Question 7
At a city utilities office, teams have copied the same customer table into several workspaces and cannot explain which analyst accessed which field. The dataset `supplier_orders` is in scope, and the control board requires an auditable data lineage. What implementation should the engineer select for the failing workflow?
- Give all analysts metastore administrator rights to make discovery easier; use that approach for `supplier_orders`.
- Use Delta transaction logs alone as the user entitlement mechanism; use that approach for `supplier_orders`.
- Create more copies in each workspace with local access lists; use that approach for `supplier_orders`.
- Register governed tables in Unity Catalog and apply least-privilege grants while preserving one discoverable data lineage
Explanation
Correct Answer
D:Register governed tables in Unity Catalog and apply least-privilege grants while preserving one discoverable data lineage. This directly addresses workspace-specific copies and ACLs prevent coherent governance and lineage across teams. The design should be accepted only after query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write; the related operational boundary is to centralize governance while allowing approved teams self-service discovery without copying sensitive data.
Incorrect Answers
A:Give all analysts metastore administrator rights to make discovery easier; use that approach for `supplier_orders`. Administrative rights exceed read requirements and defeat least-privilege access. For `supplier_orders`, this cannot remove the causal limitation: workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
B:Use Delta transaction logs alone as the user entitlement mechanism; use that approach for `supplier_orders`. Delta commit history does not replace Unity Catalog identity and object privileges. For `supplier_orders`, this cannot remove the causal limitation: workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
C:Create more copies in each workspace with local access lists; use that approach for `supplier_orders`. Local copies multiply uncontrolled policy surfaces and obscure common lineage. For `supplier_orders`, this cannot remove the causal limitation: workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
Question 8
At a city utilities office, teams have copied the same customer table into several workspaces and cannot explain which analyst accessed which field. The dataset `supplier_orders` is in scope, and the control board requires an auditable data lineage. A teammate proposes: "Create more copies in each workspace with local access lists." Which technical limitation is the decisive reason not to approve that specific proposal?
- Administrative rights exceed read requirements and defeat least-privilege access. This would apply to another option for `supplier_orders`.
- Delta commit history does not replace Unity Catalog identity and object privileges. This would apply to an alternative change for `supplier_orders`.
- Local copies multiply uncontrolled policy surfaces and obscure common lineage. The proposal does not repair `supplier_orders`.
- The anomaly is entirely a compute sizing problem; the file format and catalog design are not involved.
Explanation
Correct Answer
C:Local copies multiply uncontrolled policy surfaces and obscure common lineage. The proposal does not repair `supplier_orders`. This identifies the known limitation of the exact proposed action. Local copies multiply uncontrolled policy surfaces and obscure common lineage. The underlying problem remains workspace-specific copies and ACLs prevent coherent governance and lineage across teams; Register governed tables in Unity Catalog and apply least-privilege grants while preserving one discoverable data lineage instead targets that failure.
Incorrect Answers
A:Administrative rights exceed read requirements and defeat least-privilege access. This would apply to another option for `supplier_orders`. This limitation belongs to the different alternative "Give all analysts metastore administrator rights to make discovery easier". The stem calls for the specific failure of "Create more copies in each workspace with local access lists".
B:Delta commit history does not replace Unity Catalog identity and object privileges. This would apply to an alternative change for `supplier_orders`. This failure applies to the separate proposal "Use Delta transaction logs alone as the user entitlement mechanism".
D:The anomaly is entirely a compute sizing problem; the file format and catalog design are not involved. The case provides a concrete failing data or control path; a mere alternate theory does not address workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
Question 9
At a city utilities office, teams have copied the same customer table into several workspaces and cannot explain which analyst accessed which field. The dataset `supplier_orders` is in scope, and the control board requires an auditable data lineage. Which decision preserves the stated data contract while keeping the change scope proportionate?
- Create more copies in each workspace with local access lists
- Give all analysts metastore administrator rights to make discovery easier
- Centralize governance while allowing approved teams self-service discovery without copying sensitive data
- Use Delta transaction logs alone as the user entitlement mechanism
Explanation
Correct Answer
C:Centralize governance while allowing approved teams self-service discovery without copying sensitive data. This explicitly bounds the compromise while still addressing workspace-specific copies and ACLs prevent coherent governance and lineage across teams. Acceptance relies on query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write rather than simply declaring the change complete.
Incorrect Answers
A:Create more copies in each workspace with local access lists. Local copies multiply uncontrolled policy surfaces and obscure common lineage. Monitoring after deployment does not make this approach a safe bounded tradeoff for `supplier_orders`.
B:Give all analysts metastore administrator rights to make discovery easier. Administrative rights exceed read requirements and defeat least-privilege access. Monitoring after deployment does not make this approach a safe bounded tradeoff for `supplier_orders`.
D:Use Delta transaction logs alone as the user entitlement mechanism. Delta commit history does not replace Unity Catalog identity and object privileges. Monitoring after deployment does not make this approach a safe bounded tradeoff for `supplier_orders`.
Question 10
At a city utilities office, teams have copied the same customer table into several workspaces and cannot explain which analyst accessed which field. The dataset `supplier_orders` is in scope, and the control board requires an auditable data lineage. What verification provides evidence of correct behavior under the original adverse condition?
- Query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write
- Run only a normal, unchanged `supplier_orders` sample and review table ownership.
- Review a platform-level availability report for `supplier_orders` without testing whether workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
- Check that the intended configuration exists for `supplier_orders` and that a healthy run succeeded, without inducing the earlier failure.
Explanation
Correct Answer
A:Query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write. This reproduces the scenario-dependent condition, verifies table ownership, catalog lineage, actual effective grants, and sample cross-workspace access, and directly tests whether workspace-specific copies and ACLs prevent coherent governance and lineage across teams is resolved. Observed results, not intent, determine approval.
Incorrect Answers
B:Run only a normal, unchanged `supplier_orders` sample and review table ownership. A normal sample does not challenge workspace-specific copies and ACLs prevent coherent governance and lineage across teams.
C:Review a platform-level availability report for `supplier_orders` without testing whether workspace-specific copies and ACLs prevent coherent governance and lineage across teams. Aggregate availability does not establish the behavior of affected `supplier_orders` records. It cannot replace the direct exercise: query as an approved analyst and an unauthorized analyst, then trace the shared table lineage after a write.
D:Check that the intended configuration exists for `supplier_orders` 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 workspace-specific copies and ACLs prevent coherent governance and lineage across teams.