You are developing a Native App on Snowflake that collects usage data from consumer accounts. You need to store this data securely and efficiently, and you anticipate that the volume of data will grow rapidly. Which of the following strategies would you consider to OPTIMIZE storage and query performance for this usage data within the application?

• A. Implement a data retention policy to automatically purge older usage data that is no longer needed.
• B. Use clustering keys on columns commonly used in queries, such as timestamp and consumer account ID. Consider data compression options if available.
• C. Create separate tables for each consumer account to store their usage data.
• D. Store all usage data in a single table and rely on Snowflake's automatic clustering to handle performance.
• E. Partition the usage data table by consumer account ID to isolate data from different consumers.

You are developing a Snowflake Native Application for a financial institution that needs to be deployed across multiple cloud providers (AWS, Azure, GCP) to minimize latency for their global customer base. The application relies on a secure and consistent method for accessing external services for real-time market dat a. Which of the following strategies would BEST ensure cross-cloud functionality and adherence to Snowflake Marketplace best practices for secure data access?

• A. Create separate versions of the Native Application for each cloud provider, each with customized configurations for accessing the external services. Publish each version separately on the Snowflake Marketplace.
• B. Package the external service client libraries directly within the Native Application and configure the application to dynamically discover the nearest available endpoint at runtime, storing credentials within a Snowflake secret.
• C. Use Snowflake's Network Rules feature in conjunction with external functions that leverage API integration objects, storing the secret material necessary to authenticate with the external API. Leverage Snowflake's built-in cross-cloud replication capabilities to ensure data consistency.
• D. Use Snowflake's external functions with secure OAuth authentication to access the external services, leveraging Snowflake's built-in cross-cloud replication capabilities to ensure data consistency.
• E. Hardcode cloud-specific endpoint URLs for the external services in your application code, using conditional statements to determine the correct endpoint based on the Snowflake cloud region.

You are developing a Snowflake Native Application that includes a Streamlit UI. The application needs to read configuration parameters such as API keys and database connection strings. Which of the following methods are the recommended and secure ways to manage these configuration parameters within a Snowflake Native App?

• A. Use Streamlit secrets Cst.secretS) configured within the Streamlit application's settings in Snowflake. Store sensitive information like API keys and database credentials there.
• B. Store the configuration parameters directly within the Streamlit code as Python variables.
• C. Store the configuration parameters in a dedicated table within the Snowflake managed database and read them using SQL queries from the Streamlit application. Grant appropriate privileges to the Streamlit application's role on this table.
• D. Store the configuration parameters as environment variables within the Snowflake environment where the Streamlit application is running.
• E. Store configuration parameters in an external file (e.g., a JSON or YAML file) and include it in the application's deployment package. Read the file from the Streamlit application.

You are developing a Snowflake Native Application that provides data enrichment services. You want to offer tiered pricing based on the number of API calls made by consumers. Which of the following is the most effective approach to implement usage-based billing and track API call consumption within your application?

• A. Leverage Snowflake's built-in metering framework using and 'SYSTEM$METER STAGE_STORAGE BYTES' to indirectly estimate API calls.
• B. Use Snowflake's resource monitors to limit the compute resources available to consumers based on their chosen tier.
• C. Implement a custom logging mechanism within the application to track API calls and store the logs in a separate Snowflake database, accessible only to the provider. Use scheduled tasks to analyze these logs and generate billing data.
• D. Implement a UDF within the application that increments a counter in a shared table each time an API endpoint is called. Query this table to determine usage.
• E. Utilize Snowflake's events table to capture API call events based on function executions, enabling precise tracking and reporting of API usage for each consumer.

You are developing a Snowflake Native Application that requires secure access to external services for data enrichment. You choose to implement an External Function with API Integration. Which of the following security best practices are MOST important to implement when configuring the API Integration and the External Function to minimize security risks?

• A. Grant usage on the API integration to PUBLIC role to allow all users to invoke the external function.
• B. Disable network policies on the API Integration to avoid accidental blocking of traffic.
• C. Configure 'AWS IAM ROLE ARNS or similar parameters (depending on cloud provider) to grant Snowflake the least privilege access to the specific resources on the external service required by the function.
• D. Use the parameter in the API Integration to restrict access to only the trusted IP addresses of the external service.
• E. Store any sensitive credentials required by the external service directly in the External Function's code body for easy access.