Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

DP-750: Implementing Data Engineering Solutions Using Azure Databricks

Master the Microsoft Implementing Data Engineering Solutions Using Azure Databricks (DP-750) certification exam with 35 realistic practice questions covering Secure and govern Unity Catalog objects, Prepare and process data, Set up and configure an Azure Databricks environment, Deploy and maintain data pipelines and workloads.

4.8★★★★★(183 ratings)
14,703 studentsIntermediate
Prepare for the Microsoft Implementing Data Engineering Solutions Using Azure Databricks (DP-750) certification with scenario-based practice questions modeled on real exam objectives. You will build practical confidence across key domains including Secure and govern Unity Catalog objects, Prepare and process data, Set up and configure an Azure Databricks environment, Deploy and maintain data pipelines and workloads. Each question includes structured answer options and hint answers to help you identify knowledge gaps quickly, reinforce core Microsoft concepts, and pass the DP-750 exam on your first attempt.

What you'll learn

  • Secure and govern Unity Catalog objects
  • Prepare and process data
  • Set up and configure an Azure Databricks environment
  • Deploy and maintain data pipelines and workloads

DP-750

Lectures1
Questions35
Duration30 week
Students14,703

$20.00

Full Free Question Bank (35 Questions)

DP-750: Implementing Data Engineering Solutions Using Azure Databricks (DP-750) Practice Questions & Verified Answers

Click any option to test your knowledge, or reveal the verified answer and detailed explanation below each question.

Question #1Part 1Prepare and process data

You have an Azure Databricks workspace enabled for Unity Catalog that contains two Delta tables, Table1 and Table2, with the same data type. Table1 has a column named Column1. Table2 has a column named Column2. You execute the following query: ```sql SELECT Colum1 - FROM Table1 - GROUP BY Column1 - HAVING COUNT(*) > 1 - INTERSECT - SELECT Column2 - FROM Table2 - GROUP BY Column2 - HAVING COUNT(*) > 1; ``` What happens when the query is executed? SELECT Colum1 - FROM Table1 - GROUP BY Column1 - HAVING COUNT(*) > 1 - INTERSECT - SELECT Column2 - FROM Table2 - GROUP BY Column2 - HAVING COUNT(*) > 1;

AValues appear in both tables more than once.
BValues appear in either table more than once.
CValues appear in Table2 but NOT Table1.
DValues appear in Table1 more than once.
Question #2Part 1Set up and configure an Azure Databricks environment

Solution: Create a Databricks access connector. Does this meet the goal?

AYes
BNo
Question #3Part 1Deploy and maintain data pipelines and workloads

Solution: Create a Lakeflow Connect pipeline and connect it to DB1. Does this satisfy the goal?

AYes
BNo
Question #4Part 1Secure and govern Unity Catalog objects

Solution: Create a foreign catalog in Catalog Explorer. Does this achieve the goal?

AYes
BNo
Question #5Part 1Secure and govern Unity Catalog objects

Solution: Create a new native catalog in Unity Catalog. Does this meet the goal?

AYes
BNo
Question #6Part 1Secure and govern Unity Catalog objects

Your company includes sales, finance, and HR departments. You have an Azure Databricks workspace enabled for Unity Catalog. You need to implement Unity Catalog to meet the following requirements: - Access to Unity Catalog for each department must be managed independently of the other departments. - Each department’s data assets must be logically isolated from those of the other departments. - The solution must support centralized governance. What should you do for each department?

ACreate a separate Azure Data Lake Storage Gen2 account.
BCreate dynamic views.
CCreate a new workspace.
DCreate a new catalog.
Question #7Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace named Workspace1 that uses a Git repository. The repository includes a Databricks notebook named Notebook1. From the main branch, you create a feature branch named Branch1 and commit changes to Notebook1. Another user commits changes to Notebook1 on main. When you try to merge Branch1 into main, the merge fails because of conflicts. You need to merge Branch1 into the main branch. The solution must ensure that Notebook1 contains all changes from both branches. What should you do?

AFrom Workspace1, clone the main branch as a new repository.
BApply the main branch changes to Branch1 and resolve the conflicts.
CFrom Workspace1, clone Branch1 as a new repository.
DApply the changes directly to the main branch.
Question #8Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace that includes several all-purpose clusters. You find that some clusters stay idle for extended periods after users complete their work. You need to lower compute costs without impacting active workloads. What should you do?

AEnable autoscaling.
BConvert the clusters into job clusters.
CUse spot instances.
DConfigure automatic termination.
Question #9Part 1Deploy and maintain data pipelines and workloads

