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

Question 41

A provider is developing a Snowflake Native Application that uses a managed task to perform critical data transformations. The provider wants to ensure the managed task is only ever executed when the application is in a 'RUNNING' state. They have defined a secure view which returns a single row and a column named 'status' of type VARCHAR. The provider intends to use the 'EXECUTE MANAGED TASK' privilege in conjunction with a user-defined function (UDF) to control task execution. Which of the following approaches, utilizing a UDF and the 'EXECUTE MANAGED TASK' privilege, will correctly and securely prevent the managed task from running unless the application status is 'RUNNING'? Assume the UDF is created with the 'SECURE keyword.

A.Create a UDF that returns TRUE only if 'SELECT status FROM app_db.app_schema.app_status_view' returns 'RUNNING'. Then, in the managed task definition, use the WHEN clause with the UDF. Grant 'EXECUTE MANAGED TASK' on the managed task and 'SELECT on the to the application role.

B.create a UDF that executes if 'SELECT status FROM app_db.app_schema.app_status_view' does not return 'RUNNING'. Grant 'EXECUTE MANAGED TASK' on the managed task to the application role. Do not grant SELECT on the view.

C.Create a UDF that returns TRUE only if 'SELECT status FROM app_db.app_schema.app_status_view' returns 'RUNNING'. Then, in the managed task definition, use the WHEN clause with the UDF. Grant 'EXECUTE MANAGED TASK' on the managed task to the application role. Do not grant SELECT on the view.

D.Create a UDF that executes ' if 'SELECT status FROM app_db.app_schema.app_status_view' returns 'RUNNING'. Grant 'EXECUTE MANAGED TASK' on the managed task to the application role. Grant SELECT on the view.

E.Create a UDF that executes 'SYSTEM$TASK SUSPEND('app_db.app_schema.my_managed_task'Y if 'SELECT status FROM app_db.app_schema.app_status_view' does not return 'RUNNING', otherwise executes Grant 'EXECUTE MANAGED TASK' on the managed task to the application role. Grant 'SELECT on the view.

Question 42

You are developing a Snowflake Native App that requires specific database privileges to be granted to the application role during installation. Which sections of the 'manifest.yml' file are primarily responsible for defining these required privileges, and how does Snowflake interpret and enforce them during the installation process?

A.The 'application.initial_version.privileges' section defines the privileges needed. Snowflake automatically grants these privileges to the application role defined in 'application.initial_version.role' before the setup script runs. This ensures the application has the necessary permissions to create objects and execute code within the consumer's account.

B.The 'setup.script' section defines the privileges needed. The application setup code must explicitly grant these privileges using 'GRANT statements to a specific application role. Snowflake does not automatically grant any privileges, so you have full control over permission management.

C.The 'application.initial_version.artifacts' section is used to define the privileges. Snowflake parses this section to identify required privileges and grants them dynamically to the application role whenever a function or procedure is called that requires them.

D.A combination of the 'application.initial_version.privileges' and 'setup.script' sections. 'application.initial_version.privileges' defines initial static privileges, while 'setup.script' can grant additional privileges dynamically during installation if needed. Snowflake ensures that all specified privileges are granted before the application is fully operational.

E.The 'application.initial_version.parameters' section. While parameters can control behavior, they do not define or manage privileges. Privileges must be manually configured by the consumer post-installation.

Question 43

A customer is attempting to install your Snowflake Native Application from the Snowflake Marketplace, but the installation fails. You need to troubleshoot the issue. Which of the following steps would provide the most direct and relevant information for diagnosing the cause of the installation failure?

A.Examine the application's code repository for any recent changes that might have introduced errors.

B.Review the Snowflake Marketplace listing details to ensure all required components and dependencies are accurately specified.

C.Query the view in the consumers account to retrieve detailed information about the installation attempt, including error messages and status codes.

D.Check the Snowflake system status page for any reported outages or incidents that might be affecting the Marketplace.

E.Ask the customer to share their Snowflake account identifier to check internal logs.

Question 44

You are deploying a containerized application within a Snowflake Native App using Snowpark Container Services (SPCS). This application needs to interact with Snowflake's metadata, specifically retrieving information about tables and views within the customer's account. Which of the following methods is the MOST appropriate and secure way to achieve this?

A.Using the 'snowflake-jdbc' driver directly within the container, configured with the customer's Snowflake account credentials, which are passed as environment variables.

B.Leveraging the Snowpark Python API within the container to execute SQL queries against the Snowflake INFORMATION_SCHEMA views.

C.Creating a REST endpoint within the container that accepts SQL queries as input and executes them against Snowflake using the application's internal service account, then returns the results as JSON.

D.Using the Snowflake CLI (snowsql) within the container, configured with the application's service account credentials, to execute queries against the INFORMATION SCHEMA.

E.Exposing a Snowflake UDF as an API endpoint that the container can call to retrieve metadata. The UDF executes the SQL queries against the INFORMATION SCHEMA.

Question 45

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?

A.Immediately replace the existing application version with the new version. Snowflake will automatically handle any schema compatibility issues.

B.Deploy the new version as a staging version alongside the existing version. Implement data migration scripts to gradually move data to the new schema, and then switch the production traffic to the new version.

C.Notify all users that the application will be unavailable for several hours while the schema changes are applied directly to the production environment.

D.Use Snowflake's zero-copy cloning feature to create a copy of the existing database. Apply the schema changes to the cloned database, test thoroughly, and then promote the cloned database to production.

E.Modify the existing tables in place to reflect the new schema. Update your application's code to be compatible with the new schema after the changes are complete.

Latest Upload: 129Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 135SAP.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 41

Question 42

Question 43

Question 44

Question 45

Download PDF File