Pass Databricks Certified Data Engineer Professional Exam in First Attempt Easily
Real Databricks Certified Data Engineer Professional Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
2 products

You save $34.99

Certified Data Engineer Professional Premium Bundle

  • Premium File 339 Questions & Answers
  • Last Update: Oct 28, 2026
  • Training Course 33 Lectures
$74.99 $109.98

Purchase Individually

  • Premium File

    339 Questions & Answers
    Last Update: Oct 28, 2026

    $76.99
    $69.99
  • Training Course

    33 Lectures

    $43.99
    $39.99

Certified Data Engineer Professional Practice Test 40

Question 390

A company uses ungoverned free-text tags for sensitivity yet expects catalog-wide automatic policy enforcement.

Which central fine-grained access policy should be applied?

  1. Apply an ABAC row-filter policy driven by governed region tags and an identity-aware UDF
  2. Define governed tags with limited assignment permissions before relying on tag-scoped ABAC
  3. Create Unity Catalog ABAC masking policies scoped to governed tags at the appropriate catalog or schema
  4. Use a supported serverless or compatible runtime/access configuration for ABAC policy enforcement

Explanation

Correct Answer

B:

ABAC policy selection depends on governed tags that are controlled independently of ordinary write access. For this situation, define governed tags with limited assignment permissions before relying on tag-scoped ABAC. The relevant result would be that unauthorized tag removal is rejected and protected columns keep their effective masking policy.

Incorrect Answers

A:

Row-filter policies evaluate authorized rows at query time across all matching governed objects. That option implements apply an ABAC row-filter policy driven by governed region tags and an identity-aware UDF. It addresses a different problem; here the distinguishing need is to define governed tags with limited assignment permissions before relying on tag-scoped ABAC.

C:

Tag-conditioned ABAC policies provide centralized reusable protection as new matching columns appear. That option implements create Unity Catalog ABAC masking policies scoped to governed tags at the appropriate catalog or schema. It addresses a different problem; here the distinguishing need is to define governed tags with limited assignment permissions before relying on tag-scoped ABAC.

D:

Fine-grained ABAC restrictions have compute prerequisites and cannot be assumed to work on all older runtimes. That option implements use a supported serverless or compatible runtime/access configuration for ABAC policy enforcement. It addresses a different problem; here the distinguishing need is to define governed tags with limited assignment permissions before relying on tag-scoped ABAC.

Question 391

A data engineering team attempts automatic clustering on a table type lacking the required runtime support.

Which clustering result proves the intended layout benefit?

  1. Query profile shows fewer scanned data bytes and unchanged query results under the same predicates
  2. The supported runtime successfully creates and optimizes the clustered table without capability errors
  3. The table's clustering configuration is valid and scheduled optimization completes without incompatible commands
  4. After optimization, clustering metadata and scanned data reflect the changing query workload

Explanation

Correct Answer

B:

This directly verifies the intended outcome: the supported runtime successfully creates and optimizes the clustered table without capability errors. Clustering eligibility differs by table type and compute runtime; unsupported combinations must be upgraded or redesigned. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly cluster by the frequently filtered columns and run an appropriate optimize cycle. Co-locating values of selective columns improves file-level statistics and data skipping. The specific evidence needed here is that the supported runtime successfully creates and optimizes the clustered table without capability errors.

C:

This would test a different behavior, chiefly choose one supported clustering layout strategy and do not combine ZORDER with liquid clustering. Liquid clustering is a replacement layout option rather than an add-on to ZORDER on the same table. The specific evidence needed here is that the supported runtime successfully creates and optimizes the clustered table without capability errors.

D:

This would test a different behavior, chiefly enable automatic liquid clustering with CLUSTER BY AUTO on an eligible managed table. Automatic liquid clustering selects keys from usage patterns and works with predictive optimization. The specific evidence needed here is that the supported runtime successfully creates and optimizes the clustered table without capability errors.

Question 392

A supplier on Databricks needs a managed recipient relationship without repeatedly exporting Parquet snapshots.

Which recipient access result confirms the sharing design?

  1. The recipient can query allowed shared objects and loses access when the provider revokes the share
  2. The former recipient receives an authorization failure while unaffected approved recipients still query successfully
  3. The recipient sees only the contracted fields and provider changes outside the interface do not leak extra columns
  4. An approved external client reads permitted shared rows and access remains governed by recipient credentials

Explanation

Correct Answer

A:

