Snowflake NAS-C01 Actual Free Exam Questions & Community Discussion

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)

You are developing a Snowflake Native Application that manages customer accounts. In version 1.0, you had a table named 'CUSTOMER_ACCOUNTS with columns 'ACCOUNT D', 'CUSTOMER NAME, and 'EMAIL'. You are now releasing version 2.0, which requires adding a new column 'PHONE NUMBER to the 'CUSTOMER ACCOUNTS table, but you need to ensure backward compatibility and allow seamless upgrades for existing installations. Which of the following approaches within the 'setup.sqr file is the MOST robust and reliable to implement this schema change without disrupting existing users?

You are developing a Snowflake Native App using Python that performs complex data transformations using UDFs and external functions. During consumer testing, you observe intermittent 'Remote service timed out' errors when calling the external function. The external function is hosted on AWS Lambd a. Which combination of the following actions would BEST address this issue, ensuring reliability without compromising security?

A Snowflake Native App developer encounters an issue where the application fails to install on a consumer's account due to insufficient privileges. The developer has verified that the necessary privileges are declared in the application. privileges section of the manifest file. However, the installation still fails. What could be the most likely cause of this issue, and how can it be resolved?

A Snowflake Native Application is being developed. The application requires access to a third-party API to enrich dat a. To securely store the API key, the developer plans to use a Secret object within Snowflake. Which of the following steps are necessary to grant the application, specifically an application role named 'data_processor' , the ability to read this Secret object? (Choose three)

A data science team is developing a Native App on Snowflake that requires access to data from multiple customer accounts (Reader Accounts). They need to ensure strict data governance and minimize the risk of data leakage. Which of the following approaches provides the MOST secure and scalable solution for accessing and managing this cross-account data?

You are packaging a Snowflake Native Application that utilizes an external function to enrich dat a. This external function requires access to an API endpoint. You've created an API integration in the consumer's account to manage access. How should you grant the necessary privileges to your application to utilize this API integration?

A data engineering team is developing a Snowflake Native Application that processes sensitive PII dat a. They need to update the application frequently with bug fixes and performance improvements without disrupting user access. Which of the following strategies BEST balances rapid iteration with data security and minimal downtime? Consider that the application uses a secure UDF that needs to be updated in conjunction with other application code.

You are developing a Snowflake Native Application that uses a Stored Procedure to orchestrate complex data processing tasks. This stored procedure is defined within the application package. When testing in test mode, which of the following security considerations are paramount to ensure the procedure executes correctly and securely, without unintentionally granting excessive privileges to the consumer?

You are creating a Snowflake Native Application that will be distributed to consumer accounts. As part of the installation process, you need to ensure that a specific database role, 'DATA READER, is created in the consumer account and granted 'SELECT' privileges on a specific table in the consumer's shared dat a. Which of the following code snippets, when placed within the application's setup script (install.sql), will correctly achieve this, assuming the application is granted 'CREATE DATABASE ROLE?

You are developing a Snowflake Native Application that requires specific roles to be assigned to consumers upon installation. Your setup script needs to automatically create these roles if they don't exist and grant appropriate privileges on application objects. Which of the following approaches is the MOST secure and efficient way to achieve this, assuming you want to minimize the attack surface?

You are developing a complex Snowflake Native Application with multiple Python modules and dependencies. You've carefully crafted your 'environment.yml' file, but during the installation process in a consumer account, you encounter intermittent errors related to package conflicts. These errors are difficult to reproduce consistently. What is the MOST effective strategy, encompassing both design and troubleshooting, to mitigate these dependency resolution issues and ensure a reliable installation experience for your users? Select TWO options.

You are developing a Snowflake Native App that processes streaming data from a Kafka topic. The app needs to continuously ingest data, perform real-time transformations, and store the results in a Snowflake table within the app's managed database. Which Snowflake feature(s) and approach(es) are BEST suited for implementing this data ingestion and processing pipeline within the Native App?

You are developing a Snowflake Native Application with a custom setup script. Within the setup script, you need to perform different actions based on whether the application is being installed for the first time in a consumer's account, or if it's an upgrade from a previous version. Which of the following functions or techniques can you reliably use within the setup script to determine if the current execution is a fresh installation vs. an upgrade? (Assume the app version is maintained and accessible as a variable 'current_version' .)