Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 304

Which of the following SQL statements will list the version of the drivers currently being used?

    Correct Answer: C

    The correct SQL statement to list the version of the drivers currently being used is to execute SELECT CURRENT_CLIENT(); from an application. This function returns the version of the client from which the function was called. If it is called from an application using the JDBC or ODBC driver to connect to Snowflake, it will return the version of the driver.

Discussion
EmiBOption: C

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

harshagc180Option: C

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

AravindhTNOption: C

Answer C

examed11Option: C

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

_yyuktaOption: C

C is correct

0e504b5Option: C

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

e_l_i_a_sOption: C

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.

VASI250Option: B

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

444823bOption: C

SELECT CURRENT_CLIENT();

c0d3gOption: C

SELECT CURRENT_CLIENT();

dmitriypoOption: C

C is the correct answer. Just checked it.