You are designing a Snowflake Native Application that performs sentiment analysis on customer reviews. The application needs to store intermediate results and provide aggregated sentiment scores to the consumer. You are considering using either temporary tables or regular tables within your application package. Which of the following considerations are most important when deciding between these two options?

• A. Temporary tables are automatically dropped at the end of each session, ensuring that no sensitive data is persisted longer than necessary. This is crucial for maintaining data privacy and compliance.
• B. The data retention period for regular tables can be used to implement data versioning and auditing within the application package.
• C. Regular tables require specifying a data retention period, which adds complexity to the application's setup script and can potentially lead to data loss if not configured correctly.
• D. Temporary tables are visible to all roles within the application package, simplifying data access and management for different components of the application.
• E. Regular tables are persisted across sessions and can be queried by the consumer after the application has completed its processing. This allows the consumer to analyze the intermediate results and gain further insights.

Consider the following setup script snippet for a Snowflake Native Application:

What is the primary purpose of the 'WHERE NOT EXISTS' clause in the 'INSERT' statement within this setup script?

• A. To prevent duplicate rows with the same 'param_name' from being inserted into the 'app_data.configuration' table during subsequent installations or upgrades of the application.
• B. To guarantee that the 'app_data.configuration' table always contains the latest version of the 'api_endpoint' parameter, overwriting any existing value.
• C. To optimize the performance of the 'INSERT statement by avoiding unnecessary insertions when the configuration parameter already exists.
• D. To ensure that the 'INSERT statement only executes if the table is empty.
• E. To handle potential errors that may occur if the 'api_endpoint' parameter is already defined in the consumer's account.

You are developing a Snowflake Native Application that utilizes Streamlit for its user interface. The application needs to access data from a protected table within the provider account. To enhance security, you want to grant specific privileges to the Streamlit application without exposing the underlying table directly. Which of the following steps are necessary to achieve this, ensuring the principle of least privilege?

• A. Create a secure view on the protected table and grant 'SELECT privilege on the secure view to the Streamlit application's role.
• B. Create an API integration, implement a service (e.g., AWS Lambda) that queries the data and grant 'USAGE on the API Integration and appropriate permissions on the service to the Streamlit application's role.
• C. Create a stored procedure with 'EXECUTE AS CALLER which queries the protected table and grant 'USAGE privilege on the procedure to the Streamlit application's role.
• D. Use an external function (UDF) owned by the application to query the protected table and grant USAGE' privilege on the UDF to the Streamlit application's role.
• E. Grant 'SELECT privilege directly on the protected table to the Streamlit application's role.

Consider the following Snowflake Native Application design scenario: You are building a data enrichment application. This application requires a consumer to grant usage on a specific database in their account. The application will then use a user-defined function (UDF) to access and enrich the dat a. To minimize the risk of data exposure and adhere to best practices, which of the following approaches should you take when designing the UDF?

• A. Create the UDF with the EXTERNAL_ACCESS' keyword to explicitly allow it to access data outside of the application package.
• B. Create the UDF with the 'SECURE keyword and implement granular access control within the UDF code, restricting access based on the application role.
• C. Create the UDF without any special keywords, relying solely on the consumer's permissions to control data access.
• D. Create the UDF with the 'VOLATILE' keyword to ensure it only runs when explicitly called, limiting the potential for unintended data access.
• E. Create the UDF with the 'IMMUTABLE keyword to prevent any data modification within the consumer's database.

Consider the following Snowflake Native App manifest file (manifest.yml):

Which statements accurately describe the implications of this manifest file? (Choose two)

• A. The consumer must provide a value for the secret during application installation.
• B. The application code defined in setup.sql will run during the installation of the Application Package by the provider.
• C. The application can interact with external network resources.
• D. The application is not listed on the Snowflake Marketplace.
• E. Consumers can share data with the application without any limitations.