All Practice Exams

100+ Free Azure Databricks Data Engineer Associate Practice Questions

Microsoft Certified: Azure Databricks Data Engineer Associate (Exam DP-750) practice questions are available now; exam metadata is being verified.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Within a Lakeflow Declarative Pipeline, which flow type applies change data capture to maintain a target table, including support for slowly changing dimension type 2 history?

A
B
C
D
to track
2026 Statistics

Key Facts: Azure Databricks Data Engineer Associate Exam

$165

Exam Fee (USD)

Microsoft

700/1000

Passing Score

Microsoft

120 min

Exam Duration

Microsoft

30-35%

Weight of the two largest skill areas each

Microsoft DP-750 study guide

May 2026

Expected General Availability

Microsoft

1 year

Credential Validity

Microsoft (free online renewal)

Microsoft lists Exam DP-750 (Azure Databricks Data Engineer Associate) as a role-based associate exam delivered through Pearson VUE, with a 700/1000 passing score, a $165 USD fee, and a 120-minute duration. It entered beta in March 2026 with general availability expected in May 2026. The four skill areas are Set up and configure an Azure Databricks environment (15-20%), Secure and govern Unity Catalog objects (15-20%), Prepare and process data (30-35%), and Deploy and maintain data pipelines and workloads (30-35%). Question count is not fixed but associate exams typically present about 40 to 60 items.

Sample Azure Databricks Data Engineer Associate Practice Questions

Try these sample questions to test your Azure Databricks Data Engineer Associate exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1A data engineering team needs a compute resource that automatically shuts down between scheduled runs to control cost and only runs a single nightly ETL notebook. Which Azure Databricks compute type is the most appropriate choice?
A.An always-on all-purpose (interactive) cluster shared across the team
B.A SQL warehouse in serverless mode
C.Job compute provisioned for the workflow run
D.A personal dedicated cluster left running for the day
Explanation: Job compute is created when a Lakeflow Job task starts and is terminated when the run completes, so it does not incur cost between scheduled runs. It is the recommended compute for automated, non-interactive workloads such as a nightly ETL notebook.
2You want clusters that can be reused across the team to access Unity Catalog data while supporting multiple concurrent users with data isolation between them. Which cluster access mode should you configure?
A.Dedicated (single-user) access mode
B.Standard (shared) access mode
C.No-isolation shared mode
D.Hive metastore legacy mode
Explanation: Standard access mode (formerly shared access mode) supports multiple users on the same cluster with process isolation while fully supporting Unity Catalog governance. Databricks recommends standard access mode for most workloads.
3Which compute feature setting in Azure Databricks accelerates SQL and DataFrame workloads using a native vectorized engine written in C++?
A.Adaptive Query Execution
B.Delta caching
C.KEDA autoscaling
D.Photon acceleration
Explanation: Photon is the native vectorized query engine in Databricks that accelerates SQL and DataFrame operations. It is enabled as a compute feature setting and speeds up CPU-bound analytical workloads.
4A team wants new clusters to start faster by drawing pre-initialized cloud VMs from a ready pool. Which compute performance setting addresses this?
A.Autoscaling
B.Instance pools
C.Auto-termination
D.Spot instances
Explanation: Instance pools maintain a set of idle, ready-to-use cloud instances so that clusters and jobs can acquire nodes quickly, reducing cluster start and scale-up times. Pooling is the performance setting designed for faster acquisition.
5An administrator wants to restrict which cluster configurations users can create, for example limiting node types and forcing auto-termination after 30 minutes. What is the recommended mechanism?
A.Workspace IP access lists
B.Compute (cluster) policies
C.Unity Catalog row filters
D.Personal access token scopes
Explanation: Compute policies define a set of rules that limit how users can configure clusters, such as allowed node types, autoscaling limits, and mandatory auto-termination. Databricks recommends policies to enforce cost and governance guardrails on compute.
6Which statement correctly describes the Unity Catalog object hierarchy for the three-level namespace?
A.Workspace contains catalogs, which contain tables directly
B.Catalog contains metastores, which contain schemas
C.Metastore contains catalogs, catalogs contain schemas, and schemas contain tables and other objects
D.Schema contains catalogs, which contain tables
Explanation: Unity Catalog uses the hierarchy metastore -> catalog -> schema -> table/view/volume/model. A table is referenced with the three-part name catalog.schema.table. The metastore is the top-level container of metadata for a region.
7In Unity Catalog, which object combines a cloud storage path with a storage credential to authorize access to a broad area of Azure Data Lake Storage?
A.A volume
B.An external location
C.A schema
D.A managed table
Explanation: An external location pairs an ADLS Gen2 path with a storage credential that authorizes access to that path. Unity Catalog privileges on the external location control who can create external tables and volumes there.
8When configuring a storage credential in Azure Databricks to access ADLS Gen2 without storing secrets, which credential type follows Microsoft's recommended security practice?
A.Account access key
B.Shared Access Signature (SAS) token
C.Azure Managed Identity via an access connector
D.Service principal client secret in plaintext
Explanation: Microsoft recommends creating the storage credential using an Azure Managed Identity tied to a Databricks Access Connector. This avoids storing static secrets and uses Microsoft Entra identity to authorize Unity Catalog access to storage.
9A data engineer needs to install a custom Python wheel so that it is available to all notebooks running on a specific job cluster. Where should the library be configured?
A.By committing the wheel to the workspace Git folder
B.As a Unity Catalog volume only
C.In the SQL warehouse settings
D.As a cluster-scoped library on the compute resource
Explanation: Cluster-scoped (compute) libraries are installed on the cluster and are available to all notebooks and jobs that run on it. You can attach a PyPI package, a Maven coordinate, or a wheel file as a compute library.
10Which Azure Databricks compute is purpose-built to run Databricks SQL queries and power BI dashboards against Delta tables?
A.All-purpose cluster
B.Job compute
C.SQL warehouse
D.Single-node cluster
Explanation: A SQL warehouse (formerly SQL endpoint) is compute optimized for running SQL queries and BI workloads in Databricks SQL. Serverless SQL warehouses start almost instantly and scale for concurrency.

About the Azure Databricks Data Engineer Associate Practice Questions

Verified exam format metadata for Microsoft Certified: Azure Databricks Data Engineer Associate (Exam DP-750) is pending. The practice questions above remain available while official exam length, timing, passing score, fee, and administrator details are reviewed.