This directly verifies the intended outcome: the recipient can query allowed shared objects and loses access when the provider revokes the share. D2D sharing exposes provider-controlled current data to an authorized Databricks recipient without manual dataset copies. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

B:

This would test a different behavior, chiefly revoke or update the OpenSharing recipient permissions and verify access is denied. Provider-side recipient control stops future access to shared resources without relying on deleting past exports. The specific evidence needed here is that the recipient can query allowed shared objects and loses access when the provider revokes the share.

C:

This would test a different behavior, chiefly publish an approved share-compatible governed view or data product exposing only the agreed schema. A curated shared interface separates consumer contracts from internal table shape and sensitive columns. The specific evidence needed here is that the recipient can query allowed shared objects and loses access when the provider revokes the share.

D:

This would test a different behavior, chiefly use Databricks-to-open OpenSharing with an eligible recipient and supported client protocol. Open sharing allows authorized non-Databricks recipients to access shared data through a protocol interface. The specific evidence needed here is that the recipient can query allowed shared objects and loses access when the provider revokes the share.

Question 393

A data engineer adds a pipeline expectation to filter malformed transactions but business wants visibility into loss.

Which pipeline design is most appropriate for this workload?

  1. Choose a materialized view or an explicit CDC design when the source requires updates and retractions
  2. Define a Lakeflow materialized view for the maintained derived query
  3. Separate controlled backfill processing from the live streaming checkpoint and reconcile outputs by stable keys
  4. Use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics

Explanation

Correct Answer

D:

Expectations define data quality handling and surface invalid-record metrics rather than silently swallowing failures. For this situation, use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics. The relevant result would be that the invalid test rows are rejected under the chosen policy and recorded quality counts match the fixture.

Incorrect Answers

A:

Append-oriented streaming ingestion alone does not encode which prior target rows must be replaced. That option implements choose a materialized view or an explicit CDC design when the source requires updates and retractions. It addresses a different problem; here the distinguishing need is to use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics.

B:

A materialized view represents a query result refreshed from upstream dependencies rather than simply appending stream records. That option implements define a Lakeflow materialized view for the maintained derived query. It addresses a different problem; here the distinguishing need is to use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics.

C:

Reusing a live checkpoint for an unrelated replay can mix offsets and produce inconsistent duplicates. That option implements separate controlled backfill processing from the live streaming checkpoint and reconcile outputs by stable keys. It addresses a different problem; here the distinguishing need is to use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics.

Question 394

A shipping company deploys a wheel artifact yet receives ModuleNotFoundError when a scheduled Python wheel task begins.

What direct test best verifies the packaged Python workload?

  1. An approved workload identity fetches the expected wheel and unauthorized users cannot access the artifact
  2. A clean job cluster imports the required package and records the intended installed version
  3. The wheel installs on clean compute and the scheduled task imports its entry point successfully
  4. Fresh environment installation succeeds and dependency checks show a single compatible package graph

Explanation

Correct Answer

C:

This directly verifies the intended outcome: the wheel installs on clean compute and the scheduled task imports its entry point successfully. Python wheel import resolution depends on the packaged module structure and installation into the task environment. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly publish the approved versioned wheel to an authorized artifact location and reference it in job dependencies. Managed artifact distribution provides traceability without exposing proprietary packages through public repositories. The specific evidence needed here is that the wheel installs on clean compute and the scheduled task imports its entry point successfully.

B:

This would test a different behavior, chiefly pin the required package version in the workload dependencies and install it in the job environment. Explicit dependencies make fresh ephemeral compute reproducible and avoid relying on an interactive cluster's state. The specific evidence needed here is that the wheel installs on clean compute and the scheduled task imports its entry point successfully.

D:

This would test a different behavior, chiefly inspect the package dependency tree and resolve version conflicts in the declared environment. Conflicting transitive requirements must be reconciled rather than hidden by rerunning the same failing installation. The specific evidence needed here is that the wheel installs on clean compute and the scheduled task imports its entry point successfully.

Question 395

An hourly data process must run ingestion, then quality validation, then parallel regional aggregations.

Which Jobs orchestration change best fits the stated dependency?

  1. Repair the job run from the failed task rather than rerunning every successful upstream task
  2. Use a Lakeflow Jobs For Each task to iterate parameter values with controlled concurrency
  3. Create a Lakeflow Job dependency graph with upstream tasks and a downstream publish task
  4. Configure task run conditions and notifications for the intended failure path

Explanation

Correct Answer

C:

