Answer-first summary for fast verification
Answer: Enter through an interactive prompt, Specify using SNOWSQL_PWD environment variables
The question asks for two methods to explicitly specify the password when connecting to Snowflake using SnowSQL. Option D (Enter through an interactive prompt) is correct because SnowSQL can prompt for the password interactively when the connection is established without storing it in configuration files. Option E (Specify using SNOWSQL_PWD environment variables) is correct as it allows setting the password via an environment variable, which is a secure way to avoid hardcoding credentials. The community discussion shows 100% consensus on DE, supported by Snowflake documentation. Options A, B, and C are incorrect: A (public/private key pair) uses key-based authentication, not password specification; B (web-based authorization flow) and C (OAuth token) involve token-based authentication, which does not explicitly use a password.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When connecting to Snowflake using SnowSQL, which two methods can be used to explicitly specify the password?
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
No comments yet.