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), but the application role 'app_public' doesn't have the ACTIVATION privilege on the task.
• B. 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.
• C. 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.
• D. 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.
• 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're developing a Snowflake Native App. Part of your application logic involves using a UDF (User-Defined Function) to perform complex calculations on data residing in a table within the consumer's Snowflake account. Which of the following statements correctly describes how you would package and deploy this UDF within your Native App using the application package?

• A. You must create the UDF within a schema in your application package, and grant USAGE privilege on the schema to the application role. The application code can then execute the UDF without any further privilege grants within the consumer account, and the UDF can be called from SQL or other UDFs using unqualified names.
• B. You must create the UDF within a schema in your application package. No additional privileges need to be granted, as the application role automatically has all necessary privileges within the application's namespace.
• C. The UDF definition must be created as an external function, pointing to an external API endpoint that your application controls, enabling the UDF logic to be executed outside of the consumer's Snowflake environment.
• D. You must create the UDF within a schema in your application package, and grant USAGE privilege on the schema to the application role. The consumer will automatically be granted EXECUTE privilege on the UDF.
• E. The UDF definition must be created directly within the consumer's account after the application is installed, as UDFs cannot be included in the application package.

A Native Application provider wants to grant the 'SELECT privilege on a view, 'CUSTOMER DATA, in a shared database 'SALES DATA DB' to consumers installing their application. The provider also wants to ensure that future views created in 'SALES DATA DB' are automatically accessible to the application. Which of the following SQL statements, executed by the provider, achieves this with the LEAST amount of privilege escalation risk?

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

A provider has released a Snowflake Native Application that calculates risk scores. As a consumer, you've installed the application. However, you are seeing inconsistent results when querying a view provided by the application named 'RISK SCORES'. You suspect the provider has an issue with their data or logic. Which of the following actions are MOST appropriate to troubleshoot this from the consumer side, focusing on querying and without access to the provider's source code?

• A. Raise a support ticket with the provider through the Snowflake Marketplace. Include example queries, input data, and the expected vs. actual results to facilitate their debugging process. Further, Query data using different warehouse sizes to see if concurrency is a factor.
• B. Utilize the 'DEBUG' procedure exposed by the application (if any) to step through the risk calculation logic with specific input values.
• C. Contact Snowflake Support and provide them with a detailed description of the issue and relevant query examples. Snowflake Support can access the provider's environment and investigate.
• D. Use on the provider's account to establish a secure connection and directly debug the provider's stored procedures.
• E. Examine the 'INSTALLATION INFORMATION' view in the application's database to check for provider-published error messages or status updates related to data quality issues. Use queries to identify patterns in the inconsistent results.

A Snowflake Native App developer wants to externalize certain configuration values so that a consumer can adjust the app's behavior without modifying the app's code directly. Which of the following methods is the MOST appropriate for achieving this using the Snowflake Native App Framework?

• A. Storing the configuration values in a separate Snowflake table within the consumer account.
• B. Defining parameters in the manifest file and using them within the application code.
• C. Using dynamic SQL to modify the application code at runtime based on environment variables.
• D. Using Snowflake variables and setting them at the session level.
• E. Hardcoding the configuration values directly into the SQL code.