Consider the following scenario: You're developing a Snowflake Native Application that requires both data loading and complex analytical queries. You plan to use separate warehouses to optimize performance and manage resources effectively. Given the requirements, which of the following warehouse configurations is the MOST appropriate?

• A. Two warehouses: one with 'AUTO SUSPEND = 60' for data loading and another with 'AUTO SUSPEND = 3600' for analytical queries.
• B. Two warehouses: one dedicated to data loading, configured with to save costs and other warehouse for analytical queries.
• C. One large warehouse to handle both data loading and analytical queries, sharing resources to minimize costs.
• D. One warehouse sized 'X-SMALL' for data loading and another sized URGE' for analytical queries.
• E. Two warehouses: one dedicated to data loading configured with "WAREHOUSE_SIZE = X-SMALL' and another for analytical queries configured with 'WAREHOUSE SIZE = LARGE and 'MAX CONCURRENCY LEVEL = 8'.

You've built a Snowflake Native Application and are ready to test it in test mode. The application utilizes both internal stages and external stages for data storage. Which of the following statements accurately describe the behavior of stages and data access during test mode installations from the provider's perspective?

• A. Data loaded into internal stages during test mode is automatically persisted to the consumer's account upon final installation of the application.
• B. External stages, regardless of their access permissions, are inaccessible during test mode installations to prevent unintended data leakage.
• C. Internal stages defined within the application package are accessible to the application code running in test mode. Data placed in these stages before installation is available immediately.
• D. During test mode, the provider has full access to all data stored in both internal and external stages associated with the application, mimicking the access rights in a production environment.
• E. The provider can configure specific external stages to be accessible in test mode by granting appropriate privileges to the application role and explicitly defining these stages in the setup script.

You have released version 1.0 of your Snowflake Native Application. After receiving feedback, you release version 1.1 with breaking changes to the data schema in the application's managed database. Some consumers haven't upgraded yet. How can you ensure that the older version continues to function correctly while allowing new consumers to use the updated schema?

• A. Create a compatibility layer within version 1.1 that detects the application version and adapts the data access logic accordingly. This would require use of the 'APPLICATION$VERSION' function.
• B. Maintain two separate application packages: one for version 1.0 and one for version 1.1. Version 1.1 includes logic to automatically migrate data for consumers who upgrade.
• C. Deprecate version 1.0 and provide a limited support window, after which it will be removed. All consumers will need to upgrade within the window.
• D. Force all consumers to upgrade to version 1.1 immediately, providing detailed migration instructions.
• E. Implement a data virtualization layer on the consumer's side, mapping the old schema to the new schema.

You are developing a Snowflake Native Application that requires fine-grained control over data access for its users. You plan to use Streamlit within the application and leverage the Permissions API to manage these privileges. Assume you have successfully established a connection to Snowflake within your Streamlit app. Which of the following code snippets accurately demonstrate how to grant the 'SELECT privilege on a table named 'APP DATA in the application's schema to a specific role, 'APP USER, using the Permissions API, and then verify if that privilege has been granted?

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