Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 32 of 405
Free Preview · 405 of 1,348 · questions 1–405 of 1,348 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The correct answer is: B. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL ✅ 💡 Explanation: Snowflake provides functions to check the version of clients/drivers in use. CURRENT_JDBC_VERSION() → Returns the version of the JDBC driver currently being used. Similar functions exist for other clients: CURRENT_ODBC_VERSION() → ODBC driver version CURRENT_CLIENT() → Returns the name of the client, not its version. Why not the others? A. CURRENT_ODBC_CLIENT() → Invalid function name. C. CURRENT_CLIENT() → Gives client name (e.g., "SnowSQL"), not driver version. D. CURRENT-VERSION() → Not a valid Snowflake SQL function.
Returns the version of the client from which the function was called. If called from an application using the JDBC or ODBC driver to connect to Snowflake, returns the version of the driver.
Its only C