Snowflake NAS-C01 Actual Free Exam Questions & Community Discussion

You are developing a Snowflake Native App that processes sensitive customer dat a. Your app needs to access data from a table owned by the consumer and write transformed data back to another table also owned by the consumer. To ensure data privacy and security, you decide to use a secure view for accessing the customer data and a stored procedure for writing the transformed data.
However, you are facing issues with privilege escalation when the stored procedure tries to access the secure view. The stored procedure is defined with the 'EXECUTE AS CALLER clause. Which of the following steps can you take to mitigate this privilege escalation issue and ensure secure data access?

You are developing a Snowflake Native Application package and want to publish it. You have created the necessary setup script, version, and patch. However, you encounter an error during the 'ALTER APPLICATION PACKAGE' command. The error message indicates an issue with the setup script. Identify the most probable cause of this error and the solution.

You are developing a Snowflake Native Application that requires access to an external API to enrich data within the consumer's account. You need to implement secure authentication and authorization to this external API. Which of the following methods provide the MOST secure and compliant approach for storing and managing the API credentials within your Snowflake Native Application package, while minimizing the risk of exposure to the consumer?

You are packaging a Snowflake Native App that includes a Streamlit application for data visualization. The Streamlit application needs to access a table named 'SALES DATA within the app's data container. Which of the following steps are REQUIRED to correctly grant the Streamlit application the necessary permissions to read the data? (Select all that apply)

You are designing a Snowflake Native App that includes a Streamlit I-Jl. The Streamlit app needs to access data stored in a secure table within the consumer's account. What are the recommended and MOST secure methods for granting the Streamlit app access to this data, considering the principle of least privilege? Select all that apply.

A data analytics company, 'Data Insights Pro', develops a Snowflake Native Application that provides advanced data visualizations. They want to publish this application on the Snowflake Marketplace as a public listing. Which of the following steps are required in addition to the standard application creation and packaging, specifically focusing on the public listing aspects? Assume the necessary roles and privileges are already granted.

You are designing a Snowflake Native App that relies on a specific version of a shared library. You want to ensure that your application continues to function correctly even if the provider of the shared library releases a new, incompatible version. How can you achieve version isolation for your application's dependencies within the Snowflake Native App Framework?

You are developing a Snowflake Native App that needs to be configurable by the consumer during installation. You define parameters in the 'manifest.ymr file. During application installation, the consumer provides values for these parameters. How can you access these parameter values within your application's setup script ('setup.sql')?

You are the developer of a Snowflake Native App, and you're designing a feature that allows consumer accounts to create custom reports based on data exposed by the application. These reports will be defined using SQL queries and stored as views within the consumer's account, referencing objects (tables, views) provided by the application. The application does NOT want to provide direct 'SELECT access on underlying application's tables. How can you enable this feature while adhering to best practices for security and access control within the Snowflake Native App Framework? (Select all that apply)

You are building a Snowflake Native Application that provides a data transformation service. You want to allow consumers to configure certain aspects of the transformation pipeline (e.g., the name of the target table, specific transformation logic). What are the recommended approach(es) to allow consumers to customize the application's behavior without directly modifying the application code?

You are designing a Snowflake Native Application that allows consumers to upload data files to a stage within their account, which your application then processes. To enhance security and data governance, you need to implement a callback function that validates the uploaded data before it is processed by your application. The callback function must verify the file format and size. Which of the following options correctly outlines the necessary steps and considerations for implementing this callback function?

You're developing a Snowflake Native App that includes a function, , which retrieves sensitive customer dat a. You want to ensure that this data is only accessible by authorized roles within the consumer's account, even after the application is installed. Which of the following strategies are appropriate for securing the application's data and function access? (Choose two)

You are developing a Snowflake Native Application that integrates with an external API to enrich data within the consumer's account. You need to design the setup script to handle API credentials securely and ensure that consumers can configure their own API keys. Which of the following methods is the MOST secure and recommended approach for managing API credentials within a Snowflake Native Application?

A Snowflake Native App provider is using a Snowpark Python UDF to process data before writing it to an event table for consumption by consumer applications. The UDF fails intermittently with a 'Java heap space' error. Which of the following strategies are MOST effective in mitigating this error?