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

Questions 16–17

1. 16application · medium

   A data analyst needs to grant a user the ability to read a table, but only for the current date's data. The table is partitioned by date. What is the most efficient way to achieve this?

   • ACreate a new table with only the current date's data and grant SELECT on that table.
   • BGrant SELECT on the table to the user and rely on them to filter by date.
   • CUse a dynamic view with a CASE statement to mask data from other dates.
   • DCreate a view that filters on the current date and grant SELECT on the view to the user.
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A data analyst is troubleshooting why a user cannot query a table, even though the user has been granted SELECT on the table. The analyst checks the table's permissions and confirms the grant exists. What is the most likely cause of the issue?

   • AThe user is not a member of the workspace.
   • BThe user's SELECT grant is overridden by a more restrictive group membership.
   • CThe table is a view, and the user does not have access to the underlying table.
   • DThe user does not have access to the catalog or schema that contains the table.
   Reveal Solution Discussion Select an answer first