Exam SPS-C01 Topic 1 Question 145 Discussion

Actual exam question for Snowflake's SPS-C01 exam
Question #: 145
Topic #: 1

A Snowpark application is configured to connect to Snowflake using environment variables for authentication. However, the application frequently encounters intermittent connection errors. You suspect that the environment variables are not being correctly accessed by the Snowpark session builder. Which of the following actions could help diagnose and resolve the issue? (Select TWO)

A. Explicitly print the values of the relevant environment variables (e.g., 'SNOWFLAKE_USER , 'SNOWFLAKE_PASSWORD, 'SNOWFLAKE_ACCOUNT) within the Snowpark application before attempting to create the session. B. Use to explicitly set connection parameters instead of relying on environment variables for debugging. C. Verify that the user account specified in the environment variables has the necessary permissions (e.g., USAGE on the warehouse, database, and schema) in Snowflake. D. Replace 'session.builder.getorcreate()' with 'Session.builder.appName('MySnowparkApp').create()' E. Check that the environment variables are set at the correct scope (e.g., system-level, user-level, or within the application's execution environment) and are accessible to the Python process running the Snowpark application.

Suggested Answer: A,E Vote an answer

Options A and E are the most helpful for diagnosing the issue. Printing the environment variable values (Option A) confirms that they are indeed set and have the expected values within the application's context. Checking the scope and accessibility of the environment variables (Option E) ensures that the Python process can access them. Option B, while a valid way to connect, defeats the purpose of using environment variables for security. Option C is also important, but less directly related to the environment variable issue; permissions are checked after connection. Option D does not help debug the environment variable issue, and the provided arguments are unrelated to environment variables.

by Erica at Aug 15, 2026, 10:22 PM

Limited Time Offer

15%

Off

Get Premium SPS-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business