Snowflake SnowPro Specialty - Native Apps - NAS-C01 Exam Practice Test

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.

You are developing a Snowflake Native Application that relies on external functions (UDFs) hosted outside of Snowflake. You need to ensure that these external functions are securely accessed and that you can track their usage. Which of the following steps are required to correctly configure and manage access to external functions in your application package?

You are developing a Snowflake Native App that needs to access a secured external API to enrich customer dat a. The API requires an OAuth 2.0 token stored securely. Which of the following approaches would you use within the application manifest and Snowflake objects to securely store and access this token, minimizing exposure and adhering to best practices?

You have a Snowflake Native Application that utilizes a managed table. After upgrading your application to version 2.0, some users report that they are missing data in the managed table. After investigation, you realize version 2.0 changed the schema of the managed table and also did not properly migrate all the data from old format into new format. Which of the following steps should be taken to address the missing data after upgrading a Snowflake Native Application?

You are developing a Snowflake Native Application that uses Streamlit for its user interface. The application needs to access a custom Python module named 'my_module' which resides within your application package. You have correctly packaged the module. However, when running the Streamlit application, you encounter an 'ImportError: No module named What is the most likely reason for this error and how can you resolve it?

You are creating a Snowflake Native Application that includes a stored procedure to process sensitive dat a. The procedure needs to access data from a table owned by the application package and write processed data to a table in the consumer's account. The data in the consumer's table must only be accessible by authorized roles within the consumer's account, not directly by the application itself. Which of the following approaches ensures the MOST secure and controlled access to the consumer's data?

You are tasked with deploying a new version of your Snowflake Native Application. The new version introduces significant schema changes to the data warehouse used by the application. What steps should you take during the deployment process to ensure a smooth transition and minimize downtime?

You are developing a Snowflake Native Application that utilizes a Streamlit frontend. The application requires access to specific data in the consumer account. You've already defined the necessary roles in your provider account. Which of the following steps are absolutely necessary to grant the Streamlit application the appropriate permissions to access the consumer's data? Assume the provider account has already shared the application package.

You are developing a Snowflake Native Application that relies on external functions (UDFs/UDTFs) for data processing. A new version of your application includes significant changes to these external functions, potentially affecting existing consumer data and queries. How should you manage the upgrade process to minimize disruption and ensure data integrity in consumer accounts? Assume consumers rely on your function names in their queries. Which of the following approach is MOST suitable?

You are designing a Snowflake Native Application that requires granular control over the privileges granted to different application roles. You want to follow the principle of least privilege. You have the following requirements: Application roles , and app_read_only'. What is the most effective strategy to implement this using definer's rights?

You are designing a Snowflake Native Application using Snowpark Container Services to perform real-time sentiment analysis on streaming dat a. The application needs to subscribe to a Snowflake event table to receive incoming data, perform the analysis in the container, and store the results in another table in the consumer's account. Which of the following approaches represents the most efficient and scalable way to implement this data ingestion and processing pipeline?

You are packaging a Snowflake Native App that includes a file. During the packaging process, you encounter an error stating that a required Python package, 'pandas', is not found. However, you have included a 'requirements.txt' file in the application bundle with 'pandas' listed as a dependency. What is the MOST likely cause of this error, and what steps can you take to resolve it?