You are developing a Snowflake Native App that leverages shared data from the consumer's account. The app needs to dynamically determine the existence of a specific table (e.g., 'CUSTOMER DATA) in the consumer's shared database before attempting to query it. Which of the following SQL commands or approaches within the application package provides the MOST reliable way to programmatically check for the existence of the table?

• A. Use the ' SHOW TABLES LIKE 'CUSTOMER_DATA" command and check if any rows are returned.
• B. Attempt to grant SELECT privilege on the table and check if an error occurs
• C. Use the 'DESCRIBE TABLE CUSTOMER_DATX command within a 'TRY...CATCH' block and handle the exception if the table does not exist.
• D. Execute a 'SELECT 1 FROM CUSTOMER_DATA LIMIT 1' query within a 'TRY...CATCH' block and handle the exception if the table does not exist.
• E. Use the 'INFORMATION SCHEMA.TABLES' view and query it to check if a table with the name 'CUSTOMER DATA' exists in the shared database.

You are preparing to deploy a Snowflake Native Application to the Snowflake Marketplace. You have implemented versioning using the 'VERSION' clause in your setup script. Your application relies on a specific shared data source that is only available in the AWS us- west-2 region. To ensure that consumers in other regions can still install and use your application, you decide to offer different versions with region-specific logic. Which of the following approaches is the MOST effective and recommended to manage region-specific configurations and data sharing across multiple versions of your Snowflake Native Application?

• A. Use the 'PATCH' clause during application deployment to selectively modify the configuration based on the target region. Deploy the same application package to all regions.
• B. Implement conditional logic within the application's stored procedures to check the current region and adjust data sharing and execution accordingly using Package all configurations within a single version.
• C. Create separate application packages for each region, containing region-specific configurations and data sharing setups. This ensures consumers only install the version relevant to their region.
• D. Use separate schemas within the application package for each region, and configure application roles with permissions to only access schemas relevant to their region. No changes to code logic are required.
• E. Implement a build process that generates region-specific setup scripts based on environment variables using a CI/CD pipeline. Each version of the application will then contain the right setup script based on the target region.

You're developing a Snowflake Native App with a Streamlit I-Jl. The app needs to read configuration data from a file named within your application package. The file contains sensitive information, and you want to ensure it's only accessible by your application's code and not directly readable by the consumer. What steps would you take to accomplish this?

• A. Store 'config.json' within the Streamlit code, and then encode and decode it to the original string when the user invokes the Streamlit application.
• B. Store 'config.json' within the application package and read it using Python code within a stored procedure. Grant appropriate privileges on the stored procedure, but not on the 'config.json' file or the internal stage.
• C. Store 'config.json' in an internal stage and grant the 'READ' privilege on the stage to the consumer's role.
• D. Store 'config.json' in a table within your application's schema and grant the 'SELECT' privilege on the table to the consumer's role.
• E. Store 'configjson' outside the application package and read it directly from an external stage at runtime.

An application developer is creating a Snowflake Native App that uses a user-defined function (UDF) 'MY UDF' in 'APP SCHEMA' The UDF reads data from a table 'APP TABLE' which is also in "APP SCHEMA'. The application role is 'APP ROLE'. Which of the following 'GRANT' statements are necessary for the application to function correctly within the provider account , assuming the UDF is defined with 'VOLATILE' behavior and is using the caller's rights (i.e., 'EXECUTE AS CALLER)?

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

A Snowflake Native App developer is creating an application that accesses a secured table 'CUSTOMER DATA' within the provider's account. The developer wants to grant the consumer read-only access to this table through the application, but only after the application is installed and the consumer has accepted the terms and conditions. Which of the following steps are necessary to achieve this goal? (Choose two)

• A. Create a share from the provider account containing the 'CUSTOMER_DATA table and grant the consumer account access to this share using the Snowsight UI, specifically setting the ' READ ONLY' privilege on the table after the application is installed.
• B. The provider creates a versioned schema in the listing and shares it with the consumer account. Once the consumer accepts the terms and conditions, the provider executes 'GRANT SELECT ON TABLE CUSTOMER_DATA TO APPLICATION ROLE app_role' within the consumer account using a secure UDF.
• C. Define a manifest file within the application package that specifies the 'CUSTOMER DATA' table as a resource and declares the 'SELECT privilege required by the application. Snowflake automatically grants this privilege to the application's default role upon installation.
• D. Create an outbound share within the application that shares the 'CUSTOMER DATA' table with a specific application role. Configure an activation hook that runs post-installation to grant the 'SELECT' privilege on the table to the application role using the 'GRANT' command.
• E. Define a stored procedure within the application package that, upon execution in the consumer account (post-installation), executes a 'GRANT SELECT ON TABLE CUSTOMER_DATA TO APPLICATION ROLE app_role' statement. The application itself doesn't directly share the data; the procedure manages the access.