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

Question 81

You are developing a Snowflake Native Application that uses Streamlit to present dat a. The application relies on a UDF to perform calculations. The UDF resides in the application's schema within the container. The application package is named and the application itself is named 'my_app'. You need to grant the application the necessary privileges to execute this UDF. Which of the following SQL statements, executed by the application provider, will correctly grant the required privilege to the application?

Question 82

You are developing a Snowflake Native Application that leverages Snowpark Python for data transformation. Your CI/CD pipeline utilizes GitHub Actions for automated testing and deployment. One of your Snowpark functions relies on a UDF that reads data from an external stage. To ensure seamless integration testing in different environments (development, staging, production), you need to dynamically configure the stage URL during the test execution. Consider that you're using environment variables to store environment-specific values. Which of the following approaches provides the MOST secure and maintainable way to configure the stage URL in your Snowpark test code?

A.Hardcode the stage URL directly within the Snowpark Python code. Use different code branches for each environment to manage the different URLs.

B.Use the 'os.environ' module in Python to read the stage URL from the environment variable. Pass the URL directly to the UDF as a string argument.

C.Create a Snowflake Secret object to store the stage URL. Within your Snowpark Python code, use the function to retrieve the secret value and pass it to the UDF.

D.Store the stage URL in a configuration file (e.g., JSON or YAML) within the application package. Read the configuration file during test execution and pass the URL to the UDE

E.Define the stage URL as a global variable within your Snowpark session. Set the global variable to the correct URL at the beginning of the test script, using 'os.environ.get()'.

Question 83

You are developing a Snowflake Native App that requires specific Snowflake features and functionalities. To ensure compatibility and proper execution across different consumer environments, you need to define the minimum required Snowflake version. Which section in the manifest file is used to specify the minimum Snowflake version required by the application and what is the correct syntax?

A.The 'dependencies' section. Syntax: '"dependencies": [{"snowflake_version":">=7.0"}]

B.The 'application' section. Syntax: '"application": {"min_snowflake_version": "7.0"}'

C.The 'configuration' section. Syntax: '"configuration": {"required_snowflake_version": "7.0"}'

D.The 'setup' section. Syntax:

E.The 'api_version' section. Syntax: '"api_version": along with in the 'applications section.

Question 84

You are developing a Streamlit application within a Snowflake Native App that needs to access a custom Python module ('my_module.py') containing utility functions. The module resides in the same stage as your Streamlit application code. How would you ensure that the Streamlit application can correctly import and use this module?

A.Place 'my_module.py' in the same directory as your main Streamlit application file. Snowflake automatically includes all files in the same directory when deploying the application.

B.Modify the ' PYTHONPATHS environment variable within the Snowflake environment to include the stage where 'my_module.py' is located.

C.Use the method in your Streamlit application code to add the stage location to the Python module search path before importing my_module' .

D.Include in a 'requirements.txt' file and use 'pip install -r requirements.txt' within the Streamlit application's entrypoint script.

E.Use the function to dynamically load 'my_module.py' directly from the stage, specifying the full stage path.

Question 85

Which of the following statements regarding warehouse sizing and configuration for a Snowflake Native Application are true?

A.Warehouse size cannot be changed after it is created.

B.A larger warehouse size always guarantees faster query execution, regardless of the query's characteristics.

C.The 'AUTO SUSPEND' parameter controls how long a warehouse remains active after executing queries, impacting cost.

D.The parameter determines if the warehouse is used for data loading vs query processing.

E.The 'MAX CONCURRENCY LEVEL' parameter helps manage the number of queries that can be executed concurrently on the warehouse.

Latest Upload: 131Databricks.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; 157Oracle.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 81

Question 82

Question 83

Question 84

Question 85

Download PDF File