You're developing a Snowflake Native Application that performs complex data transformations within the consumer's account. These transformations require substantial compute resources. You want to optimize resource utilization and minimize cost for your consumers.
Which strategies can you employ to achieve this goal? (Select TWO)

• A. Implement dynamic scaling by programmatically adjusting the virtual warehouse size based on the workload using stored procedures and the function to cancel long running and inefficient tasks.
• B. Implement data skipping techniques to minimize the amount of data scanned during transformations. This involves clustering tables appropriately.
• C. Utilize Snowflake's auto-suspend and auto-resume features for virtual warehouses to minimize compute costs when the application is idle.
• D. Do not use transactions for data transformation pipelines as transactions introduce overhead.
• E. Force consumers to use the largest possible virtual warehouse size to ensure transformations complete quickly.

You are designing a setup script for a Snowflake Native Application. This script needs to perform the following actions: 1. Create a secure view that exposes a subset of data from a table owned by the provider account. 2. Grant 'SELECT privilege on this secure view to a specific role within the consumer account, but ONLY if that role already exists in the consumer account. 3. Create a UDF in the provider account which calls external function. This UDF needs access to a secret stored in a Snowflake secret object. Which of the following code snippets BEST implements these requirements, ensuring both security and proper privilege management?

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

You are designing a Snowflake Native App that includes a managed task. This managed task updates several tables in a secured schema within the consumer account. To comply with strict security requirements, you need to minimize the privileges granted to the application role while ensuring the managed task executes successfully. Which combination of privileges is absolutely necessary for the application role to successfully execute the managed task and update the tables in the secured schema, assuming the application role already has USAGE on the database and schema?

• A. EXECUTE MANAGED TASK, OWNERSHIP on the secured schema.
• B. EXECUTE MANAGED TASK, OWNERSHIP on the tables.
• C. EXECUTE MANAGED TASK, MODIFY on the secured schema.
• D. EXECUTE MANAGED TASK, SELECT, INSERT, UPDATE, DELETE on the tables AND MODIFY on the schema.
• E. EXECUTE MANAGED TASK, SELECT, INSERT, UPDATE, DELETE on the tables.

You are developing a Snowflake Native Application. As part of your application deployment process, you need to programmatically register a new version of your application package and promote it through the stages (e.g., 'dev', 'test', 'prod'). You are using the 'SYSTEM$REGISTER_APPLICATION_PACKAGE_VERSION' function. Which of the following statements accurately describe valid arguments and usage considerations for this function?

• A. The 'VERSION' argument is a display name for the version and doesn't impact version ordering or compatibility checks during installation.
• B. The 'EXTERNAL ID' must be a globally unique identifier for each version across all Snowflake accounts. If The it's not unique, the registration will fail.
• C. The 'SOURCE_PACKAGE must be an application package in the same account as the one where the new version is being registered.
• D. The PATCH' argument is required, it should be incremented for minor bug fixes or security updates within the same VERSION.
• E. The 'SOURCE_PACKAGE argument is optional, and if omitted, the function will automatically generate a new application package based on the current

A data analytics company, 'Data Insights Pro', is developing a Snowflake Native Application to provide advanced customer segmentation analysis. They plan to monetize this application through the Snowflake Marketplace. They want to ensure that only a specific set of customer accounts can access and install their application during the initial beta testing phase. Which of the following steps must they perform to achieve this?

• A. Create a public listing with a very high price to deter unintended installations, then manually adjust the price to zero for beta testers.
• B. Create a private listing on the Snowflake Marketplace and share it with the specific customer accounts by explicitly granting access to their Snowflake account identifiers.
• C. Create a public listing on the Snowflake Marketplace and rely on Snowflake's built-in usage monitoring to identify the intended customer accounts.
• D. Publish the application directly to the Snowflake Marketplace without creating a listing, and then share the installation URL with the selected customer accounts.
• E. Use Snowflake's data sharing feature to share the application package with the customer accounts.