You are developing a Snowflake Native Application that uses a custom Python handler to perform data transformations. This handler requires access to a third-party Python package not included in the standard Anaconda environment provided by Snowflake. To ensure the application functions correctly on consumer accounts, what steps must you take? (Select all that apply)

• A. Specify the Python package as a dependency in the application's setup script using a install command.
• B. Include the required Python package in the application package as a zip file using the 'CREATE or REPLACE FUNCTION' command with the 'imports' clause.
• C. Create a stage and upload the python package(s). Then in the Python UDF code, reference the python package from the stage.
• D. Use the SALTER FUNCTION' command after installation on the consumer's account to add the required Python package to the function definition. This option is not possible.
• E. Instruct consumers to manually install the necessary Python package using 'pip install' in a Snowflake Snowpark Python worksheet after installing the application.

When designing the architecture of a Snowflake Native App, which of the following architectural considerations and trade-offs should you carefully evaluate to optimize performance, security, and cost-effectiveness? (Select all that apply)

• A. Storing all application data within the provider account and accessing it directly from the consumer account using data sharing to avoid data duplication.
• B. Using secured API integration to call the external APIs to get real time details in the app to make the app more useful.
• C. Minimizing data transfer between the provider and consumer accounts by leveraging Snowpark and UDFs for data processing within the consumer's environment.
• D. Choosing the appropriate data access model (e.g., UDFs, stored procedures, Snowpark) based on the specific use case and performance requirements, considering the overhead associated with each approach.
• E. Implementing robust error handling and logging mechanisms to facilitate debugging and monitoring of the application's behavior in both the provider and consumer environments.

A Snowflake Native Application provider is deploying their application in multiple regions (AWS US-East-l and AWS EU-Central-l). The application relies on external functions that interact with a third-party API. The provider wants to optimize for both latency and cost while ensuring high availability. Which of the following strategies represents the MOST effective approach for configuring and deploying these external functions to meet these requirements? Select two.

• A. Host the external function code directly within the Snowflake application package and leverage Snowflake's serverless compute to execute the function logic without relying on external APIs.
• B. Utilize Snowflake's cross-region replication feature to automatically replicate the external functions between regions. This ensures that the functions are always available in both regions.
• C. Create a single external function that uses a conditional statement to route requests to different API endpoints based on the Snowflake region where the function is being called. This approach reduces management overhead.
• D. Deploy separate external functions in each region, pointing to API endpoints hosted in the respective regions. Configure each external function with the same security integration to simplify access management.
• E. Configure a global load balancer in front of the third-party API endpoints and point all external functions to the load balancer's endpoint. This allows the load balancer to route requests to the closest available API endpoint.

A Snowflake Native App provider wants to ensure that even future roles created in their provider account will NOT automatically have access to the application database , which was created without the "MANAGED ACCESS' property initially. After creating a security audit suggested it to be with managed access. Which of the following steps BEST secures the app database?
Note multiple options may be needed

• A. REVOKE ALL PRIVILEGES ON DATABASE FROM PUBLIC;
• B. ALTER DATABASE SET MANAGED ACCESS = TRUE;
• C. GRANT OWNERSHIP ON DATABASE TO ROLE application_role;
• D. DROP DATABASE CREATE DATABASE WITH MANAGED ACCESS;
• E. REVOKE USAGE ON DATABASE FROM ROLE PUBLIC;

You are developing a Snowflake Native Application that uses Streamlit to present dat a. The application relies on a UDF to perform calculations. The UDF resides in the application's schema within the container. The application package is named and the application itself is named 'my_app'. You need to grant the application the necessary privileges to execute this UDF. Which of the following SQL statements, executed by the application provider, will correctly grant the required privilege to the application?

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