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

Questions 21–25

1. 21foundation · easy

   Which SQL command is used to grant the SELECT privilege on a table to a group in Unity Catalog?

   • AGRANT SELECT ON TABLE sales.orders TO GROUP analysts;
   • BASSIGN SELECT ON TABLE sales.orders TO GROUP analysts;
   • CALLOW SELECT ON TABLE sales.orders TO GROUP analysts;
   • DPERMIT SELECT ON TABLE sales.orders TO GROUP analysts;
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   Your organization has a Unity Catalog metastore and uses Azure Databricks for ETL. You need to run a job that reads from an external storage account using a service principal. The service principal's credentials are stored in Azure Key Vault. What is the recommended way to configure the job?

   • AMount the storage account using the service principal and store the mount credentials in a cluster-scoped environment variable.
   • BStore the service principal's client secret in a Databricks-backed secret scope and use it in the notebook.
   • CCreate a Key Vault-backed secret scope, store the service principal's client secret, and configure the job to use the service principal with the secret retrieved from the scope.
   • DUse the service principal's managed identity to authenticate to storage and store the identity's client ID in a secret scope.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which Databricks utility is used to retrieve secrets from a secret scope in a notebook?

   • Adbutils.secrets.get()
   • Bdbutils.fs.ls()
   • Cdbutils.notebook.run()
   • Ddbutils.widgets.get()
   Reveal Solution Discussion Select an answer first
5. 24expert · hard

   A company uses Azure Databricks for automated data processing. They have a service principal that runs jobs. The service principal needs to access a Unity Catalog table and an Azure Key Vault secret. The service principal has been added to the workspace and granted `SELECT` on the table and `Get` on the secret. However, the job fails with a permission error when trying to access the secret. What is the most likely cause?

   • AThe service principal has not been granted `USAGE` on the schema.
   • BThe service principal's client secret has expired.
   • CThe service principal has not been granted `List` on the Key Vault.
   • DThe Databricks secret scope is not configured to use the service principal's identity.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   In Unity Catalog, how can you restrict access to specific columns of a table?

   • ABy using the GRANT COLUMN statement on the table.
   • BBy applying a row filter to the table.
   • CBy setting a column-level permission property on the table.
   • DBy creating a view that selects only the allowed columns and granting access to that view.
   Reveal Solution Discussion Select an answer first