McAfee Secure

Databricks Certified Data Engineer Professional Bundle

Exam Code: Certified Data Engineer Professional

Exam Name Certified Data Engineer Professional

Certification Provider: Databricks

Corresponding Certification: Databricks Certified Data Engineer Professional

Databricks Certified Data Engineer Professional Bundle $44.99

100% Databricks Certified Data Engineer Professional Guaranteed Success With Testking Training Materials

Get Real Certified Data Engineer Professional Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    Certified Data Engineer Professional Questions & Answers

    339 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual Certified Data Engineer Professional exam while allowing you to hone and measure every aspect of your test-taking ability.

  • Certified Data Engineer Professional Video Course

    Certified Data Engineer Professional Training Course

    33 Video Lectures

    Certified Data Engineer Professional Video Course is developed by Databricks Professionals to help you pass the Certified Data Engineer Professional exam.

    Description

    This course will improve your knowledge and skills required to pass Certified Data Engineer Professional exam.
  • Study Guide

    Certified Data Engineer Professional Study Guide

    111 PDF Pages

    Developed by industry experts, this 111-page guide spells out in painstaking detail all of the information you need to ace Certified Data Engineer Professional exam.

Certified Data Engineer Professional Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    339 Questions

    $124.99
  • Certified Data Engineer Professional Video Course

    Training Course

    33 Video Lectures

    $39.99
  • Study Guide

    Study Guide

    111 PDF Pages

    $29.99

Databricks Certified Data Engineer Professional Practice Test 11

Question 100

A memory-intensive stateful aggregation spills on small interactive compute during peak processing. How should the team correct this issue while preserving the required data contract?

  1. Set appropriate maximum concurrent runs and choose deterministic run partition ownership.
  2. Use a materialized view with an appropriate refresh strategy rather than append-only streaming semantics.
  3. Apply appropriate watermarks and join time constraints on both streaming inputs.
  4. Choose appropriately sized job or serverless compute and tune workload memory needs.

Explanation

Correct Answer

D:

Choose appropriately sized job or serverless compute and tune workload memory needs. This is the most directly relevant remediation because stateful aggregation memory demand can exceed the originally chosen executor resources. A concrete acceptance check is: Peak-event replay finishes without uncontrolled spill or memory failure. To reduce recurrence: Monitor state and task-memory trends before raising data volumes.

Incorrect Answers

A:

Overlapping writers can create conflicts or duplicate side effects on shared targets. That consideration does not remove the current constraint: stateful aggregation memory demand can exceed the originally chosen executor resources.

B:

Mutable aggregate sources are not equivalent to a never-changing append event stream. In this situation, stateful aggregation memory demand can exceed the originally chosen executor resources.

C:

Unbounded event-time join state retains data awaiting hypothetical future matches. For the observed behavior, stateful aggregation memory demand can exceed the originally chosen executor resources.

Question 101

A SQL Server operational database must continuously replicate changed rows without nightly full-table scans. What is the MOST appropriate targeted remediation?

  1. Configure Lakehouse Federation with a governed connection and foreign catalog.
  2. Set cloudFiles.includeExistingFiles=false before the first stream run and retain the intended checkpoint; toggling the option after stream initialization cannot reset the boundary.
  3. Split source streams by format and enforce explicit parsing and schema contracts.
  4. Configure supported Lakeflow Connect SQL Server CDC ingestion with required source permissions.

Explanation

Correct Answer

D:

Configure supported Lakeflow Connect SQL Server CDC ingestion with required source permissions. This is the most directly relevant remediation because a log-based CDC connector captures changes more efficiently than repeated complete extracts. A concrete acceptance check is: A source update and delete propagate to target with acceptable lag. To reduce recurrence: Monitor CDC retention and source log health.

Incorrect Answers

A:

Federation queries external data in place rather than copying it into a managed table. In this situation, a log-based CDC connector captures changes more efficiently than repeated complete extracts.

B:

