Exam SnowPro Core topic 1 question 304 discussion

/*Returns the Current Client Version */ SELECT CURRENT_CLIENT(); /*Returns the Current Snowflake Version */ SELECT CURRENT_VERSION();

C is correct

https://docs.snowflake.com/en/sql-reference/functions/current_client

CURRENT_CLIENT 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.

The correct option for listing the version of the drivers currently being used in Snowflake is: B. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL The CURRENT_JDBC_VERSION() function is used to retrieve the version of the JDBC driver in use. SnowSQL is a command-line client for Snowflake, and you can execute SQL statements directly using it. The other options do not directly provide information about the driver version: A. SELECT CURRENT_ODBC_CLIENT(); is used to get information about the ODBC client, not the version of the ODBC driver. C. SELECT CURRENT_CLIENT(); provides information about the client environment but not the driver version. D. SELECT CURRENT_VERSION(); is a generic function that provides information about the version of the Snowflake service itself, not the driver version. So, option B is the correct one for obtaining the version of the JDBC driver in use

SELECT CURRENT_CLIENT();

SELECT CURRENT_CLIENT();

C is the correct answer. Just checked it.

CURRENT_CLIENT() -- name and version of connected client CURRENT_VERSION() -- version of Snowflake

https://docs.snowflake.com/en/sql-reference/functions/current_client.html

Answer C

Correct Answer C https://docs.snowflake.com/en/sql-reference/functions/current_client.html