Free DP-750 Exam Braindumps
Implementing Data Engineering Solutions Using Azure Databricks Questions 15–19 (page: 8)

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

You have an Azure Databricks workspace named Workspace1 that contains a cluster named Cluster1.
You need to enable a user named User1 to install a Maven package on all the nodes of Cluster1. The solution must follow the principle of least privilege.
What should you do?

  1. Assign User1 the Contributor role for the resource group that contains Workspace1.
  2. Grant User1 the CAN RESTART permission for Cluster1.
  3. Grant User1 the CAN MANAGE permission for Cluster1.
  4. Assign User1 the workspace admins role for Workspace1.

Answer(s): C

Explanation:

To grant the user the ability to install a Maven package on all nodes of an existing cluster while keeping permissions as low as possible, you must assign the CAN MANAGE permission level on that specific cluster.
The permission structure in Azure Databricks requires specific access controls depending on the cluster's configuration:
For Dedicated / Single-User Clusters: Assign CAN MANAGE permissions to the target user for that specific cluster. This enables the user to attach compute-scoped libraries (such as Maven packages) without granting full Workspace Admin privileges.
For Shared Clusters (Unity Catalog enabled): In addition to assigning the CAN MANAGE cluster permission, the CAN ATTACH TO permission must also be active. Furthermore, the specific Maven coordinates must be added to the Unity Catalog allowlist by a Metastore Administrator to ensure the cluster can pull the dependency safely.


Reference:

https://dev.to/willvelida/managing-and-configuring-clusters-within-azure-databricks-16k5



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains:
-A catalog named Corpdb
-A schema named Finance in the Corpdb catalog
-A table named Sales in the Finance schema
You have a group named Analysts.
You assign permissions to Analysts as shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Yes
Yes, Analysts can query the Sales table.
In Azure Databricks Unity Catalog, object permissions are hierarchical. To query a specific table, a user or group must have the following minimum permissions at each level of the data hierarchy:
USE CATALOG on the parent catalog (Corpdb)
USE SCHEMA on the parent schema (Finance)
SELECT on the target table (Sales)
Because Analysts has been granted all three of these required privileges exactly as described, they possess the complete chain of permissions necessary to execute a SELECT query against the Sales table. If any single one of these privileges were missing—for example, if they had SELECT on the table but lacked USE CATALOG on the catalog—the query would fail with a permission denied error.
Box 2: No
No, Analysts cannot create a table in the Finance schema because they lack the required CREATE TABLE permission.
To create a new table inside a Unity Catalog schema, a principal (user or group) must have specific privilege layers:
USE CATALOG on the parent catalog (Corpdb) - Granted
USE SCHEMA on the parent schema (Finance) - Granted
CREATE TABLE on the parent schema (Finance) - Missing
The SELECT permission they currently hold only allows them to read data from the existing Sales table; it does not grant any administrative or data-definition privileges within the schema itself.
Box 3: No
No, this special group cannot create a schema in the Corpdb catalog.
To create a schema within a catalog in Unity Catalog, a group or user must possess the CREATE SCHEMA permission on that specific catalog.
Required Permissions for Schema Creation
CREATE SCHEMA: This privilege must be explicitly granted to the group on the Corpdb catalog.
USE CATALOG: This privilege is also required to interact with the catalog, which the group already has.


Reference:

https://interworks.com/blog/2026/05/04/understanding-databricks-governance-with-unity-catalog-layer-by-layer /



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure Databricks workspace that is attached to a Unity Catalog metastore named metastore1.metastore1 contains:
-A catalog named Sales
-A schema named Customers in the Sales catalog
-A table named Customer_details in the Customers schema
You need to ensure that a user named User1 can update the data in Customer_details. The solution must meet the following requirements:
-Ensure that User1 cannot create new tables.
-Follow the principle of least privilege.
Which permission should you grant to User1 for each object? 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: USE CATALOG
Catalog level
USE CATALOG and USE SCHEMA: These are traversal permissions. They allow the user to see and navigate to the assets but do not grant any rights to create new objects.
Box 2: USE SCHEMA
Schema level
See above.
Box 3: SELECT
Table level
SELECT and UPDATE: These allow the user to read the existing data and run UPDATE statements on that specific table.
No CREATE TABLE: Because you omit the CREATE TABLE privilege on the schema level, the user cannot create new tables.


Reference:

https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/hive-metastore



View Related Case Study

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a catalog named Catalog1. Catalog1 contains a table named Transactions. Transactions contains the following columns:
-transaction_id customer_name email_address credit_card_number transaction_amount
You need to ensure that business analysts can query all the rows in the Transactions table. The solution must meet the following requirements:
-Prevent the analysts from seeing the full values in the email_address and credit_card_number columns.
-Ensure that the analysts can see only the values after the @ character in each email address.
-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?

  1. Grant the analysts the SELECT permission for the Transactions table and apply column-level encryption.
  2. Grant the analysts the SELECT permission for columns that do NOT contain sensitive data.
  3. Grant the analysts the SELECT permission for the Transactions table and implement row-level filters.
  4. Grant the analysts the SELECT permission for the Transactions table and apply column masks to email_address and credit_card_number.

Answer(s): D

Explanation:

To protect sensitive customer information while allowing a specific group to run queries, use Unity Catalog's Dynamic Column Masking. This grants the group table access while applying User-Defined Functions (UDFs) to redact the email addresses and credit card numbers dynamically.
Here is the exact SQL implementation to apply:
1. Create the masking SQL UDFs
Define functions to apply the exact partial masking rules requested.
2. Apply the column masks to the tableAlter the transaction table to attach these UDFs to the respective columns.
3. Grant least privilege permissionsGrant the group the SELECT permission on the table, along with the foundational permissions to access the catalog and schema.


Reference:

https://docs.databricks.com/aws/en/data-governance/unity-catalog/filters-and-masks



View Related Case Study

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two catalogs named Catalog1 and Catalog2.
An external application uses a service principal named SP1 to connect to a SQL warehouse.
You need to ensure that SP1 can query the data in Catalog1 and Catalog2. The solution must follow the principle of least privilege.
Which permissions should you grant to SP1 for the catalogs?

  1. USE SCHEMA and SELECT
  2. USE CATALOG and SELECT
  3. USE CATALOG, USE SCHEMA, and SELECT
  4. USE CATALOG and USE SCHEMA

Answer(s): C

Explanation:

To ensure a service principal can query data in two specific catalogs while maintaining the principle of least privilege, you must assign the following permissions for each catalog:
Unified Catalog Permissions
USE CATALOG on the specific catalog: This is a prerequisite that allows the principal to see the catalog and its child objects.
USE SCHEMA on the schemas containing the data: This allows the principal to interact with the schemas within that catalog.
SELECT on the specific tables or views: This provides the actual read access required to query the data.


Reference:

https://learn.microsoft.com/en-us/purview/data-governance-roles-permissions



Viewing page 8 of 23
Viewing questions 36 - 40 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!