SnowPro Core Certification — Question 1243

When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Choose two.)

Answer options

• A. Use public and private key pair authentication
• B. Run a web-based authorization flow
• C. Use an OAuth token
• D. Enter through an interactive prompt
• E. Specify using SNOWSQL_PWD environment variables

Correct answer: D, E

Explanation

The correct answers, D and E, allow for direct password entry and environment variable specification respectively, which are both valid methods for authentication in SnowSQL. Options A, B, and C do not pertain to directly specifying a password, as they relate to different authentication mechanisms.