includeExistingFiles is evaluated only on first stream start; the checkpoint preserves file discovery state across restarts. For the observed behavior, a log-based CDC connector captures changes more efficiently than repeated complete extracts.

C:

Format-specific decoders cannot safely infer a single stable structure from mixed files. The controlling issue in this question is that a log-based CDC connector captures changes more efficiently than repeated complete extracts.

Question 102

A pipeline wheel was compiled for a different Python version and fails to import a native extension. Which change most directly addresses the operational problem?

  1. Restore its existing compatible checkpoint location and state when resuming the same query.
  2. Return the DataFrame from the declarative dataset definition and let the pipeline manage writes.
  3. Use a streaming table where append-only incremental ingestion suits the workload.
  4. Rebuild or choose a compatible wheel for the target runtime and architecture.

Explanation

Correct Answer

D:

Rebuild or choose a compatible wheel for the target runtime and architecture. This is the most directly relevant remediation because native wheel compatibility is constrained by interpreter and platform ABI tags. A concrete acceptance check is: A clean target-runtime import of the native package succeeds. To reduce recurrence: Pin and test library artifacts against supported runtime versions.

Incorrect Answers

A:

A checkpoint stores offsets and state necessary for incremental restart. For the observed behavior, native wheel compatibility is constrained by interpreter and platform ABI tags.

B:

Declarative pipeline datasets use managed update semantics rather than arbitrary conflicting writes. The controlling issue in this question is that native wheel compatibility is constrained by interpreter and platform ABI tags.

C:

Repeated full or expensive view refresh can waste compute for new append records. Here the important technical distinction is that native wheel compatibility is constrained by interpreter and platform ABI tags.

Question 103

A legacy dedicated cluster ignores an ABAC policy because its runtime lacks supported fine-grained filtering configuration. Which action should the data engineer take FIRST to resolve this issue?

  1. Move to supported serverless/standard compute or enable the required dedicated-mode capability.
  2. Observe approved retention and coordinate purge after supported reader and time-travel windows.
  3. Tokenize the identifier using a governed mapping service rather than exposing raw account numbers.
  4. Scope the principal to the specific job and required data and compute privileges.

Explanation

Correct Answer

A:

Move to supported serverless/standard compute or enable the required dedicated-mode capability. This is the most directly relevant remediation because policy enforcement has specific supported runtime and access-mode requirements. A concrete acceptance check is: The same unauthorized test query is restricted on approved compute. To reduce recurrence: Gate sensitive workloads on compute compatibility.

Incorrect Answers

B:

Premature file removal can break readers and breach recovery requirements. Here the important technical distinction is that policy enforcement has specific supported runtime and access-mode requirements.

C:

Reversible or lookup-managed tokens can preserve joins while reducing raw identifier exposure. The reported failure instead depends on this fact: policy enforcement has specific supported runtime and access-mode requirements.

D:

An unrestricted automation identity expands the impact of token compromise. That consideration does not remove the current constraint: policy enforcement has specific supported runtime and access-mode requirements.

Question 104

A contractor is removed from a team but retains a direct table SELECT grant on sensitive payroll data. Which action should the data engineer take FIRST to resolve this issue?

  1. Apply risk-reviewed generalization or suppression to quasi-identifiers before sharing.
  2. Observe approved retention and coordinate purge after supported reader and time-travel windows.
  3. Replace it with a controlled governed tag and enforce assignment permissions.
  4. Revoke the orphan direct grant and manage access through reviewed group membership.

Explanation

Correct Answer

D:

Revoke the orphan direct grant and manage access through reviewed group membership. This is the most directly relevant remediation because direct object privileges can survive removal from an unrelated workspace group. A concrete acceptance check is: A contractor test identity no longer queries the table after offboarding. To reduce recurrence: Run joiner-mover-leaver privilege audits.

Incorrect Answers

A:

Removing direct identifiers alone can leave rows re-identifiable from combinations. Here the important technical distinction is that direct object privileges can survive removal from an unrelated workspace group.

