Pass with professional DP-750 actual quiz materials

Microsoft DP-750 Exam Overview:

Microsoft DP-750 Exam Syllabus Topics:

Microsoft Implementing Data Engineering Solutions Using Azure Databricks Sample Questions:

1. You need to configure resiliency for a job in Lakeflow Jobs named Job1 to meet the pipeline deployment and operation requirements.
What should you do?

A) Configure Job1 to start always from the first task when any task fails.
B) Enable task-level retries on the ingestion task and leave downstream tasks unchanged.
C) Disable retries and configure Job1 to run manually only.
D) Enable a restart upon a job failure and set the retry count to 0.

2. You have an Azure Databricks workspace.
Users report that a Databricks notebook that runs each day takes longer than expected to run.
When reading the Directed Acyclic Graph (DAG), you discover the following issues concerning the Apache Spark stage:
* Most tasks in the stage finish quickly.
* A few tasks in the stage run more slowly.
* The CPU is underutilized at the end of the stage.
* The slow tasks process many more input records.
* The stage is blocked while it waits for the few slow tasks.
What is the root cause of the issues?

A) spilling
B) caching
C) skewing
D) shuffling

3. 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, causing pipeline failures during writes to Table1.
You need to prevent the pipeline failures. The solution must ensure that schema changes are 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) Create a separate table for each schema version.
D) Enable schema evolution.

4. You have an Azure Databticks workspace that contains an all-purpose compute cluster named Cluster1.
Cluser1 is used for
interactive development.
You need to configure Cluster1 to meet the following requirements:
* Automatically add and remove worker nodes based on workload demand
* Automatically shut down when the cluster has been idle for a specific period.
What should you configure for each requirement? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point.

5. You have an Azure Databricks workspace that is enabled for Unity Catalog.
You need to profile a table to meet the following requirements:
* The count of null values per column must be evaluated repeatedly as new records are added to the table.
* Changes in the count of null values must be observable over the progression of the dataset.
Which type of profile should you create?

A) time series
B) inference
C) snapshot

Solutions: