Module assessment

1.

What is the primary purpose of Unity Catalog during the query lifecycle?

To store all table data in a centralized location

To validate permissions and generate scoped temporary access tokens

To execute all queries on behalf of users

2.

Which permission is required to create a new table in a Unity Catalog schema?

CREATE TABLE on the catalog only

SELECT on the schema and CREATE TABLE on the catalog

USE CATALOG on the catalog, USE SCHEMA on the schema, and CREATE TABLE on the schema

3.

What is the primary advantage of Row and Column Security over Dynamic Views?

Row and Column Security can combine data from multiple tables

Row and Column Security minimizes object sprawl by enforcing security at the table level

Row and Column Security provides read-only access to data

4.

What happens when a secret stored in Azure Key Vault is updated?

All Azure Databricks clusters automatically pick up the new value immediately

The secret scope in Azure Databricks must be recreated to access the new value

Clusters must be restarted to fetch the updated secret value

5.

Why does Microsoft recommend managed identities over service principals for Unity Catalog storage credentials?

Managed identities are less expensive than service principals

Managed identities eliminate the need to manage and rotate secrets and can access network-protected storage

Managed identities provide faster data access than service principals

6.

Which Azure role should be assigned to a managed identity to enable Unity Catalog to read and write data in Azure Data Lake Storage?

Reader

Storage Blob Data Contributor

Contributor

Check your knowledge