Use Unity Catalog Roles and Sharing Settings to Ensure Workspace Objects Are Secure. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A data analyst needs to share a table with an external partner. The partner does not have a Databricks account. What is the correct way to share the data?

   • AUse Delta Sharing to share the table with the partner.
   • BGrant the partner SELECT on the table in Unity Catalog.
   • CExport the table to a CSV file and email it to the partner.
   • DCreate a Databricks account for the partner and grant them access.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which action best ensures that workspace objects are secure when using Unity Catalog?

   • ADisable Unity Catalog and use workspace-level permissions
   • BGrant privileges to groups rather than individual users and use inheritance
   • CGrant all users the OWN privilege on all tables to simplify management
   • DGrant SELECT on all tables to all users for easier collaboration
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which statement best describes how sharing settings in Unity Catalog manage permissions for tables and views?

   • APermissions are stored in the cloud provider's IAM system
   • BPermissions are set individually on each object and do not inherit from parent objects
   • CPermissions are automatically granted to all users in the workspace
   • DPermissions are granted to users or groups and can be inherited from parent objects
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   An organization has a Unity Catalog metastore with a catalog named 'production'. The data engineering team needs to be able to create tables in this catalog, but should not be able to drop the catalog itself. Which privilege should be granted to the team?

   • AGRANT CREATE ON CATALOG production TO `data-eng`;
   • BMake the data engineering team the catalog owner.
   • CGRANT ALL PRIVILEGES ON CATALOG production TO `data-eng`;
   • DGRANT MODIFY ON CATALOG production TO `data-eng`;
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A data analyst needs to share a view with the sales team, but the view is based on a table that contains sensitive customer information. The analyst wants to ensure the sales team only sees a subset of columns. What is the most appropriate way to achieve this?

   • ACreate a new view that selects only the necessary columns and grant SELECT on that view to the sales team.
   • BGrant SELECT on the underlying table to the sales team.
   • CUse dynamic views with a CASE statement to mask the sensitive columns.
   • DGrant SELECT on the existing view to the sales team.
   Reveal Solution Discussion Select an answer first