A Snowflake Native Application developer wants to ensure that a specific stored procedure, 'UPDATE CUSTOMER STATUS, within their application can only be executed by users who have been granted the 'CUSTOMER ADMIN' role in the consumer's account. How can the developer enforce this authorization check within the stored procedure's code?

• A. Use the 'CURRENT ROLE()' function within the stored procedure to check if the current role is 'CUSTOMER ADMIN'. If not, raise an error.
• B. Use the function within the stored procedure to verify that the 'CUSTOMER_ADMIN' role is currently active in the session. If not, raise an error.
• C. Implement a custom function that calls 'SYSTEM$GET PRIVILEGES()' and checks if the user executing the stored procedure possesses the 'CUSTOMER ADMIN' role.
• D. Grant the 'EXECUTE privilege on the stored procedure only to the 'CUSTOMER_ADMIN' role in the consumer's account.
• E. Utilize the 'SESSION CONTEXT()' function to check for a specific context variable set only when a user with the 'CUSTOMER ADMIN' role is connected.

A Native App provider has released a new version of their application. After installation, some consumers report encountering 'SQL compilation errors' when using certain features that rely on Java UDFs. The provider has thoroughly tested the application and cannot reproduce the error in their development environment. What are the MOST LIKELY causes of this issue and how can the provider systematically troubleshoot and resolve it? (Select TWO)

• A. The Java UDFs are encountering data type mismatches due to differences in regional settings or data formats between the provider's and consumer's environments. The provider should enforce strict data validation and type conversion within the UDFs.
• B. The Java UDFs are using external libraries that are not compatible with the consumer's Snowflake environment or are missing entirely. The provider should explicitly declare all dependencies in the application manifest and ensure they are properly packaged and deployed.
• C. The provider's development environment is using a newer version of the Snowflake Java runtime than the consumer's environment. The provider should downgrade their development environment to match the oldest supported version and re-test the application.
• D. Consumer-side firewall rules are blocking access to external resources used by the Java UDF. The provider should thoroughly document the necessary network configurations for consumers.
• E. The consumer's Snowflake account has insufficient compute resources to execute the Java UDFs. The provider should instruct the consumer to upgrade their virtual warehouse size.

As a Native App Provider, you've identified a performance bottleneck in a query against a table within your application's container due to an inefficient join. The query is part of a view exposed to consumers. Which of the following actions would be MOST effective in improving the query performance while minimizing disruption to consumers?

• A. Implement a scheduled task to regularly update the statistics of the table involved in the join. This will help the query optimizer make better decisions, and consumers will see improved performance gradually.
• B. Create a search optimization policy on columns used in the 'WHERE' clause in the view. This does not require any changes from the consumers.
• C. Create a materialized view in place of the existing view, pre-computing the join results. This will require consumers to update their queries to use the new materialized view name.
• D. Rewrite the query in the view definition to use a more efficient join algorithm (e.g., using hints). Consumers will automatically benefit from the improved performance.
• E. Add a 'CLUSTER BY clause to the underlying table based on the join keys. Consumers will automatically benefit from improved query performance without any changes on their end.

A consumer installs a Snowflake Native Application from the Marketplace. The application requires access to a specific table, 'CUSTOMER DATA' , in the consumer's account. Which of the following steps are essential for the consumer to properly grant the application the necessary permissions, following least privilege principles, and ensuring the application functions as intended? Assume the application developer has properly requested the table grant in the setup script.

• A. Grant 'OWNERSHIP' on the "CUSTOMER_DATR table to the application role. This provides the application with complete control over the table.
• B. Grant the 'SELECT privilege directly on the 'CUSTOMER_DATA' table to the 'SNOWFLAKE.APP_ROLE' role associated with the application instance.
• C. Create a share from the provider account granting access to the 'CUSTOMER DATA' table and import it into the consumer account.
• D. Grant the 'USAGE privilege on the database and schema containing 'CUSTOMER_DATA' to the application role and then grant 'SELECT on the 'CUSTOMER DATA table to the application role.
• E. Grant the 'IMPORTED PRIVILEGES privilege on the database containing 'CUSTOMER_DATX to the application role created during installation.