A consumer installs a Snowflake Native App that performs data transformations. The consumer wants to monitor the resource consumption (e.g., credits used) of the application. Which of the following SQL queries can the consumer use to retrieve the warehouse- level credit usage information associated with the installed application 'my_app'?

• A. SELECT start_time, end_time, warehouse_name, credits_used FROM snowflake.account_usage.warehouse_metering_history WHERE application_name = 'my_app';
• B. SELECT start_time, end_time, warehouse_name, credits_used FROM snowflake.account_usage.metering_history WHERE application_name = 'my_app';
• C. SELECT start_time, end_time, warehouse_name, credits_used FROM snowflake.account_usage.resource_monitors WHERE application_name = 'my_app';
• D. SELECT start_time, end_time, warehouse_name, credits_used FROM snowflake.account_usage.database_storage_usage_history WHERE application_name = 'my_app';
• E. SELECT start_time, end_time, warehouse_name, credits_used FROM snowflake.account_usage.query_history WHERE application_name = 'my_app';

You are designing a Snowflake Native Application that allows consumer accounts to customize certain aspects of its behavior. Specifically, the application needs to support consumer-defined thresholds for alerting, stored as parameters. You want to allow consumers to set these thresholds through the 'ALTER APPLICATION' command. How can you achieve this MOST effectively while ensuring that these parameters are securely managed and accessible within your application code?

• A. Use 'ALTER APPLICATION' to modify session variables, which are then accessible within the application code via 'SYSTEM$GET_VARIABLE'.
• B. Define parameters within the application manifest (manifest.yml) with mutable set to True. Use the SYSTEM$GET PARAMETER function within your application logic to retrieve these consumer-configurable values.
• C. Define parameters within the application manifest (manifest.yml) with mutable set to True. Use the APPLICATION PARAMETER function within your application logic to retrieve these consumer-configurable values.
• D. Define parameters using the 'USING' clause during application deployment in the provider account. Then, use 'ALTER APPLICATION' to modify these parameters in the consumer account.
• E. Use 'ALTER APPLICATION' to directly modify values within a consumer-managed table, reading values from that table in your stored procedures.

A data provider is building a Snowflake Native Application that provides real-time stock market data through a Snowflake Marketplace listing. They have implemented a secure data sharing mechanism. To update the data in the listing with minimal downtime and ensure continuous availability for their consumers, which strategy should they employ?

• A. Create a new version of the Snowflake Native Application containing the updated data and deprecate the previous version. Consumers will need to migrate to the new version.
• B. Completely replace the underlying shared database with a new version during off-peak hours.
• C. Use tasks and streams to incrementally refresh the data in the shared database. Implement error handling to manage potential data inconsistencies.
• D. Utilize Snowflake's cloning feature to create a duplicate of the shared database, update the data in the clone, and then swap the original and cloned databases using 'ALTER DATABASE SWAP WITH'.
• E. Perform direct updates to the tables within the shared database. Use SALTER TABLE ... SWITCH WITH' to minimize locking during the update process, creating new tables with updated data.

You are packaging a Snowflake Native App that includes a Streamlit application. You need to define specific permissions for the application to access data in the consumer's account. Specifically, the application needs to read from a table named in the schema within the consumer's database 'consumer_db'. Which of the following steps are required to correctly grant these privileges during the application installation process?

• A. In your setup script ('setup.sql'), execute 'GRANT SELECT ON TABLE consumer_db.consumer_schema.consumer_data TO APPLICATION ROLE app_role;' where 'app_role' is the application role defined in your application package.
• B. In your manifest file ('manifest.yml'), declare a 'privileges' section specifying 'SELECT' privilege on 'consumer_db.consumer_schema.consumer_data' for the app_role' .
• C. The consumer must manually grant the 'SELECT privilege on 'consumer_db.consumer_schema.consumer_data' to the application's install-time role after the application is installed. No action is needed within the application package.
• D. Create a secure view in the consumer's account that selects from and grant 'SELECT on the secure view to the application role. This requires coordination with the consumer.
• E. Use the 'snowflake.permissionss module within your Streamlit application to dynamically request the 'SELECT privilege on 'consumer_db.consumer_schema.consumer_data' when the application starts. Display an error message if the privilege is not granted.