Answer-first summary for fast verification
Answer: Execute SELECT CURRENT_CLIENT(); from an application
The question asks for the SQL statement that lists the version of the drivers currently being used. According to Snowflake documentation and the community consensus (with multiple upvoted comments and 100% community selection), SELECT CURRENT_CLIENT() returns the name and version of the connected client, including driver versions when called from applications using JDBC or ODBC drivers. Option A (CURRENT_ODBC_CLIENT()) is incorrect as it returns ODBC client information, not specifically driver versions. Option B (CURRENT_JDBC_VERSION()) is not a valid Snowflake function. Option D (CURRENT_VERSION()) returns the Snowflake service version, not driver versions. Thus, C is the correct and only answer.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following SQL statements will display the version of the Snowflake drivers currently in use?
A
Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
B
Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
C
Execute SELECT CURRENT_CLIENT(); from an application
D
Execute SELECT CURRENT_VERSION(); from the Python Connector