Pass with NAS-C01 Practice Materials 100% for sure

A company publishes a Snowflake Native Application on the Snowflake Marketplace providing aggregated sales dat a. They want to ensure data is fresh and updated daily at 00:00 UTC. They are considering several approaches to automate this data refresh process.
Which of the following methods are MOST effective and SECURE for scheduling and executing this daily data update within the Snowflake Native Application environment? Choose two.

• A. Use Snowflake Tasks scheduled to run daily at 00:00 UTC to execute a stored procedure within the Native Application that updates the data.
• B. Utilize a cron job on a virtual machine to execute a SQL script via SnowSQL, connecting to Snowflake and refreshing the data.
• C. Implement a Java-based scheduler within the Snowflake Native Application itself using UDFs, triggered by an external service via API integration.
• D. Schedule a Python script using an external task service (e.g., AWS Lambda) that connects to Snowflake and executes the data refresh procedure.
• E. Leverage Snowflake's Data Marketplace update scheduling feature (if available and applicable to their type of listing) to automatically refresh the data.

A data science team within your organization is developing a Snowflake Native App that needs to access and process customer data stored in a Snowflake database. The app must only access data for customers residing in the 'USA' region. The team has created a custom role 'APP ROLE for the app to use. Which of the following is the MOST secure and efficient way to grant the app the necessary permissions to read the filtered data? Assume a secure view approach is preferred over direct table access.

• A. Grant the SAPP ROLE the 'OWNERSHIP' privilege on the base customer data table and implement data filtering logic within the app itself.
• B. Grant the 'APP_ROLE the 'USAGE privilege on the database and schema containing the customer data table. Data filtering should still be handled by the app.
• C. Grant the 'APP_ROLE the 'SELECT privilege on the base customer data table and rely on row-level security policies defined on that table.
• D. Create a secure view that filters customer data to include only customers in the 'USA' region and grant the SAPP ROLE the 'SELECT privilege on the secure view.
• E. Create a standard view (non-secure) that filters customer data to include only customers in the 'USA' region and grant the 'APP_ROLE the 'SELECT' privilege on this view.

You are responsible for managing the pricing plans for your Snowflake Native Application listed on the Marketplace. You want to offer a 'Premium' tier that includes additional features and resources. To achieve this, you need to modify the listing to include this new pricing option. Which of the following steps are NECESSARY and in the CORRECT order to successfully add the 'Premium' tier to your application's listing, ensuring existing customers are not negatively impacted? (Choose two options in their proper order)

• A. 1. Test new Pricing in a Sandbox environment with few consumers. 2. Deploy the new version to the consumer accounts.
• B. 1. Modify the existing application package in place to include the code changes supporting the 'Premium' features. 2. Update the Marketplace listing with the modified application and add the 'Premium' pricing tier with appropriate settings.
• C. 1. Create a new version of the application package in your provider account with the code changes supporting the 'Premium' features. 2. Update the Marketplace listing with the new version of the application and add the 'Premium' pricing tier with appropriate settings.
• D. 1. Update the listing on the Marketplace with the new pricing tier. 2. Ensure backward compatibility for existing customers by implementing logic in the application to detect their current tier and maintain existing functionality.
• E. 1. Update the Marketplace listing by adding the 'Premium' pricing tier with appropriate settings, but without modifying the application package. 2. Inform existing customers that the new pricing tier is available.

Your team is building a Snowflake Native App that uses a UDF (User-Defined Function) for data enrichment. The UDF needs to access an external API key. Which of the following approaches are valid and secure methods for providing the API key to the UDF within the Native App framework?

• A. Store the API key in a database table within the consumer's account and grant the UDF access to that table.
• B. Pass the API key as a parameter to the UDF when it's called.
• C. Use a secure parameter in the MANIFEST.yml and access it within the UDF.
• D. Store the API key directly in the UDF's code.
• E. Store the API key using Snowflake's Secret Management feature and grant the UDF access to the secret.

You are developing a Snowflake Native App that will be listed on the Snowflake Marketplace. The application requires a specific version of a Python library that may conflict with other libraries used by consumers. How can you ensure that your application uses the correct library version without causing conflicts in the consumer's environment?

• A. Modify the consumer's 'PYTHON PATH' environment variable upon installation to include the location of your application's Python libraries.
• B. Instruct consumers to manually install the required Python library version in their Snowflake environment before installing your app.
• C. Package all application logic into a single SQL UDF to avoid Python dependency issues entirely.
• D. Rely on Snowflake's automatic dependency resolution to identify and install the correct version of the Python library in the consumer's environment.
• E. Bundle the required Python library with your application package and utilize Anaconda packages support to manage dependencies, ensuring isolation from the consumer's environment.