B:

Premature file removal can break readers and breach recovery requirements. The reported failure instead depends on this fact: direct object privileges can survive removal from an unrelated workspace group.

C:

ABAC data classification depends on trusted tag definitions and authorized assignments. That consideration does not remove the current constraint: direct object privileges can survive removal from an unrelated workspace group.

Question 105

A MySQL connector starts but table changes are missing because binary logging is disabled. What is the MOST appropriate targeted remediation?

  1. Use a least-privilege credential dedicated to the federated connection and approved objects.
  2. Enable supported MySQL binlog settings and the connector's required replication privileges.
  3. Confirm the specific target table format and connector write support before selecting the sink.
  4. Use supported Databricks-to-Databricks OpenSharing via governed recipient identifiers.

Explanation

Correct Answer

B:

Enable supported MySQL binlog settings and the connector's required replication privileges. This is the most directly relevant remediation because mySQL log-based CDC cannot read changes without an available source change log. A concrete acceptance check is: A controlled row update becomes visible in the destination without a full reload. To reduce recurrence: Alert on binlog retention and connector lag.

Incorrect Answers

A:

Unity Catalog grants do not automatically reduce external database account privileges. The reported failure instead depends on this fact: mySQL log-based CDC cannot read changes without an available source change log.

C:

Source-format readability does not imply every sink supports identical CDC writes. In this situation, mySQL log-based CDC cannot read changes without an available source change log.

D:

D2D sharing uses managed account identities and access integration instead of generic external tokens. For the observed behavior, mySQL log-based CDC cannot read changes without an available source change log.

Question 106

System table data arrives with a reporting delay but the dashboard promises minute-by-minute final cost. Which change most directly addresses the operational problem?

  1. Combine event-log update status with measured source-to-target data freshness.
  2. Define a SQL or Lakehouse alert query with explicit time window and breach condition.
  3. Label system table latency and combine near-real-time metrics with reconciled billing data.
  4. Apply bounded polling intervals, exponential backoff and response-aware retry.

Explanation

Correct Answer

C:

Label system table latency and combine near-real-time metrics with reconciled billing data. This is the most directly relevant remediation because usage tables are not guaranteed instantaneous representations of metered charges. A concrete acceptance check is: The dashboard distinguishes preliminary usage from finalized billing periods. To reduce recurrence: Document freshness and reconciliation windows.

Incorrect Answers

A:

Job success does not prove new source records were available or delivered. That consideration does not remove the current constraint: usage tables are not guaranteed instantaneous representations of metered charges.

B:

Alert correctness depends on the query's time semantics and threshold predicate. In this situation, usage tables are not guaranteed instantaneous representations of metered charges.

D:

Excessive API calls can exceed service limits and cause monitoring blind spots. The controlling issue in this question is that usage tables are not guaranteed instantaneous representations of metered charges.

Question 107

A large Delta UPDATE rewrites many files because rows are randomly distributed across the entire table. What is the MOST appropriate targeted remediation?

  1. Evaluate liquid clustering on frequently filtered merchant and event-time columns.
  2. Evaluate clustering and selective predicates to localize update work.
  3. Improve layout or statistics so selective predicates prune unnecessary files.
  4. Enable and validate Predictive Optimization where supported for the managed catalog.

Explanation

Correct Answer

B:

Evaluate clustering and selective predicates to localize update work. This is the most directly relevant remediation because poor data locality makes targeted logical changes touch broad physical file sets. A concrete acceptance check is: The revised update touches fewer files while preserving results. To reduce recurrence: Monitor update amplification and layout quality.

Incorrect Answers

A:

High-cardinality filters are often underserved by coarse date-only partition pruning. In this situation, poor data locality makes targeted logical changes touch broad physical file sets.

C:

Poor pruning forces large scans despite narrow logical result filters. The controlling issue in this question is that poor data locality makes targeted logical changes touch broad physical file sets.

D:

