Free Access Snowflake.NAS-C01.v2026-05-24.q101 Practice Test (Page 17)

Question 76

You are developing a Snowflake Native Application that provides a data enrichment service. This service requires the consumer to grant the application access to a specific table in their account. You want to ensure that upgrades to your application do not inadvertently break existing consumer configurations. You decide to use a versioned schem a. Which of the following steps are essential during the setup script execution to achieve this and maintain backward compatibility during future upgrades?

A.Create a new unversioned schema named 'APPLICATION' and install all application objects within it. This provides a consistent namespace for all consumers, regardless of the application version.

B.Create a versioned schema using 'CREATE SCHEMA VERSION = ' . Grant the application role 'USAGE on this versioned schema, and ensure all application logic references objects within this schema.

C.Grant the application role 'OWNERSHIP on the consumer's table directly. This allows the application full control and ensures consistent data access regardless of future schema changes within the application.

D.Create a secure view in the versioned schema that accesses the consumer's table. Grant the application role 'SELECT on this secure view. This provides a stable interface that isolates the application from direct changes to the consumer's table.

E.Define a custom role within the application package and grant it the necessary privileges to read the consumer's table via a secure view. Then, grant the application role the USAGE privilege on this custom role. This ensures that the application role can assume the custom role's privileges for data access.

Question 77

You're developing a Snowflake Native Application with a front-end UI built using Streamlit, deployed as a UDF. This UI allows users to upload CSV files for processing. To adhere to security best practices and prevent unacceptable code practices in a Native App, what considerations should you prioritize in your development and deployment process specifically related to handling user-uploaded files ?

A.Implement strict file size limits and file type validation on both the client-side (Streamlit UI) and server-side (Snowflake UDF) to prevent denial-of-service attacks and malicious file uploads. Sanitize and validate the contents of the uploaded CSV file, escaping special characters and preventing SQL injection vulnerabilities if data from the CSV is used in SQL queries.

B.Store the uploaded CSV files directly within a Snowflake table without any validation to ensure high performance and minimal overhead.

C.Disable any logging or auditing of file upload activity to protect user privacy and avoid unnecessary data storage.

D.Assume that all uploaded files are safe and trustworthy, and directly process them without any security checks.

E.Allow user to execute scripts or upload executable file as part of CSV content

Question 78

You are developing a Snowflake Native Application that requires access to a specific stage in the consumer's account to read configuration files. The application needs to be able to create temporary files in the same stage during its execution. Which set of privileges needs to be granted on the stage to the application's service account, and how do you grant them?

A.Grant READ and WRITE privileges on the stage to the application's service account using the 'GRANT USAGE ON INTEGRATION TO APPLICATION command.

B.Grant USAGE and READ privileges on the stage and CREATE FILE on the schema containing the stage to the application's service account using Snowsight.

C.Grant READ and WRITE privileges on the stage using Snowsight, and ensure the application uses a service integration with appropriate permissions.

D.Grant USAGE on the database, USAGE on the schema containing the stage, and READ and WRITE privileges on the stage to the application's service account using a combination of SQL commands and Snowsight.

E.Grant OWNERSHIP on the stage to the application's service account. No other privileges are required.

Question 79

A data science company is developing a Snowflake Native App that provides advanced fraud detection for financial institutions. The app requires secure access to sensitive transaction data within the consumer's Snowflake account. Which of the following approaches BEST aligns with Snowflake's recommended practices for managing data access and securing data within a Native App?

A.The app should request full ACCOUNTADMIN privileges in the consumer account to access all necessary data for fraud detection.

B.The app should use secure views created by the consumer that grant the app read-only access to only the specific transaction data needed for fraud detection.

C.The app should directly access tables containing transaction data using the consumer's own service account credentials, which are securely stored within the app's code.

D.The app should create and manage its own temporary tables in the consumer account and load transaction data into them for processing.

E.The app should directly access transaction data through data sharing from provider account.

Question 80

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?

A.Create a UDF that resides within the consumer's account and is called using the 'CALL' command from the provider's application logic. The UDF validates the file properties and returns a boolean indicating success or failure.

B.Define an event table in the provider account and configure a Snowflake Notification to trigger when a new file is uploaded to the consumer's stage. The notification invokes a remote service that validates the file and updates the event table.

C.Implement a stored procedure within the application package that receives the file path as input. Register this stored procedure as a callback using 'ALTER APPLICATION ... SET callback_procedure = ..:. The stored procedure performs the validation and raises an error if the file is invalid.

D.Create an external function pointing to an API Gateway endpoint that performs the validation. The application logic calls this external function, passing the file path. The external function then returns a boolean indicating success or failure.

E.Set up an AWS Lambda function triggered by S3 events when files are uploaded to the consumer's stage. The Lambda function validates the file format and size and sends a message to a Snowflake queue, which your application then reads.

Latest Upload: 130Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 137SAP.C_CR125_2601.v2026-08-17.q28; 179Salesforce.Field-Service-Consultant.v2026-08-17.q134; 150Oracle.1Z0-1170.v2026-08-16.q64; 156Oracle.1Z1-1170.v2026-08-16.q64; 193Juniper.JN0-336.v2026-08-13.q60; 327EMC.NCP-AII.v2026-08-13.q200; 205CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 162ISQI.CT-GenAI.v2026-08-11.q14

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File