You are developing a Snowflake Native Application that processes financial transactions. You want to implement a robust version management strategy. You have created versions 'v1_0', 'V1 _ 1', and 'v2 Version has a critical bug fix and needs to be prioritized for immediate deployment to specific consumer accounts that reported issues, while contains significant feature enhancements and is undergoing phased rollout. What is the most efficient and secure way to manage these releases in Snowflake?

• A. Option C
• B. Option E
• C. Option D
• D. Option A
• E. Option B

A Snowflake Native Application uses a task 'aggregate_data' to aggregate dat a. This task is owned by the 'app_public' role and executes a stored procedure 'aggregate data proc'. Consumers have reported the task sometimes fails intermittently, citing permission issues, specifically related to accessing a specific table in the consumer account. The application provider has granted 'SELECT' privilege on the table to the 'app_public' role. However, the failures persist. What is the MOST LIKELY cause of the intermittent failures related to executing the task?

• A. The stored procedure is executed with caller's rights (CALLER), and the 'EXECUTE TASK privilege wasn't granted correctly, which causes the user to randomly lose access on the Snowflake Ul.
• B. The task 'aggregate_data' is executing with definer's rights (OWNER) of the application, so the grant of SELECT privilege to 'app_public' is sufficient, and there is likely an issue with transient network connectivity.
• C. The stored procedure is executed with caller's rights (CALLER), but the application role 'app_public' doesn't have sufficient warehouse privileges in the consumer account.
• D. The stored procedure is executed with caller's rights (CALLER), but the application role 'app_public' doesn't have the ACTIVATION privilege on the task.
• E. The stored procedure is executed with definer's rights (OWNER), so the privilege check occurs against the application provider's account, not the consumer's account.

You are designing the 'privileges.sqr file for a Snowflake Native App. The app requires the ability to create and manage internal stages within the consumer's account to store temporary dat a. Which of the following SQL statements in 'privileges.sqr would correctly grant the necessary privileges to the application role (assuming the application role is named 'APP ROLE)?

• A.
  
• B.
  
• C.
  
• D.
  
• E.
  

You are developing a Snowflake Native Application that utilizes the 'APPLICATION ROLE' within a secure data sharing context. The application needs to perform different actions based on the role assigned to the user accessing the shared dat a. Consider the following code snippet in a stored procedure:

Which of the following modifications is necessary for the stored procedure to correctly utilize the 'APPLICATION ROLE and function as intended within the context of a Snowflake Native Application and a share?

• A.
  
• B.
  
• C.
  
• D.
  
• E. No modification is needed. The function will automatically return the active 'APPLICATION_ROLE' within the share.