Job task dependencies express ordering and parallelism without timing-based notebook sleeps. For this situation, create a Lakeflow Job dependency graph with upstream tasks and a downstream publish task. The relevant result would be that task run history shows downstream publication starts only after all required upstream tasks succeed.

Incorrect Answers

A:

Lakeflow Job repair preserves eligible successful task results and focuses retry effort on failed work. That option implements repair the job run from the failed task rather than rerunning every successful upstream task. It addresses a different problem; here the distinguishing need is to create a Lakeflow Job dependency graph with upstream tasks and a downstream publish task.

B:

For Each tasks express parameterized fan-out and bound parallel work more safely than copied notebook tasks. That option implements use a Lakeflow Jobs For Each task to iterate parameter values with controlled concurrency. It addresses a different problem; here the distinguishing need is to create a Lakeflow Job dependency graph with upstream tasks and a downstream publish task.

D:

Job run conditions can trigger follow-up tasks based on upstream outcomes without masking the original failure. That option implements configure task run conditions and notifications for the intended failure path. It addresses a different problem; here the distinguishing need is to create a Lakeflow Job dependency graph with upstream tasks and a downstream publish task.

Question 396

A Python notebook contains an embedded external database password visible to everyone with notebook read access.

Which permission or credential change best enforces least privilege?

  1. Apply Unity Catalog grants at the narrowest required securable and remove unnecessary privileges
  2. Use approved secret management or governed connection objects with least-privileged job identities
  3. Set object ACLs using least-privileged workspace and job permissions for each role
  4. Revoke the recipient or credential and review related object grants immediately

Explanation

Correct Answer

B:

Central secret storage and managed credentials separate authentication secrets from readable code artifacts. For this situation, use approved secret management or governed connection objects with least-privileged job identities. The relevant result would be that the job connects using its approved identity and stored source files contain no plaintext credential.

Incorrect Answers

A:

Least-privilege grants reduce accidental data modification and blast radius across catalogs and schemas. That option implements apply Unity Catalog grants at the narrowest required securable and remove unnecessary privileges. It addresses a different problem; here the distinguishing need is to use approved secret management or governed connection objects with least-privileged job identities.

C:

Workspace object permissions control operational actions separately from dataset query privileges. That option implements set object ACLs using least-privileged workspace and job permissions for each role. It addresses a different problem; here the distinguishing need is to use approved secret management or governed connection objects with least-privileged job identities.

D:

Access revocation must cover existing token-based sharing paths, not merely remove a user from an internal group. That option implements revoke the recipient or credential and review related object grants immediately. It addresses a different problem; here the distinguishing need is to use approved secret management or governed connection objects with least-privileged job identities.

Question 397

An audit team finds arbitrary engineers can change sensitivity labels on protected lakehouse columns.

Which authorization result verifies policy enforcement?

  1. A newly tagged field is masked for an unauthorized principal while approved users retain permitted access
  2. The same filtered query succeeds on eligible compute and unauthorized data remains concealed
  3. Unauthorized tag removal is rejected and protected columns keep their effective masking policy
  4. Test principals see only their permitted regional rows and centrally administered policy cannot be bypassed by table owners

Explanation

Correct Answer

C:

This directly verifies the intended outcome: unauthorized tag removal is rejected and protected columns keep their effective masking policy. ABAC policy selection depends on governed tags that are controlled independently of ordinary write access. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly create Unity Catalog ABAC masking policies scoped to governed tags at the appropriate catalog or schema. Tag-conditioned ABAC policies provide centralized reusable protection as new matching columns appear. The specific evidence needed here is that unauthorized tag removal is rejected and protected columns keep their effective masking policy.

B:

This would test a different behavior, chiefly use a supported serverless or compatible runtime/access configuration for ABAC policy enforcement. Fine-grained ABAC restrictions have compute prerequisites and cannot be assumed to work on all older runtimes. The specific evidence needed here is that unauthorized tag removal is rejected and protected columns keep their effective masking policy.

D:

This would test a different behavior, chiefly apply an ABAC row-filter policy driven by governed region tags and an identity-aware UDF. Row-filter policies evaluate authorized rows at query time across all matching governed objects. The specific evidence needed here is that unauthorized tag removal is rejected and protected columns keep their effective masking policy.

Question 398

A central operations portal wants to show whether all Lakeflow Jobs tasks completed in the last hour.

