You are developing a Snowflake Native Application that manages customer dat a. You need to ensure that updates to customer records are idempotent. Your application uses a stored procedure 'update_customer(customer_id INT, new_email VARCHAR)' to update customer emails. How can you modify this procedure to guarantee idempotency, assuming that customer data changes are tracked with a 'last_updated' column of type TIMESTAMP NTZ?

• A. Add a 'COMMIT statement at the end of the stored procedure to ensure all changes are persisted immediately.
• B. Create a separate table to store only the changes to customer emails and query this table to determine the latest email.
• C. Implement optimistic locking using a version number for each customer record and checking the version before updating.
• D. Enclose the entire stored procedure within a 'TRY...CATCH' block and retry if any exception occurs.
• E. Use ' MERGE statement, comparing the new email with the existing email and updating only if they are different, while also ensuring that the update only happens if the new ' last_updated' timestamp is later than the stored one.

You are developing a Snowflake Native Application that processes sensitive customer dat a. You need to ensure that the application is secure and compliant with data privacy regulations. Which of the following security measures are MOST effective when designing your application package? (Select TWO)

• A. Use obfuscation techniques on the data within the application, making it harder to be read.
• B. Implement role-based access control (RBAC) to restrict access to sensitive data based on user roles within the application.
• C. Store all sensitive data in external stages managed by the provider account to isolate it from the consumer's Snowflake environment.
• D. Bypass Snowflake's RBAC and authentication to manage access within the application.
• E. Encrypt all data at rest and in transit using Snowflake's built-in encryption features.

A Snowflake Native App developer is creating a new application database. They need to ensure that only the application itself and designated roles within the provider account can access the database. Which of the following CREATE DATABASE statements would BEST achieve this, adhering to best practices for application isolation and security?

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

A Snowflake Native App developer is building an application package that contains multiple versions. They want to ensure that a consumer upgrading from version 1.0 to version 2.0 MUST execute a specific set of SQL scripts as part of the upgrade process to migrate existing application dat a. Which Snowflake Native App feature should they leverage to achieve this?

• A. A post-install script defined in the setup script.
• B. Snowflake Streams and Tasks to monitor the application version and trigger the migration scripts automatically.
• C. A version change handler defined within the application package.
• D. Snowflake Pipes to load and transform the existing data.
• E. Application Role-Based Access Control (RBAC)