| Exam Code | DP-750 |
| Exam Name | Implementing Data Engineering Solutions Using Azure Databricks |
| Questions | 58 Questions Answers With Explanation |
| Update Date | July 09,2026 |
| Price |
Was : |
Welcome to Certsleader, your ultimate source for top-quality DP-750 dumps tailored for Microsoft DP-750 exam. Our comprehensive resources are designed to help you excel in your exam preparations and achieve your certification goals. Whether you are a beginner looking to start a career in Microsoft or an experienced professional seeking to advance your skills, Certsleader has the right tools to support your journey.
At Certsleader, we are committed to your success. Our practice questions answers are designed to improve your knowledge and help you pass your exams on the first attempt with high scores. In the rare event that you do not succeed, we offer a full refund, taking responsibility for your satisfaction.
Join thousands of satisfied learners who have successfully passed their certification exams with Certsleader. Explore our study materials, download your PDF files, and take the first step towards a rewarding IT career today.
You have an Azure Databricks workspace that is enabled for Unity CatalogYou have a complex job named Job1 that contains eight tasks. Job! takes multiple hours tocompleteDuring the last job run, the final task fails due to a transient issue.You need to retry the last task without rerunning tasks that have already completed.What should you do?
A. Update the job parameters.
B. Repair the current job run.
C. Restart Job!
D. Disable and reenable the job schedule
You have an Azure Databricks workspace that is enabled for Unity Catalog.You need to recommend a pipeline that ingests files from cloud storage, performscleansing and enrichment transformations, and writes created Delta tables for analytics.The solution must minimize development effort and provide built-in monitoring andautomatic retries.What should you include in the recommendation?
A. an Apache Spark Structured Streaming job
B. a Databricks notebook triggered by a scheduled job
C. a Lakeflow Spark Declarative Pipelines (SDPJ pipeline
D. an Azure Data Factory pipeline that uses data flows
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains acatalog named Catalog 1. Catalog 1 contains a table named Transactions. Transactionscontains the following columns:• transaction_id• customet_name• email address• credit_card_number• transaction_amountYou need to ensure that business analysts can query all the tows in the Transactions table.The solution must meet the following requirements:• Prevent the analysts from seeing the full values in the email_address andcredit_catd_number columns.• Ensure that the analysts can see only the values after the @ character in each emailaddress.• Ensure that the analysts can see only the last four digits of each credit card number.• Enable the analysts to query the table without errors.• Follow the principle of least privilege.What should you do?
A. Grant the analysts the SELECT permission for the Transactions table and implement
row-level filters.
B. Grant the analysts the select permission for columns that do NOT contain sensitive data.
C. Grant the analysts the select permission for the Transactions table and apply column
masks to email_address and credit_card_number
D. Grant the analysts the select permission for the Transactions table and apply columnlevel encryption
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains aDelta table named Sales_orders. Sales.orders stores historical sales data.You receive a daily CSV file daily that contains new sales records only. The file does NOTcontain updates to existing rows You need to load the daily data into Sales.orders. Thesolution must meet the following requirements:• Preserve the existing data.• Add only the new records.• Minimize processing effort.Which command should include in the loading strategy?
A. INSERT OVERWRITE
B. UPDATE
C. INSERT INTO
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains amanaged Delta table named Table1. Table1 stores customer data.You need to implement a data retention solution that meets the following requirements:Deleted data must be retained for 30 days to support audits.Deleted data that is older than 30 days must be removed permanently.The solution must minimize administrative effort.Which two properties should you configure? Each correct answer presents part of thesolution.NOTE: Each correct selection is worth one point.
A. delta.timeUntilArchived
B. delta.deletedFileRetentionDuration
C. delta.autoOptimize.autoCompact
D. delta.logRetentionDuration
E. delta.enableDeletionVectors
You have an Azure Databricks workspace named Workspace! that uses a Git repository.The repository contains a Databricks notebook named Notebook1.From the main branch, you create a feature branch named Branch! and commit changes toNotebooks Another user commits changes to Notebook1 in main.When you attempt to merge Branch! into main, the merge fails due to conflicts.You need to merge Branch! into the main branch. The solution must ensure that Notebook1includes all the changes from both the branches.What should you do?
A. From Workspace1, clone Branch! as a new repository.
B. Apply the changes directly to the main branch.
C. From Workspace1, clone the mam branch as a new repository.
D. Apply the main branch changes to Branch! and resolve the conflicts.
You have an Azure Databricks workspace named Workspace1 that contains a takehouseand is enabled for Unity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a new native catalog in Unity Catalog. Does this meet the goal?
A. Yes
B. No
You need to deploy Databricks Asset Bundles to a development environment. The solution must support automated and repeatable deployments across environments. What should you use?
A. the Azure Developer CLI (azd)
B. Git folders
C. the Databricks CLI
D. the Azure Command-Line Interface (CLI)
You have an Azure Databricks workspace that uses Unity Catalog.You have a Lakeflow Spark Declarative Pipelines (SDP) pipeline that ingests data into amanaged Delta table named Table1. Table! is used for analytics.New columns are added to the source data, causing pipeline failures during writes to Table!You need to prevent the pipeline failures. The solution must ensure that schema changesare detected and handled.What should you do?
A. Disable schema enforcement for Table1.
B. Use row filters to exclude records that have new columns.
C. Enable schema evolution.
D. Create a separate table for each schema version.
You have an Azure Databricks workspace named Workspace1 that contains a lakehouseand is enabled for Unity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a Lakeflow Connect pipeline and connect it to DB1. Does this meetthe goal?
A. Yes
B. No
You have an Azure Databricks workspace that is enabled for Unity CatalogYou have an Apache Spark Structured Streaming job that writes data to a Delta table.After the cluster restarts, the streaming job reprocesses previously ingested dataYou need to prevent the streaming job from reprocessing the data after the cluster restarts.What should you do?
A. Increase the trigger interval of the streaming query.
B. Configure a checkpoint location for the streaming query.
C. Configure a watermark for the streaming query.
D. Enable change data feed (CDF) for the target table.
You have an Azure Databricks workspace that is enabled for Unity Catalog and containstwo managed Delta tables named sales.schema1.table1 and sales.schema1.table2.sales.schema1.table1 contains sales data from the current year.sales.schema1.table2 contains historical data.You need to load all the rows from sales.schema1.table1 into sales.schema1.table2. Thesolution must preserve any existing data in sales.schema1.table2 and minimize processingeffort.Which command should you run?
A. INSERT INTO sales.schema1.table2 SELECT * FROM sales.schema1.table1;
B. CREATE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
C. INSERT OVERWRITE sales.schema1.table2 SELECT * FROM sales.schema1.table1;
D. CREATE OR REPLACE TABLE sales.schema1.table2 AS SELECT * FROMsales.schema1.table1
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains aDelta table named Orders.You load the Orders table into an Apache Spark DataFrame named df.You need to create a DataFrame that excludes rows where the order amount is null.Solution: You run the following expression.df.filter(df.order_amount != None)Does this meet the goal?
A. Yes
B. No
You have an Azure Databricks workspace that contains multiple all-purpose clusters. Youdiscover that some clusters remain idle for long periods after users finish their work. Youneed to reduce compute costs without affecting active workloads. What should you do?
A. Convert the clusters into job clusters
B. Use spot instances.
C. Enable autoscaling.
D. Configure automatic termination.
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains aDelta table named OrdersYou load the Orders table into an Apache Spark DataFrame named df.You need to create a DataFrame that excludes rows where the order amount is null.Solution: You run the following expression.df-fillna(0, subset=['order_amount'])Does this meet the goal?
A. Yes
B. No
You have an Azure Databricks workspace named Workspace1. You create a computecluster named Cluser1 that will be used to ingest data.You need to install the required libraries on Cluster 1. The solution must use Unity Catalogfor access control. What should you do?
A. Create a custom dependency management script and run the script from a Databricksnotebook.
B. Install the libraries by using pip3.
C. Install the libraries on Cluster1 and manually restart the cluster.
D. Upload the libraries to Workspace1 and install the libraries on Cluster1.
You have an Azure Databricks workspace that is attached to a Unity Catalog metastorenamed metastore1. Metastore1 contains a catalog named catalog 1.You need to create a new schema named schema2 that meets the following requirements:• Is contained in catalog1• Uses abfss://containergstorageaccount.dfs.core.windows.net/data as the ManagedlocationWhich SQL statement should you execute?
A. CREATE SCHEMA catalog1.schema2MANAGED LOCATION 'abfss://[email protected]/data';
B. CREATE CATALOG schema2MANAGED LOCATION 'abfss://[email protected]/data';
C. CREATE SCHEMA catalog1.schema2LOCATION 'abfss://[email protected]/data';
D. CREATE SCHEMA catalog1.schema2WITH DBPROPERTIES(LOCATION='abfss://[email protected]/data');
You have an Azure Databricks workspace named Workspace1 that contains a lakehouseand is enabled for Unity Catalog.You have a connection to a Microsoft SQL Server database named DB1.You need to expose the schemas and tables of DB1 to meet the following requirements:• The schemas and tables can be queried in Databricks.• The schemas and tables appear alongside other Unity Catalog objects.• The data is NOT copied into Databricks-managed storage.Solution: You create a foreign catalog in Catalog Explorer.Does this meet the goal?
A. Yes
B. No
You have an Azure Databricks workspace that contains an all-purpose cluster namedCluster! You need to configure Cluster1 to meet the following requirements;• The cluster must scale up automatically when workloads increase.• The cluster must scale down automatically when workloads decrease.The solution must minimize costs.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
A. Disable Photon acceleration.
B. Apply a compute policy that enables users to manage the cluster settings.
C. Configure Cluster1 to terminate after 30 minutes of inactivity.
D. Enable autoscaling for Cluster1.
E. Specify a fixed number of workers.
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains aDelta table named Orders.You load the Orders table into an Apache Spark DataFrame named df.You need to create a DataFrame that excludes rows where the order amount is null.Solution: You run the following expression.df.filter(df.order_amount.isNotNull())Does this meet the goal?
A. Yes
B. No