You need to configure compute for telemetry-data ingestion. The solution must satisfy the data ingestion and processing requirements. What should you do?

AMove the ingestion pipelines to shared compute.
BEnable Photon acceleration for a job compute cluster.
CIncrease an all-purpose cluster to a larger fixed node type.
DDisable autoscaling for a job compute cluster.
Question #10Part 1Deploy and maintain data pipelines and workloads

You need to develop the task logic for a new Lakeflow Jobs job that processes telemetry data. Each task must include only the logic appropriate to its pipeline step. The solution must support the planned changes and satisfy the data ingestion and processing requirements. What should you do?

AUse a single Databricks notebook task that performs ingestion, cleansing, and curation in one script.
BCreate separate tasks for ingestion, cleansing, and curation.
CCreate three tasks that each contains the identical logic and use task retries.
DUse a single SQL task that performs ingestion, cleansing, and curation by running MERGE commands.
Question #11Part 1Secure and govern Unity Catalog objects

You need to organize Unity Catalog in a way that meets the governance requirements. What should you do?

AUse a single shared schema for all the development teams and rely on table-level permissions for isolation.
BEnable the development teams to create objects directly in the default catalog and schema.
CCreate a separate catalog for each development team and enable each team to choose its own schema names.
DCreate a shared development catalog, enforce a standardized naming convention, and assign each development team its own schema.
Question #12Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace with Unity Catalog enabled. You need to recommend a pipeline that ingests files from cloud storage, applies cleansing and enrichment transformations, and writes curated Delta tables for analytics. The solution must minimize development effort while providing built-in monitoring and automatic retries. What should you include in the recommendation?

Aa Databricks notebook triggered by a scheduled job
Ban Apache Spark Structured Streaming job
Can MLflow pipeline
Da Lakeflow Spark Declarative Pipelines (SDP) pipeline
Question #13Part 1Secure and govern Unity Catalog objects

You have an Azure Databricks workspace enabled for Unity Catalog that contains a managed Delta table named `Sales`. `Sales` stores transaction data and has the following columns: - `transaction_id` (string) - `transaction_date` (date) - `amount` (decimal) You need to implement these data-quality requirements by using table-level data-quality enforcement: - `amount` must be greater than 0. - `transaction_id` must never be null. Invalid records must be rejected when they are written to the `Sales` table. What should you do?

AUse a SELECT statement with WHERE conditions to validate the data before querying.
BCreate a view that filters out rows where transaction_id is null or amount is less than or equal to 0.
CAdd a NOT NULL constraint to transaction_id and a CHECK constraint to amount.
DConfigure row-level security (RLS) where transaction_id is null or amount is less than or equal to 0.
Question #14Part 1Prepare and process data

You have an Azure Databricks workspace enabled for Unity Catalog. You have a Lakeflow Spark Declarative Pipelines (SDP) pipeline that writes numerical data to a table named Table1 by using a data-quality validation rule named rule1. You need to change rule1 to meet these requirements: - Ensure that `amount` is always greater than 0. - Prevent an update to Table1 from being committed when data that violates rule1 is detected. Which statement should you execute?

A@dlt.expect_or_fail(“rule1”, ”amount > 0”)
B@dlt.expect(“rule1”, “amount > 0”)
C@dlt.expect_all_or_drop({“rule1”: “amount > 0”})
D@dlt.expect_or_drop(“rule1”, “amount > 0”)
Question #15Part 1Prepare and process dataSelect 2

You have an Azure Databricks workspace that includes a Delta table named Table1. Table1 has accumulated obsolete files. You need to reduce storage costs while preserving 30 days of time-travel history. Which two actions should you take? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

ARun the vacuum command on Table1.
BSet the delta.deletedFileRetentionDuration table property to 30 days.
CSet the delta.logRetentionDuration table property to 30 days.
DRun the OPTIMIZE command on Table1.
EReduce the deleted file retention period to one day.
Question #16Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace that uses serverless compute. You need to ingest data by using Lakeflow Jobs. New records must be processed as soon as they are available. Which job-trigger type should you use for the ingestion?

Amanual
Bfile arrival
Cscheduled
Dcontinuous
Question #17Part 1Secure and govern Unity Catalog objects

You have an Azure Databricks workspace enabled for Unity Catalog. A CSV file is stored in an Azure Data Lake Storage Gen2 container. You plan to ingest the data into an existing table by running the following SQL statement. ```sql COPY INTO Customer - FROM ‘abfss://[email protected]/data/customer’ FILEFORMAT = CSV - ``` You need to ensure that the statement can access the data in the container. What should you configure? COPY INTO Customer - FROM ‘abfss://[email protected]/data/customer’ FILEFORMAT = CSV -

