Logo ExamsQA
Exit
Official Bank 0/49

Azure Databricks Data Engineer Associate Exam (DP-750) - Microsoft Exam Questions

Last updated on August 20, 2026

97% Exam Compliance
49 Total Questions
1
Question
You are implementing dp.create_auto_cdc_flow for a CDC feed in Lakeflow Spark Declarative Pipelines. Records must be ordered primarily by event_time, but multiple updates for the same key can share the same event_time value. Which sequence_by expression should you use to preserve event_time as the primary order and break ties deterministically? Prepare and process data
Options
A struct("event_time", "event_id")
B struct"event_id", "event_time")
C col("event_time")
D col("event_id")
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A data engineer can create managed volumes in catalog sales and schema raw. When they try to create an external volume that points to an abfss path, the command fails because of missing permissions. Which additional privilege is required? Setup and configure the Azure Databricks environment
Options
A WRITE VOLUME on the target schema
B READ VOLUME on the parent catalog
C CREATE EXTERNAL VOLUME on the external location
D MANAGE on the parent catalog
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
You are writing pipeline SQL to ingest JSON files from /Volumes/raw/iot/events into a published streaming table named bronze_events. Which statement is valid? Prepare and process data
Options
A CREATE OR REFRESH TABLE bronze_events AS SELECT * FROM STREAM
read_files("/Volumes/raw/iot/events", format => "json")
B CREATE OR REFRESH STREAMING TABLE bronze_events AS SELECT * FROM
read_files("/Volumes/raw/iot/events", format => "json")
C CREATE OR REFRESH STREAMING TABLE bronze_events AS SELECT * FROM
STREAM read_files("/Volumes/raw/iot/events", format => "json") USING DELTA
D CREATE OR REFRESH STREAMING TABLE bronze_events AS SELECT * FROM STREAM read_files("/Volumes/raw/iot/events", format = "json")
E COPY INTO bronze_events FROM "Nolumes/raw/iot/events" FILEFORMAT = JSON
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You want a Lakeflow Job to send an alert when a run exceeds its expected completion time, before it is timed out. Which configuration is required? Deploy and maintain data pipelines and workloads
Options
A Set only a Timeout value and select Failure in the job notification
B Increase the maximum concurrent runs for the job
C Select Start and Success in the job notification
D Set a Run duration Warning threshold and select Duration Warning in the job notification
E Set a Streaming backlog threshold and select Failure in the job notification
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
A nightly Azure Databricks workflow runs on job compute that can autoscale and uses multiple notebooks attached to the same compute. The workflow must use a reproducible Python environment on every node, and the library artifacts must not be stored in a location that any workspace user can modify. What should you do? Deploy and maintain data pipelines and workloads
Options
A Store wheel files in DBFS root and install the latest available versions each run
B Place dependencies in the Shared workspace folder and use notebook-scoped %pip installs
C Upload wheels or requirements.txt to a restricted workspace path or Unity Catalog volume, pin exact versions, and install as cluster libraries
D Pass package names as task parameters and let each notebook install versions at runtime
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.