Valid NAS-C01 Dumps shared by EduDump.com for Helping Passing NAS-C01 Exam! EduDump.com now offer the newest NAS-C01 exam dumps, the EduDump.com NAS-C01 exam questions have been updated and answers have been corrected get the newest EduDump.com NAS-C01 dumps with Test Engine here:
Consider a Snowflake Native App that dynamically creates tables within the consumer's account using stored procedures. The application role is 'APP ROLE. After installation, the application needs to automatically grant 'SELECT privilege on all newly created tables in a specific schema CAPP DATA SCHEMA) to a consumer-defined role (CONSUMER ROLE). Which of the following approaches is the most secure and efficient way to achieve this? Assume the application cannot know the names of tables in advance.
Correct Answer: D
Future grants are designed for this purpose: to automatically grant privileges on objects created in the future. Options A and B are less efficient and scalable. Option C is overly permissive, granting ownership and the ability to grant further privileges, which is a security risk. Manual creation defeats the purpose of automation.