Which programmatic or profiling result best supports the resolution?

  1. The proposed change improves the originally dominant operator rather than just reducing total row count
  2. The portal reflects known pending successful and failed job IDs correctly
  3. The command lists only resources accessible to the service identity and reports their latest update status
  4. The profile identifies the dominant shuffle or skewed stage and its cost decreases after correction

Explanation

Correct Answer

B:

This directly verifies the intended outcome: the portal reflects known pending successful and failed job IDs correctly. Programmatic run metadata supports automation and central dashboards without screen scraping. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly inspect the SQL query profile for scan volumes, shuffles, joins and spill information. Operator-level profiling distinguishes inefficient data access from downstream aggregation work. The specific evidence needed here is that the portal reflects known pending successful and failed job IDs correctly.

C:

This would test a different behavior, chiefly use the Databricks CLI or SDK with approved permissions to list pipeline metadata and updates. Supported automation interfaces expose resource state consistently for deployment and monitoring tools. The specific evidence needed here is that the portal reflects known pending successful and failed job IDs correctly.

D:

This would test a different behavior, chiefly open Spark UI and query profile to examine stages, shuffle and task skew. Execution profiling reveals the costly operators and task distribution that are not evident from business output rows. The specific evidence needed here is that the portal reflects known pending successful and failed job IDs correctly.

Question 399

A billing report requires recomputation of a derived monthly totals table after upstream data corrections.

What outcome best verifies the pipeline design?

  1. A test source update changes the existing target key instead of leaving duplicate revisions
  2. After backfill, historical keys reconcile to expected values and the live stream continues from its prior checkpoint
  3. A source correction appears in the refreshed aggregate after the materialized view refresh completes
  4. The invalid test rows are rejected under the chosen policy and recorded quality counts match the fixture

Explanation

Correct Answer

C:

This directly verifies the intended outcome: a source correction appears in the refreshed aggregate after the materialized view refresh completes. A materialized view represents a query result refreshed from upstream dependencies rather than simply appending stream records. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly choose a materialized view or an explicit CDC design when the source requires updates and retractions. Append-oriented streaming ingestion alone does not encode which prior target rows must be replaced. The specific evidence needed here is that a source correction appears in the refreshed aggregate after the materialized view refresh completes.

B:

This would test a different behavior, chiefly separate controlled backfill processing from the live streaming checkpoint and reconcile outputs by stable keys. Reusing a live checkpoint for an unrelated replay can mix offsets and produce inconsistent duplicates. The specific evidence needed here is that a source correction appears in the refreshed aggregate after the materialized view refresh completes.

D:

This would test a different behavior, chiefly use Lakeflow expectations with explicit drop or fail behavior and capture expectation metrics. Expectations define data quality handling and surface invalid-record metrics rather than silently swallowing failures. The specific evidence needed here is that a source correction appears in the refreshed aggregate after the materialized view refresh completes.

Question 400

A payments transformation has variable throughput after a code change.

Which event-log evidence best establishes the cause or result?

  1. A test schema conflict appears with the affected dataset and disappears after the correct fix
  2. The suspect update displays a clear duration regression relative to the approved baseline
  3. The stalled flow is identified and after repair its progress and target freshness advance
  4. A known invalid input increases the recorded expectation-failure count for the correct dataset update

Explanation

Correct Answer

B:

This directly verifies the intended outcome: the suspect update displays a clear duration regression relative to the approved baseline. Time-indexed pipeline events reveal changed throughput and stage timing around a deployment. Merely seeing a green job status does not establish that the stated business condition holds.

Incorrect Answers

A:

This would test a different behavior, chiefly use pipeline event logs to isolate the failing flow and the associated error or schema details. Pipeline event records capture errors and contextual flow metadata useful for targeted remediation. The specific evidence needed here is that the suspect update displays a clear duration regression relative to the approved baseline.

C:

This would test a different behavior, chiefly inspect pipeline event logs and flow-progress events for dataset-specific update status. Flow progress shows which pipeline component processed data or failed instead of relying on an overall run badge. The specific evidence needed here is that the suspect update displays a clear duration regression relative to the approved baseline.

D:

This would test a different behavior, chiefly query the Lakeflow pipeline event log for update events and data-quality expectation metrics. Event logs expose pipeline progress and expectation outcomes that aggregate job success may hide. The specific evidence needed here is that the suspect update displays a clear duration regression relative to the approved baseline.

Certified Data Engineer Professional Practice Tests

Purchase Individually

  • Premium File

    339 Questions & Answers
    Last Update: Oct 28, 2026

    $76.99
    $69.99
  • Training Course

    33 Lectures

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports