Free DP-750 Exam Braindumps
Implementing Data Engineering Solutions Using Azure Databricks Questions 20–24 (page: 9)

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

Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You have an Azure Databricks workspace named Workspace1 that contains a lakehouse and 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?

  1. Yes
  2. No

Answer(s): B

Explanation:

Correct:
* You create a foreign catalog in Catalog Explorer.
You should create a Foreign Catalog using Lakehouse Federation.
Data Copying: Lakehouse Federation queries data directly in the source SQL Server without moving or copying it.
Seamless Integration: The database schemas and tables appear right inside Unity Catalog alongside your other data objects.Real-time Access: It provides immediate access to live SQL Server data.
Incorrect:
* You create a Databricks access connector.
* You create a Lakeflow Connect pipeline and connect it to DB1.
Data Copying: Lakeflow Connect is an ingestion tool that physically replicates and copies data into Databricks-managed storage (Delta tables).
Storage Costs: It violates your requirement to keep data out of Databricks storage.
* You create a new native catalog in Unity Catalog.
Note:
To expose the external SQL Server database in Unity Catalog without copying the data, you must use Lakehouse Federation.
Here are the step-by-step actions you need to take:
1. Create a Connection
Create a securable object in Unity Catalog that specifies the path and credentials to access the SQL Server database.
Go to Catalog Explorer or use SQL.
Select External Data > Connections.
Create a connection using the SQL Server connection details (URL, host, port, and database credentials).
*-> 2. Create a Foreign Catalog
Create a specific type of catalog in Unity Catalog that mirrors the external database.
Use the CREATE FOREIGN CATALOG SQL command or the Catalog Explorer UI.
Link this foreign catalog directly to the connection you created in step 1.
3. Query the DataOnce the foreign catalog is created, Unity Catalog automatically syncs the schemas and tables from SQL Server.


Reference:

https://docs.databricks.com/gcp/en/database-objects/



View Related Case Study

You have an Azure Databricks workspace that is enabled for Unity Catalog.
You need to share curated data with an external organization. The solution must meet the following requirements:
-The organization will use its own compute platform to query the data.
-Access to the data must be centrally governed by using Unity Catalog.
-Administrative effort must be minimized.
What should you do?

  1. Create a SQL warehouse for external users.
  2. Grant workspace access to external users.
  3. Create a pipeline to move the data to an SFTP server.
  4. Use Delta Sharing.
  5. Create a Lakeflow Connect pipeline.

Answer(s): D

Explanation:

You should use Delta Sharing to share the curated data.
Why Delta Sharing Meets All Requirements
Requirement 1 (Own Compute Platform): Delta Sharing is an open protocol. It allows the external organization to query data directly from their choice of compatible compute systems (such as Power BI, pandas, Apache Spark, or Starburst) using secure, short-lived URLs, without needing access to your Databricks workspace. Requirement 2 (Centrally Governed by Unity Catalog): Delta Sharing is natively integrated with Unity Catalog. You can create, manage, and audit all outward shares, recipients, and permissions directly within your centralized Unity Catalog metastore.
Requirement 3 (Minimized Administrative Effort): Because Delta Sharing provides direct access to the data files in-place, it eliminates the administrative overhead of setting up and maintaining data replication pipelines, SFTP servers, or external credentials.


Reference:

https://roysandip.medium.com/enable-unity-catalog-and-delta-sharing-for-your-databricks-workspace-a31e0af 6968



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure Databricks account that contains a single workspace named Workspace1. Workspace1 is enabled for Unity Catalog.
You discover that data access events for Unity Catalog tables fail to appear in the logs.
You need to ensure that all the data access events are captured centrally for auditing purposes. The log data must be available for analysis as quickly as possible.
What should you do?
To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Workspace1
Audit logging must be enabled at the workspace level.
Incorrect:
* individual Unity catalog tables
Unity Catalog does not support fine-grained audit log configurations on individual tables. Governance events are unified across all objects.
* The Databricks account
While Unity Catalog centralizes identities at the account level, Azure Monitor diagnostic settings map specifically to the Azure Databricks workspace resource in the Azure Portal. This configuration automatically captures all Unity Catalog metastore, catalog, schema, and table queries routed through that workspace.
Box 2: Azure Event Hub
To stream and analyze these events as quickly as possible, the logs should be sent to an Azure Event Hub.
To make data available for analysis as quickly as possible, streaming logs via Azure Event Hubs is the preferred choice for near real-time ingestion, routing, and SIEM tool integration.
Incorrect:
* Log Analytics
While Log Analytics is ideal for complex SQL-like dashboard querying, it introduces indexing and batching ingestion latency (ranging anywhere from 5 to 15+ minutes), which fails to meet the fastest delivery requirement.


Reference:

https://techcommunity.microsoft.com/blog/analyticsonazure/end-to-end-observability-for-azure-databricks-from -infrastructure-to-internal-ap/4475692



View Related Case Study

You have an Azure Databricks account that contains workspaces enabled for Unity Catalog.
You need to implement audit logging to meet the following requirements:
-Capture audit logs for all the workspaces in the account.
-Retain the audit logs for 90 days.
-Minimize storage and ingestion costs.
The logs will be reviewed only during security investigations and will NOT be queried regularly.
To where should you send the audit logs?

  1. Azure Event Hubs
  2. an Azure Storage account
  3. Log Analytics
  4. Azure Monitor metrics

Answer(s): B

Explanation:

The audit logs should be saved to an Azure Storage account (Azure Blob Storage or Azure Data Lake Storage Gen2) by configuring Account-level Audit Log Delivery in the Azure Databricks Account Console, using a storage lifecycle policy to enforce retention.
This approach fulfills all architecture requirements while maintaining the lowest possible total cost of ownership (TCO).


Reference:

https://learn.microsoft.com/en-us/answers/questions/5627530/subscription-activity-logs



View Related Case Study

DRAG DROP (Drag and Drop is not supported)
You have an Azure Databricks workspace named Workspace1.
You have a user named User1 that is a non-admin user for Workspace1.
You need to ensure that User1 can perform the following tasks:
-Provision clusters of any size.
-Run Databricks jobs.
The solution must follow the principle of least privilege.
What should you do?
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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Assign the Allow unrestricted cluster creation entitlement.
To allow a non-admin user to provision clusters of any size while maintaining the principle of least privilege, you should grant the user the "Allow unrestricted cluster creation" entitlement while leaving their workspace role as a standard User.
By default, non-admin users cannot create standard clusters unless explicitly granted specific entitlements or assigned to strict cluster policies. Assigning this specific entitlement satisfies the exact requirement without escalating the user's role to a Workspace Admin.
Box 2: Grant the CAN RUN permission for the jobs.
To allow a non-admin user to run Databricks jobs while adhering to the principle of least privilege, a workspace administrator must configure Object-Level Access Control List (ACL) permissions rather than granting administrative group memberships.
Required Configuration
The workspace administrator must grant the non-admin user specific Job Access Permissions on the targeted job(s):
*-> Can Manage Run: Grant this permission if the user only needs to trigger manual runs, skip tasks, or cancel active runs.
Can View: Grant this permission if the user only needs to see the job configurations and monitor previous run history or logs.


Reference:

https://learn.microsoft.com/en-us/azure/databricks/security/auth/entitlements https://learn.microsoft.com/en-us/azure/databricks/jobs/privileges



Viewing page 9 of 23
Viewing questions 41 - 45 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!