Certified Data Analyst AssociateDemo

By Databricks · Question Mode

QuestionQ123

Securing Data

A data analyst must share a certified dataset of approved public economic indicators with an external research institution. The institution has no access to the Databricks workspace. The dataset is governed in Unity Catalog and has already been appropriately reviewed and tagged.

The analyst requires:

  • Secure, read-only sharing of the dataset
  • The institution to receive only the specified tables
  • No access to the entire catalog or workspace
  • Continued auditability and governance through Unity Catalog

How should the analyst share the dataset?

  • A Grant the external users access to Unity Catalog by adding their emails to the workspace.
  • B Use COPY INTO to export the dataset into a managed Delta table, then use Unity Catalog’s GRANT SELECT to provide access to the institution.
  • C Use the GRANT SELECT command to give the external group’s principal access to the table.
  • D Create a Delta Share, add the required table, define a recipient, and ensure that a Unity Catalog metastore admin or privileged user in the recipient’s workspace grants appropriate access permissions to their users.
Explanation

Delta Sharing lets a Unity Catalog provider create a share containing only the intended tables and grant that share to a recipient, giving the external organization read-only access without workspace or full-catalog access. Unity Catalog governs the share and records sharing activity, while a privileged user in the recipient environment manages access for that organization’s users.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!