Aan external table named Customer in the CSV file format
Ba Lakeflow ingestion gateway
Can external location that uses a storage credential
Da volume in a catalog
Question #18Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace enabled for Unity Catalog. You have a complex job named Job1 that contains eight tasks. Job1 requires multiple hours to complete. During the most recent job run, the final task fails because of a transient issue. You need to retry the final task without rerunning tasks that have already completed. What should you do?

ARepair the current job run.
BUpdate the job parameters.
CDisable and reenable the job schedule.
DRestart Job1.
Question #19Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace. You have an Apache Spark Structured Streaming job named Job1 that continuously processes data and periodically fails because of transient errors. You need to ensure that Job1 meets the following requirements: - Resumes processing from the point at which Job1 failed - Minimizes the time required to restart Job1 - Minimizes the cost of restarting Job1 What should you do?

ADecrease the retry interval.
BIncrease the minimum number of nodes in the cluster.
CAdd an alert and manually restart Job1.
DImplement checkpointing.
Question #20Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace enabled for Unity Catalog. You plan to ingest data from CSV files stored in Azure Data Lake Storage Gen2. New rows are appended frequently. You need to implement a data-ingestion solution that meets the following requirements: - New data must be available near real-time (NRT). - The data must be stored in managed Delta tables. - The solution must minimize custom code and maintenance effort. What should you include in the solution?

Ascheduled Apache Spark batch jobs
Ban Azure Data Factory pipeline
CAuto Loader
Dan external table that references the CSV files
Question #21Part 1Deploy and maintain data pipelines and workloads

You need to deploy Declarative Automation Bundles to a development environment. The solution must enable automated, repeatable deployments across environments. What should you use?

Athe Databricks CLI
BGit folders
Cthe Azure Developer CLI (azd)
Dthe Azure Command-Line Interface (CLI)
Question #22Part 1Prepare and process data

You have a Lakeflow Spark Declarative Pipelines (SDP) pipeline in Azure Databricks that ingests transaction data into a table named Table1. You need to make sure the pipeline continues running when an invalid record occurs. The solution must meet these requirements: - Invalid records must **NOT** be written to Table1. - Invalid records must be retained for review. - Minimize development effort. What should you do?

AAdd a CHECK constraint to Table1.
BRun WHERE clauses in downstream queries to filter out invalid records.
CDefine a pipeline expectation.
DImplement advanced logic to quarantine the invalid records.
Question #23Part 1Deploy and maintain data pipelines and workloads

You use Databricks Asset Bundles to manage two jobs and an app. You need to deploy the bundle to development and production environments. The solution must meet these requirements: - Deploy the app to both environments. - Deploy only one job to development. - Minimize administrative effort. What should you use?

Aseparate databricks.yml files for each environment
Ba variables node in a databricks.yml file
Ca resources node in a databricks.yml file
Da targets node in a databricks.yml file
Question #24Part 1Prepare and process data

You have an Azure Databricks workspace enabled for Unity Catalog that contains a Delta table named Table1. Table1 is used as a dimension table and has the following columns: `id` `name` `address` You need to use a Type 1 slowly changing dimension (SCD) approach when updates are processed for the `name` and `address` columns. What occurs when an update is processed?

AA new row will be added for each change to a name and address.
BThe value of the id column will be updated.
CThe existing name and address values will be overwritten.
DHistorical versions of the row and its effective dates will be retained.
Question #25Part 1Set up and configure an Azure Databricks environmentSelect 2

You have an Azure Databricks workspace that includes an all-purpose cluster named Cluster1. You need to configure Cluster1 to meet these requirements: - Scale up automatically as workloads increase. - Scale down automatically as workloads decrease. - Minimize costs. Which two actions should you take? Each correct answer presents part of the solution. **NOTE:** Each correct selection is worth one point.

ADisable Photon acceleration.
BEnable autoscaling for Cluster1.
CApply a compute policy that enables users to manage the cluster settings.
DSpecify a fixed number of workers.
EConfigure Cluster1 to terminate after 30 minutes of inactivity.
Question #26Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace enabled for Unity Catalog that contains a managed Delta table named Table1. Table1 holds customer data. You need to implement a data-lifecycle solution that satisfies these requirements: - Deleted data must remain recoverable for 30 days to support audits. - Data older than 30 days must be permanently removed. - The solution must require minimal administrative effort. - The solution must be applied consistently. What should you configure?

