Snowflake NAS-C01 Value Pack (Frequently Bought Together)

You are designing a Snowflake Native Application that involves data sharing with consumers. You want to leverage a custom Python library 'data_transform.py' within your application package to perform specific data transformations on the shared data before it is accessed by consumers. This library contains sensitive logic and should not be directly visible or accessible by the consumer. Which of the following is the MOST secure and appropriate way to package and utilize this 'data_transform.py' library?

• A. Publish 'data_transform.py' as a public Python package on Anaconda and have consumers install it in their Snowflake environment.
• B. Store 'data_transform.py' as an internal stage file and read it dynamically into your application's Python code at runtime.
• C. Embed the contents of 'data_transform.py' directly within the application's stored procedure code as a multi-line string.
• D. Include directly within your application package's source code and call its functions from within your application's procedures. Grant necessary privileges on the procedures to the consumer's role, ensuring to only expose the procedures and never the python source.
• E. Package 'data_transform.py' as a user-defined function (UDF) and grant 'USAGE privilege on the UDF to the consumer's role.

A software vendor is developing a Snowflake Native App that provides data enrichment services. As part of the application lifecycle, they need to automate the process of packaging, deploying, and upgrading their application across multiple Snowflake regions. Which of the following approaches provide the MOST efficient and reliable way to automate the deployment and upgrade process for this Native App? Select TWO options.

• A. Create a custom deployment tool that directly manipulates Snowflake's metadata tables to register the application package.
• B. Manually create application packages for each region and upload them to Snowflake using the web interface.
• C. Leverage Snowflake's Native Apps API (if available) to programmatically manage the application package lifecycle.
• D. Integrate with CI/CD pipelines, creating packages and updating versions to control the application's deployment and upgrade process.
• E. Use Snowflake's CLI (SnowSQL) in conjunction with scripting tools (e.g., Bash, Python) to automate the creation of application packages and deployments.

As a Native App Provider, you've identified a performance bottleneck in a query against a table within your application's container due to an inefficient join. The query is part of a view exposed to consumers. Which of the following actions would be MOST effective in improving the query performance while minimizing disruption to consumers?

• A. Create a materialized view in place of the existing view, pre-computing the join results. This will require consumers to update their queries to use the new materialized view name.
• B. Implement a scheduled task to regularly update the statistics of the table involved in the join. This will help the query optimizer make better decisions, and consumers will see improved performance gradually.
• C. Add a 'CLUSTER BY clause to the underlying table based on the join keys. Consumers will automatically benefit from improved query performance without any changes on their end.
• D. Rewrite the query in the view definition to use a more efficient join algorithm (e.g., using hints). Consumers will automatically benefit from the improved performance.
• E. Create a search optimization policy on columns used in the 'WHERE' clause in the view. This does not require any changes from the consumers.

A provider is testing their Snowflake Native Application in a consumer environment. The application includes a Streamlit app that displays data from a table provisioned in the consumer account. The consumer reports that the Streamlit app is displaying an errorrelated to accessing the table. The 'streamlit.secretS dictionary is used to store the database connection details. The application role app_role' is designed to have access to the table. Which of the following could be potential causes of the problem, assuming the connection details are valid?

• A. The Streamlit app is not properly configured to assume the when executing queries.
• B. The consumer has not shared the database containing the table with the provider account.
• C. The 'app_role' does not have the 'SELECT privilege on the table.
• D. The 'streamlit.secretS dictionary is not accessible to the application due to incorrect file permissions.
• E. The 'app_role' does not have the privilege on the database containing the table.

A data engineer, Alice, is developing a Snowflake Native Application that exposes a stored procedure, 'calculate_aggregate' , within the application schema 'app_schema'. She initially granted privilege on the application database to the 'analyst_role' and EXECUTE privilege on 'calculate_aggregate' to the same role. Later, due to a security audit, she needs to revoke the 'EXECUTE privilege from 'analyst_role' but wants to ensure users assigned to 'analyst_role' can still access other objects in the application database (but not execute this specific stored procedure). Which of the following actions achieves this goal MOST efficiently and securely?

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