Free DP-750 Exam Braindumps
Implementing Data Engineering Solutions Using Azure Databricks Questions 6–10 (page: 3)

Updated On: 3-Nov-2026
View Related Case Study

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

  1. Install the libraries by using pip3.
  2. Create a custom dependency management script and run the script from a Databricks notebook.
  3. Upload the libraries to Workspace1 and install the libraries on Cluster1.
  4. Install the libraries on Cluster1 and manually restart the cluster.

Answer(s): C

Explanation:

The best action is uploading the libraries to the workspace and installing the libraries on the cluster (or ideally uploading them to Unity Catalog volumes).
Unity Catalog Compatibility: When using Unity Catalog for access control, compute clusters are typically configured with Standard (Shared) access mode. In this mode, traditional cluster init scripts [Not B.] face strict execution restrictions or are completely blocked to maintain secure user isolation.
Governance: Uploading your packages as Workspace Files or to Unity Catalog volumes allows administrators to manage access permissions directly and add them to an allowlist if needed.
Cluster-Wide Availability: Installing the libraries via the cluster's Libraries tab ensures that the required ingestion packages are automatically pre-installed and available across all nodes and notebooks running on that cluster.
Incorrect:
[Not A]
Running pip3 install manually on a cluster terminal or inside a notebook only applies to the specific notebook session (notebook-scoped). It does not natively persist across cluster restarts or handle cross-node execution effectively for data ingestion pipelines.
[Not B]
Running a custom script or a legacy init script to modify system-level paths introduces security risks and is generally incompatible with Unity Catalog's strict execution isolation policies for shared compute.


Reference:

https://docs.databricks.com/aws/en/libraries/



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a catalog named finance.
The finance contains two schemas named default and procurement.
You need to create a table named assets in the procurement schema, assets must contain the following columns:
-asset_id asset_type asset_name
How should you complete the SQL statement? To answer, drag the appropriate values to the correct targets. Each value 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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Completed SQL Statements
USE CATALOG finance;
USE SCHEMA procurement;
CREATE TABLE assets (
asset_id INT,
asset_name STRING,
asset_type STRING
);
Box 1: CATALOG finance
CATALOG finance - the root container holding your data.
Box 2: SCHEMA procurement
SCHEMA procurement - the specific database/schema where the table must live.
Box 3: TABLE assets
TABLE assets - The name of the table you are creating.


Reference:

https://docs.databricks.com/aws/en/catalogs/



View Related Case Study

You have an Azure Databricks workspace that contains a cluster named Cluster1.
Performance monitoring shows that Cluster1 is consistently overprovisioned for its batch workload:
-CPU utilization remains below 20 percent, including peak processing periods.
-The workload is highly predictable and does not spike.
-The current node type already meets the workload requirements.
You need to reduce compute costs without increasing job duration.
What should you do?

  1. Enable Photon acceleration.
  2. Configure Cluster1 to use a larger node type.
  3. Decrease the autotermination timeout of Cluster1.
  4. Disable autoscaling and reduce the number of worker nodes.

Answer(s): D

Explanation:

To drastically reduce compute costs without extending the job duration, you should reduce the number of worker nodes in the cluster configuration.
Low Utilization: A consistent CPU utilization below 20% confirms that the cluster has far more processing power than the batch workload requires.
Predictable Workload: Because the workload is completely stable and does not experience random spikes, you do not need to keep excess buffer nodes active.
Appropriate Node Type: The prompt explicitly states the current node type meets the requirements. Changing the VM size/type to a smaller variant could risk running out of memory (OOM) or causing disk spilling, which would degrade performance and extend job duration.
Linear Cost Reduction: Reducing the node count directly cuts down both the Azure VM infrastructure costs and Databricks Unit (DBU) consumption.
Best Practices for Implementation
To safely execute this change for your batch workload, configure the following settings:
*-> Use a Fixed Size (Disable Autoscaling): Since the workload is highly predictable and does not spike, use a fixed-size cluster. Autoscaling can add unnecessary cluster startup and step-up latency, which can negatively impact batch job windows.
Migrate to Job Compute: If this batch workload is currently running on an All-Purpose cluster, migrate it to an Automated Job Cluster. Job clusters cost significantly less per DBU than interactive clusters and automatically terminate immediately after the job finishes.


Reference:

https://www.linkedin.com/posts/nupur-zavery-4a47811b0_databricks-jobs-are-slow-usually-for-these-activity-7 395852001772867584-WF58



View Related Case Study

You have an Azure Databricks workspace that contains the objects shown in the following table.

Users often use the following words to refer to a sale: transaction, event, order, and invoice.
You need to create a knowledge store. The solution must ensure that when the users use any of the words in Space1, Genie queries the Sales1 table. Any other Genie spaces must remain unaffected.
To which object should you add the instructions?

  1. Sales1
  2. Schema1
  3. Space1
  4. Catalog1
  5. Notebook1

Answer(s): C

Explanation:

To map specific user terminology to your table without affecting other spaces, you should add Synonyms to the knowledge store metadata of the Genie Space.
Bridges Business Jargon: Adding transaction, event, order, and invoice as synonyms tells Genie that these terms are fully interchangeable with your target table or its columns.
Space-Scoped Isolation: Metadata configured inside the knowledge store is explicitly scoped locally to that specific Genie Space. It will not overwrite your underlying Unity Catalog metadata or influence how other Genie Spaces interpret those words.
How to apply it:
Open your specific AI/BI Genie space.Click on Configure > Data.Select your target table.
Under the table or column metadata, find the Synonyms field and add the words: transaction, event, order, and invoice.


Reference:

https://www.databricks.com/blog/data-dialogue-best-practices-guide-building-high-performing-genie-spaces



View Related Case Study

You have an Azure Databricks solution that was developed by multiple engineers and deployed to development, test, and production environments.
You need to implement an application lifecycle management (ALM) process that meets the following requirements:
-Deploys and provides source control for Databricks notebooks, workflows, and jobs in a consistent and repeatable way
-Parameterizes the target deployment environment
What should you include in the solution?

  1. the export and import of Databricks workspaces
  2. Databricks resources managed by using the Databricks Terraform provider
  3. Git folders and manual promotion
  4. Declarative Automation Bundles in Git

Answer(s): D

Explanation:

You should add Databricks Asset Bundles (DABs) to your Git repository to fulfill these Application Lifecycle Management (ALM) requirements.
Databricks Asset Bundles represent the modern, declarative toolset specifically designed by Databricks to manage notebooks, workflows, pipelines, and jobs as code across multi-workspace environments (Development, Test, and Production).


Reference:

https://www.freshgravity.com/insights-blogs/streamlining-databricks-deployments/



Viewing page 3 of 23
Viewing questions 11 - 15 out of 108 questions


Post your Comments and Discuss Microsoft DP-750 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!