Study with NAS-C01 Actual Test Questions

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.
  

You are deploying a Snowflake Native Application that utilizes a UDF (User-Defined Function) to perform complex data transformations. The UDF is written in Python and depends on several external packages. You need to ensure that the consumer of your application can seamlessly install and use the UDF without encountering dependency conflicts or versioning issues. How should you manage the UDF and its dependencies during the deployment process, considering Snowflake's Native App framework?

• A. Utilize the Snowflake Native Apps framework to bundle the Python UDF and its dependencies within the application package. Snowflake will automatically handle dependency resolution during application installation.
• B. Use Anaconda packages within the Snowflake environment to manage Python dependencies. Ensure all required packages are explicitly listed in the setup script used during the application installation process.
• C. Package the Python UDF and its dependencies into a ZIP file and include it in the application package. Consumers will need to manually install the dependencies using 'conda install' after installing the application.
• D. Document the Python UDF dependencies in the application's documentation and instruct consumers to manually install them before using the function. No packaging is required.
• E. Upload the Python UDF code directly into a stage and create a Snowflake function using the 'CREATE FUNCTION' command. Rely on the consumer's existing Python environment to resolve dependencies.

You are packaging a Snowflake Native App using the 'snowflake nativeapp package' command. The app relies on a specific external Python library that isn't available by default in Snowflake. Which methods can you use to include this library in your application package and ensure it's accessible within your application's procedures and functions?

• A. Use the Anaconda channel integration. Specify the required package in the 'manifest.ymr file, and Snowflake automatically downloads and installs the library during application installation. This only works for packages available through Anaconda.
• B. Bundle the Python library as a ZIP file along with your application code. When creating the function using 'CREATE FUNCTION' , specify the ZIP file as part of the 'IMPORTS' clause. Snowflake automatically extracts and makes the library available to the function.
• C. Upload the Python library as a stage object and reference it in the 'manifest.ymr file using the 'artifacts' section. Snowflake will automatically include it in the application package and make it available during runtime using the 'IMPORT' statement in the handler code.
• D. Combine options B and C. Use the Anaconda channel integration when possible, and for custom or unavailable packages, use the ZIP file import method for individual functions. Prioritize Anaconda for easier dependency management.
• E. Upload the Python library using the 'PUT' command and explicitly reference it in the 'manifest.ymr under the 'artifacts' section, pointing to the internal stage location. Use the 'IMPORT statement within your stored procedure or UDF handler code to make the library available during execution.

Consider the following setup script intended to install a Snowflake Native Application in test mode. The application relies on a custom role 'APP ROLE' and a secured view 'SECURE VIEW'. Analyze the script and identify which line, if any, contains a critical error that would prevent successful testing:

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

You are developing a Snowflake Native Application that manages customer dat a. You need to ensure that updates to customer records are idempotent. Your application uses a stored procedure 'update_customer(customer_id INT, new_email VARCHAR)' to update customer emails. How can you modify this procedure to guarantee idempotency, assuming that customer data changes are tracked with a 'last_updated' column of type TIMESTAMP NTZ?

• A. Use ' MERGE statement, comparing the new email with the existing email and updating only if they are different, while also ensuring that the update only happens if the new ' last_updated' timestamp is later than the stored one.
• B. Add a 'COMMIT statement at the end of the stored procedure to ensure all changes are persisted immediately.
• C. Create a separate table to store only the changes to customer emails and query this table to determine the latest email.
• D. Implement optimistic locking using a version number for each customer record and checking the version before updating.
• E. Enclose the entire stored procedure within a 'TRY...CATCH' block and retry if any exception occurs.