Ascheduled DELETE operations
Bthe data lineage
CAzure Storage lifecycle management
Ddata retention for Table1
Question #27Part 1Set up and configure an Azure Databricks environment

You have an Azure Databricks workspace that includes a cluster named Cluster1. Performance monitoring indicates that Cluster1 is consistently overprovisioned for its batch workload: - CPU utilization stays below 20 percent, even during peak processing periods. - The workload is highly predictable and has no spikes. - The current node type already satisfies the workload requirements. You need to lower compute costs without increasing job duration. What should you do?

AEnable Photon acceleration.
BConfigure Cluster1 to use a larger node type.
CDecrease the autotermination timeout of Cluster1.
DDisable autoscaling and reduce the number of worker nodes.
Question #28Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace containing a Lakeflow Jobs job named Job1. Job1 processes raw data files stored in Azure Storage. New files arrive at unpredictable intervals. You need to ensure that Job1 starts automatically when new files arrive and doesnotconsume compute resources when no data is available. Which type of job trigger should you use?

Amanual
Bfile arrival
Ccontinuous
Dscheduled
Question #29Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace with Unity Catalog enabled. You need to recommend a pipeline that ingests files from cloud storage, performs cleansing and enrichment transformations, and writes curated Delta tables for analytics. The solution must minimize development effort while providing built-in monitoring and automatic retries. What should be included in the recommendation?

Aa Databricks notebook triggered by a scheduled job
Ban Apache Spark Structured Streaming job
Ca Lakeflow Spark Declarative Pipelines (SDP) pipeline
Dan Azure Data Factory pipeline that uses data flows
Question #30Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks solution developed by several engineers and deployed across development, test, and production environments. You need to implement an application lifecycle management (ALM) process that meets these requirements: - Deploys and source-controls Databricks notebooks, workflows, and jobs consistently and repeatably - Parameterizes the target deployment environment What should you include in the solution?

Athe export and import of Databricks workspaces
BDatabricks resources managed by using the Databricks Terraform provider
CGit folders and manual promotion
DDeclarative Automation Bundles in Git
Question #31Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace containing a Lakeflow Jobs job named Job1. Job1 has multiple tasks. Some tasks are business-critical, while others are not. You need to configure alerts so that: - Failures in non-critical tasks do not send notifications. - Notifications are sent only when critical portions of the workflow fail. What should trigger a notification?

Atask success
Bjob success
Ca task failure
Da job failure
Question #32Part 1Prepare and process data

You have an Azure Databricks workspace enabled for Unity Catalog that contains two managed Delta tables named `sales.schema1.table1` and `sales.schema1.table2`. `sales.schema1.table1` contains sales data for the current year. `sales.schema1 .table2` contains historical data. You need to load every row from `sales.schema1.table1` into `sales.schema1.table2`. The solution must retain existing data in `sales.schema1.table2` and minimize processing effort. Which command should you run?

AINSERT OVERWRITE sales.schema1.table2 SELECT * FROM sales.schema1.table1;
BCREATE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
CINSERT INTO sales.schema1.table2 SELECT * FROM sales.schema1.table1;
DCREATE OR REPLACE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
Question #33Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace containing a Git folder that uses an Azure Repos Git repository. From the main branch, you create a branch named Branch1 and commit changes to Branch1. You need to integrate the changes from Branch1 into main. The solution must retain the repository’s commit history. Which Git operation should you use?

Arebase
Bpull
Cmerge
Dpush
Question #34Part 1Set up and configure an Azure Databricks environment

You have an Azure Databricks workspace called Workspace1. You create a compute cluster called Cluster1 that will be used to ingest data. You need to install the necessary libraries on Cluster1. The solution must use Unity Catalog for access control. What should you do?

AInstall the libraries by using pip3.
BCreate a custom dependency management script and run the script from a Databricks notebook.
CUpload the libraries to Workspace1 and install the libraries on Cluster1.
DInstall the libraries on Cluster1 and manually restart the cluster.
Question #35Part 1Deploy and maintain data pipelines and workloads

You have an Azure Databricks workspace that uses Unity Catalog. You have a Lakeflow Spark Declarative Pipelines (SDP) pipeline that ingests data into a managed Delta table named Table1. Table1 is used for analytics. New columns are added to the source data, which causes pipeline write failures to Table1. You need to prevent the pipeline failures. The solution must ensure that schema changes are detected and handled. What should you do?

ADisable schema enforcement for Table1.
BUse row filters to exclude records that have new columns.
CEnable schema evolution.
DCreate a separate table for each schema version.

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!