A Java application using the Snowflake JDBC driver fails to connect with 'Incorrect username or password was specified.' The credentials are correct and work in Snowsight. The application uses key-pair authentication. What is the most likely cause?

The JDBC driver version is outdated

The private key is not correctly configured in the JDBC connection properties

The user's password is incorrect

Which Java Database Connectivity (JDBC) driver class is used to connect to Snowflake?

net.snowflake.client.jdbc.SnowflakeDriver

A Python application uses the Snowflake connector with connection pooling. After a recent code change, the application starts throwing 'Session is terminated' errors. The team suspects the pool is reusing stale connections. What should they do to resolve this?

Increase the 'pool_size' parameter

Set 'session_parameters' to 'AUTOCOMMIT'

Set 'pool_reconnect' to True in the connection pool configuration

SnowPro® Core Certification

Domain 4Objective 4

Connect Using Drivers and Connectors COF-C03 Practice Questions (Page 2)

Part of the Data Loading, Unloading, and Connectivity domain, which accounts for 18% of the COF-C03 exam.

35questions here

7free pages

11concepts

18%of the exam

Questions 6–10

6application · easy
A Go application needs to connect to Snowflake and set the default warehouse. Which Go driver configuration field should be used?
Select an answer first
7expert · medium
A Java application using the Snowflake JDBC driver fails to connect with 'Incorrect username or password was specified.' The credentials are correct and work in Snowsight. The application uses key-pair authentication. What is the most likely cause?
Select an answer first
8foundation · easy
Which Java Database Connectivity (JDBC) driver class is used to connect to Snowflake?
Select an answer first
9expert · medium
A Python application uses the Snowflake connector with connection pooling. After a recent code change, the application starts throwing 'Session is terminated' errors. The team suspects the pool is reusing stale connections. What should they do to resolve this?
Select an answer first
10foundation · easy
Which authentication method allows an external identity provider to grant access tokens for Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.

Connect Using Drivers and Connectors COF-C03 Practice Questions (Page 2)

Questions 6–10

A Go application needs to connect to Snowflake and set the default warehouse. Which Go driver configuration field should be used?

A Java application using the Snowflake JDBC driver fails to connect with 'Incorrect username or password was specified.' The credentials are correct and work in Snowsight. The application uses key-pair authentication. What is the most likely cause?

Which Java Database Connectivity (JDBC) driver class is used to connect to Snowflake?

A Python application uses the Snowflake connector with connection pooling. After a recent code change, the application starts throwing 'Session is terminated' errors. The team suspects the pool is reusing stale connections. What should they do to resolve this?

Which authentication method allows an external identity provider to grant access tokens for Snowflake?

Keep studying — Data Loading, Unloading, and Connectivity