A data science team within your organization is developing a Snowflake Native App that needs to access and process customer data stored in a Snowflake database. The app must only access data for customers residing in the 'USA' region. The team has created a custom role 'APP ROLE for the app to use. Which of the following is the MOST secure and efficient way to grant the app the necessary permissions to read the filtered data? Assume a secure view approach is preferred over direct table access.
Correct Answer: B
Secure views offer a crucial security advantage: they hide the underlying table structure and any associated metadata from the app, only exposing the filtered data. Row-level security (RLS) can work (A), but secure views provide an extra layer of abstraction and security, hiding the existence of other rows. Granting ownership (C) is highly insecure and unnecessary. Non-secure views (D) do not offer the security benefits required for sensitive data. USAGE privilege alone (E) doesn't grant any data access without SELECT.