Managed optimization needs eligible objects and feature configuration to act. Here the important technical distinction is that poor data locality makes targeted logical changes touch broad physical file sets.

Question 108

Failed records are quarantined but replay jobs blindly reinject them, creating an infinite failure loop. How should the team correct this issue while preserving the required data contract?

  1. Replace blind append with idempotent partition reconciliation or key-based MERGE.
  2. Parse the JSON into VARIANT and extract approved fields using supported variant functions.
  3. Apply an approved Databricks AI function such as ai_query with governed model access.
  4. Repair the cause and track quarantine processing state and replay attempt metadata.

Explanation

Correct Answer

D:

Repair the cause and track quarantine processing state and replay attempt metadata. This is the most directly relevant remediation because replaying unchanged invalid input repeats the same deterministic rejection. A concrete acceptance check is: A corrected sample reprocesses once and its quarantine status closes. To reduce recurrence: Require auditable replay approval and retry limits.

Incorrect Answers

A:

At-least-once batch retries can duplicate records without a stable upsert identity. For the observed behavior, replaying unchanged invalid input repeats the same deterministic rejection.

B:

Semi-structured schemas can evolve more rapidly than a fixed relational projection. The controlling issue in this question is that replaying unchanged invalid input repeats the same deterministic rejection.

C:

Uncontrolled external text transfer can violate data handling and model access policy. Here the important technical distinction is that replaying unchanged invalid input repeats the same deterministic rejection.

Question 109

A left join loses unmatched orders after a WHERE filter references nullable columns from the right table. What is the MOST appropriate targeted remediation?

  1. Use a keyed Delta MERGE with matched updates and not-matched inserts.
  2. Correct the expectation predicate to distinguish valid zero from impossible negative ages.
  3. Move the right-side predicate into the join condition when unmatched left rows must remain.
  4. Use watermark-aware deduplication appropriate to the allowed lateness window.

Explanation

Correct Answer

C:

Move the right-side predicate into the join condition when unmatched left rows must remain. This is the most directly relevant remediation because a post-join WHERE predicate rejects null-extended outer-join rows. A concrete acceptance check is: Unmatched orders are preserved and matched orders satisfy the intended filter. To reduce recurrence: Test null and unmatched records when changing outer joins.

Incorrect Answers

A:

Full overwrite can replace unrelated data and require unnecessary table rewrite. The controlling issue in this question is that a post-join WHERE predicate rejects null-extended outer-join rows.

B:

Overly broad validation rules create false-positive data loss. Here the important technical distinction is that a post-join WHERE predicate rejects null-extended outer-join rows.

D:

Dedup state needs a bounded retention horizon for long-running streams. That consideration does not remove the current constraint: a post-join WHERE predicate rejects null-extended outer-join rows.

Question 110

A Python UDF imports a helper library only on the driver, then executors fail with ModuleNotFoundError. Which change most directly addresses the operational problem?

  1. Pin compatible package versions and validate the complete dependency graph before deployment.
  2. Use job or supported serverless compute that starts for scheduled processing.
  3. Distribute the dependency through the cluster or job environment used by worker processes.
  4. Declare the silver query as dependent on the bronze dataset within the pipeline graph.

Explanation

Correct Answer

C:

Distribute the dependency through the cluster or job environment used by worker processes. This is the most directly relevant remediation because executor processes need access to the same importable module as the driver. A concrete acceptance check is: A distributed transformation runs on multiple partitions without import failures. To reduce recurrence: Test UDFs on worker executors rather than only local driver calls.

Incorrect Answers

A:

Unconstrained transitive versions can introduce incompatible behavior between environments. Here the important technical distinction is that executor processes need access to the same importable module as the driver.

B:

Paying for idle all-purpose compute is unnecessary for isolated short recurring tasks. The reported failure instead depends on this fact: executor processes need access to the same importable module as the driver.

D:

Pipeline scheduling requires explicit data lineage to enforce upstream-before-downstream execution. In this situation, executor processes need access to the same importable module as the driver.