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

Questions 6–10

1. 6application · medium

   A data analyst needs to grant a colleague the ability to manage permissions on a specific table, but not grant them the ability to modify the data in the table. Which privilege should be granted?

   • AGRANT SELECT ON TABLE sales.raw_data TO `colleague`;
   • BGRANT ALL PRIVILEGES ON TABLE sales.raw_data TO `colleague`;
   • CGRANT MODIFY ON TABLE sales.raw_data TO `colleague`;
   • DGRANT MANAGE ON TABLE sales.raw_data TO `colleague`;
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data analyst needs to grant a team the ability to read and write to a table, but not to manage permissions on the table. Which privilege should be granted?

   • AGRANT SELECT, MODIFY ON TABLE sales.orders TO `team`;
   • BGRANT ALL PRIVILEGES ON TABLE sales.orders TO `team`;
   • CGRANT SELECT ON TABLE sales.orders TO `team`;
   • DGRANT MODIFY ON TABLE sales.orders TO `team`;
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company is migrating to Unity Catalog and has a legacy workspace with several tables that were shared using workspace-level ACLs. The security team requires that all access be governed by Unity Catalog. A data analyst needs to ensure that a specific table is only accessible to the 'finance' group. The analyst has been granted the OWNER privilege on the table. What is the correct sequence of actions?

   • AMake the finance group the owner of the table.
   • BRevoke all existing permissions on the table, then grant SELECT to the finance group.
   • CGrant SELECT to the finance group without revoking existing permissions.
   • DDrop the table and recreate it, then grant SELECT to the finance group.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company has a table that contains both US and EU customer data. The EU data is subject to GDPR, and only EU-based analysts should be able to access it. The US analysts should only see US data. What is the most efficient way to implement this requirement?

   • ACreate a view that filters rows based on a region column and grant SELECT on the view to the respective teams.
   • BUse a dynamic view with a CASE statement to mask EU data for US analysts.
   • CGrant SELECT on the table to both teams and rely on the analysts to filter the data themselves.
   • DCreate two separate tables, one for US data and one for EU data, and grant SELECT on each to the respective teams.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A company has a table that is shared with multiple teams. The data analyst needs to revoke access for one team, but the team is a member of a group that has SELECT on the table. The analyst wants to revoke access only for that team, not for other members of the group. What is the correct approach?

   • ARemove the team from the group and grant SELECT on the table to the team directly.
   • BCreate a new group for the team, remove them from the original group, and grant SELECT on the table to the new group.
   • CRevoke SELECT on the table from the team directly.
   • DRevoke SELECT on the table from the group.
   Reveal Solution Discussion Select an answer first