A consumer reports that your Snowflake Native Application is consistently failing with an 'Insufficient privileges' error when attempting to execute a specific function. As the provider, you need to diagnose the issue. Which of the following steps should you perform FIRST, considering the principles of least privilege and secure data access in Snowflake Native Apps?

• A. Grant the 'USAGE privilege on the entire application package to the consumer's account, ensuring they have access to all components.
• B. Examine the function's definition and the objects it accesses to ensure that the necessary privileges are granted to the application's invoker's rights (IR) role or owner's rights (OR) role, and that a data access framework is in place when needed.
• C. Request the consumer to grant 'OWNERSHIP of the target database to your application's service user.
• D. Temporarily disable all security policies (e.g., row access policies, masking policies) in the consumer's account to isolate the problem.
• E. Grant the "APPLY MASKING POLICY privilege on the database to the application invoker role.

You are developing a Snowflake Native Application designed to audit user activity within a consumer's Snowflake account. Your application needs to store audit logs persistently and efficiently. You anticipate high write volumes and require the ability to query these logs effectively for compliance purposes. Which of the following strategies is the MOST appropriate for storing and managing audit logs within your native application?

• A. Store audit logs as JSON files in a variant column within a Snowflake table.
• B. Store audit logs directly in a Snowflake table, leveraging clustering keys and partitioning for efficient querying and maintenance.
• C. Write audit logs to a Snowflake queue. Configure a Snowpipe to load the data continuously into a Snowflake table.
• D. Send audit logs to a third-party logging service via external functions. Maintain a summary table within Snowflake containing aggregated audit data.
• E. Store audit logs in an external stage, leveraging cloud storage. Implement periodic data loading from the stage into a Snowflake table for querying.

You are developing a Snowflake Native App that requires uploading multiple large data files (each > 50MB) to a stage for processing. Due to network limitations, you need to optimize the upload process. You have already created the stage and have necessary privileges. Which of the following approaches would be most effective for uploading the files efficiently?

• A. Write a Python script leveraging the Snowflake Connector for Python to upload the files using multi-threading or asynchronous operations.
• B. Use the Snowflake Visual Studio Code (VS Code) extension's built-in file upload feature, which automatically handles parallel uploads.
• C. Compress the files into a single ZIP archive before uploading using the 'PUT' command.
  
• D. Use the 'PUT ' command with the 'PARALLEL' option enabled in SnowSQL.
  
• E. Utilize Snowflake's internal staging using 'PUT command on Internal stage for smaller file and external stage for larger file and then copy the larger file from external to internal by referencing file URL.

A Snowflake Native App is designed to perform complex data transformations on large datasets provided by the consumer. To optimize performance and manage resource consumption, you need to choose the appropriate execution context for your application logic. Which of the following options should be considered to accomplish this?

• A. Using a combination of stored procedures, SQL UDFs, and external functions to orchestrate the data transformation process, depending on the specific requirements of each step.
• B. Run entire process by calling API from provider side.
• C. Leveraging Snowflake's external functions to offload data transformations to a separate cloud-based compute environment.
• D. Executing all data transformations within a single stored procedure to minimize overhead.
• E. Distributing the transformations across multiple SQL UDFs running in parallel using Snowflake's compute grid.

You are packaging a Snowflake Native Application for distribution. You need to include a Python User-Defined Function (UDF) that reads data from a stage. Which of the following steps are REQUIRED to ensure the UDF functions correctly after installation in a consumer's account? (Choose two)

• A. Include the Python code for the UDF inline within the 'CREATE FUNCTION' statement, instead of referencing an external stage.
• B. Ensure the stage containing the Python file is explicitly referenced with 'OWNER' rights in the application manifest file.
• C. Grant on the stage and 'USAGE' on the database and schema containing the stage to the 'SNOWFLAKCORE.BUILTIN APP API' schema in the provider account before building the application package.
• D. Explicitly grant 'USAGE privilege on the stage to each role within the application that will execute the UDF in the 'setup.sqr script.
• E. Grant the 'READ privilege on the stage to the schema in the provider account before building the application package.