You are configuring a Databricks job that uses a service principal to access an Azure SQL database. The SQL authentication password is stored in Azure Key Vault. You want to retrieve the password at runtime without exposing it in the notebook. What should you do?

Create a Key Vault-backed secret scope, store the password as a secret, and use `dbutils.secrets.get` in the notebook to retrieve it.

Mount the SQL database using the service principal and reference the mount path in the notebook.

Use the service principal's client secret as the SQL password and store it in a Databricks-backed secret scope.

Store the password in a notebook variable and pass it to the JDBC connection string.

How can an Azure Databricks notebook securely access a secret stored in Azure Key Vault?

By using a secret scope that references the Azure Key Vault and the dbutils.secrets.get() function.

By directly querying the Key Vault REST API from the notebook without any configuration.

By storing the secret in a notebook cell and referencing it as a variable.

By using the Azure CLI within the notebook to retrieve the secret.

What is the primary purpose of table-level access control in Unity Catalog?

To encrypt data at rest for all tables in the metastore.

To restrict access to specific rows based on user attributes.

To restrict access to specific columns within a table.

To restrict which users can read or modify entire tables within a schema or catalog.

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 2Objective 1

Secure Unity Catalog Objects DP-750 Practice Questions (Page 2)

Part of the Secure and govern Unity Catalog objects domain, which accounts for 15–20% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~8–16 in this domain), expect 4–8 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

7concepts

15–20%of the exam

Questions 6–10

6application · medium
You are configuring a Databricks job that uses a service principal to access an Azure SQL database. The SQL authentication password is stored in Azure Key Vault. You want to retrieve the password at runtime without exposing it in the notebook. What should you do?
Select an answer first
7foundation · easy
Which object in Unity Catalog is commonly used to implement column-level access control?
Select an answer first
8foundation · easy
How can an Azure Databricks notebook securely access a secret stored in Azure Key Vault?
Select an answer first
9foundation · easy
What is the primary purpose of table-level access control in Unity Catalog?
Select an answer first
10foundation · easy
Which Unity Catalog feature allows you to apply a filter to a table so that users only see rows matching a condition?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-750” is a trademark of its owner, used for identification only.

Secure Unity Catalog Objects DP-750 Practice Questions (Page 2)

Questions 6–10

You are configuring a Databricks job that uses a service principal to access an Azure SQL database. The SQL authentication password is stored in Azure Key Vault. You want to retrieve the password at runtime without exposing it in the notebook. What should you do?

Which object in Unity Catalog is commonly used to implement column-level access control?

How can an Azure Databricks notebook securely access a secret stored in Azure Key Vault?

What is the primary purpose of table-level access control in Unity Catalog?

Which Unity Catalog feature allows you to apply a filter to a table so that users only see rows matching a condition?

Keep studying — Secure and govern Unity Catalog objects