SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 34


True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

Show Answer
Correct Answer: B

The statement is False. A third-party tool that supports standard JDBC or ODBC can connect to Snowflake even without a Snowflake-specific driver. Snowflake provides JDBC and ODBC connectors that adhere to these standard interfaces, allowing third-party tools to establish a connection using these protocols. This ensures compatibility and makes integration with Snowflake feasible for various tools and applications supporting JDBC or ODBC.

Discussion

60 comments
Sign in to comment
redsky0
Jan 3, 2022

Answer is B False: E.g. JDBC: https://docs.snowflake.com/en/user-guide/jdbc.html Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.

shubtred
Jun 12, 2023

False. A third-party tool that supports standard JDBC or ODBC can connect to Snowflake even without a Snowflake-specific driver. Snowflake provides JDBC and ODBC connectors that adhere to the standard JDBC and ODBC interfaces, allowing third-party tools to establish a connection to Snowflake using these standard protocols. The Snowflake JDBC and ODBC connectors act as bridges between the third-party tools and the Snowflake service, enabling communication and data exchange. As long as the third-party tool supports JDBC or ODBC, it can utilize the Snowflake connectors to connect to Snowflake and interact with the data warehouse. This approach ensures compatibility and interoperability with a wide range of tools and applications that support JDBC or ODBC, making it easier to integrate Snowflake into existing ecosystems or use preferred third-party tools for data analysis, reporting, or other purposes.

ExamGuruBhai
Dec 25, 2022

False. A third-party tool that supports standard JDBC (Java Database Connectivity) or ODBC (Open Database Connectivity) can be used to connect to Snowflake, as long as the tool is properly configured to connect to Snowflake's database. Snowflake provides JDBC and ODBC drivers that can be used to connect to Snowflake from third-party tools, but it is not necessary to use these drivers in order to connect to Snowflake. Any tool that supports standard JDBC or ODBC and is properly configured to connect to Snowflake's database will be able to connect to Snowflake.

KarBiswa
Feb 8, 2023

The question is not clear

ShagunMittalOption: A
Mar 2, 2023

True is True :)

DK69
May 9, 2022

So answer it TRUE (A). Just ODBC or JDBC is not enough. Need to have the Snowflake driver

BigDataBB
Jan 10, 2023

The tool must be support the ODBC/JDBC connection don't must use his "internal" connector. If it support JDBC/ODBC connection, then can use the SF JDBC/ODBC connector to connect to SF.

DK69
May 10, 2022

So it requires the Snowflake JDBC type 4 driver. So answer is A

joe12
Jan 24, 2023

the answer is true because they saying will be unable to connect

c0d3gOption: A
Mar 1, 2023

The question says - " but has no Snowflake-specific driver" that means it cannot connect. It has to be Snowflake-specific JDBC/ODBC. So, answer is A. True

0e504b5Option: B
Jan 16, 2024

I vote False. As long as you support JDBC or ODBC, you should be able to connect to Snowflake https://docs.snowflake.com/en/developer-guide/drivers

Zafar202
Jan 10, 2022

B should be correct.

Fab33Option: B
Jan 12, 2022

B should be correct.

BungyTexOption: A
Jun 22, 2022

You need the drivers, therefore the answer is A - TRUE.

tinkofee
Dec 4, 2022

A - You can't connect to Snowflake with standard ODBC/JDBC connectors. Snowflake has it's own ODBC/JDBC drivers (https://docs.snowflake.com/en/user-guide/conns-drivers.html). Of course, you can connect with (for example) Python without any ODBC/JDBC driver, but this is not the question.

Andywu213Option: A
Jan 6, 2023

True, verified

Anu825
Mar 2, 2023

Answer is A True

KarthikparasuramanOption: A
Aug 20, 2023

JDBC or ODBC needs snowflake driver to connect snowflake

d22770a
Oct 7, 2024

It is B

legohaxOption: B
Dec 19, 2024

False, Snowflake has generic ODBC/JDBC driver support

rocky_vits1Option: B
Dec 26, 2024

JDBC Driver is provided by snowflake

Julien25Option: B
Jan 23, 2022

JDBC and ODBC could be used

Sid460545
Jan 30, 2022

B, False

Anirudh2020
Feb 20, 2022

B is right

Graghu
May 9, 2022

B is the answer

BobCuiOption: B
Aug 1, 2022

Snowflake provides JDBC driver

Percy2112Option: B
Aug 14, 2022

Snowflake provides JDBC , ODBC etc drivers to connect.

systematics78
Jan 19, 2023

A is the correct Answer - to connect to snowflake you have to use snowflake native drivers

ajay_1233456
Jan 22, 2023

Answer is B False:

shyemkoOption: A
Mar 28, 2023

A third-party tool that supports standard JDBC or ODBC is not enough, they should have a JDBC driver for Snowflake and ODBC driver for Snowflake

Mayuri917233Option: A
May 11, 2023

A is correct

Pythonscript
May 12, 2023

its possible to connect to snowflake in Python using JDBC .Snowflake also provides a native python-snowflake connector.

surya610Option: A
May 29, 2023

true drivers must be snowflake provided

oscarglobOption: A
Sep 29, 2023

Looks like the Snowflake-provided driver is necessary... https://www.snowflake.com/blog/ability-to-connect-to-snowflake-with-jdbc/

BobFar
Oct 11, 2023

Answer is A: true Need snowflake driver to connect https://www.phdata.io/blog/connecting-to-snowflake-jdbc-odbc-drivers/

sandy91Option: A
Jan 15, 2024

TRUE A snowflake driver is required

Nospamd
Jan 18, 2024

Entire purpose of JDBC or ODBC connector is to make it generic. B is correct.

snowman1911Option: B
Jan 31, 2024

B is the correct answer as stated by others

whiteomax
Feb 3, 2024

This is how I understand the question, if the tool does not come with a snowflake drive, can it be connected to Snowflake? I think the answer is YES, Because Snowflake provides the driver, as long as the tool supports JBDC, the snowflake provided driver can connect the tool to Snowflake. To me, it does not make sense if the question is asking: this tool does support JDBC but does not support Snowflake driver, can it still connected to Snowflake?

KarimoOption: B
Feb 11, 2024

B of course

_yyuktaOption: B
Feb 23, 2024

b . false

DineshDalviOption: A
Feb 24, 2024

Straight Forward question is, third party tools support JDBC/ODBC that has snowflake driver which can connect to snowflake. - It has same meant; third party tool supports JDBC/ODBC that has no snowflake driver that will be unable to connect to snowflake. Therefore, answer is True. Answer is A.True

havik
Apr 16, 2024

The entire purpose of JDBC or ODBC is to remove the dependency on any specific provider dirvers. And:B

TheHuman_Option: B
May 6, 2024

B correct

JasMozaiOption: B
May 9, 2024

False. Snowflake provides JDBC and ODBC drivers that allow third-party tools supporting these standards to connect to Snowflake. While having Snowflake-specific drivers might offer optimized performance and additional features, standard JDBC or ODBC drivers can still establish a connection to Snowflake.

nexerSnowOption: B
May 13, 2024

b is cott

p22_nileshOption: A
Jun 3, 2024

Yes, it can connect.

bot314Option: A
Jun 14, 2024

True is the answer

Mallikharjuna452
Jul 18, 2024

B.False

Anithec0der
Jul 20, 2024

Correct Answer: B

Tushar0807
Jul 29, 2024

Answer is B

jirizOption: A
Sep 30, 2024

I believe, that the answer is True, so A

theriderzoneOption: B
Oct 4, 2024

B. False

Daniel1412Option: B
Oct 28, 2024

as long as JDBC or ODBC is supported it can connect

pjfunnerOption: B
Oct 31, 2024

It's B. As long as ODBC and JDBC are supported you can connect to Snowflake.

HICH9173Option: B
Nov 1, 2024

Answer is B

Shipra123
Nov 15, 2024

False. A third-party tool that supports standard JDBC or ODBC can connect to Snowflake even without a Snowflake-specific driver.

kentucky13caaOption: B
Nov 15, 2024

The correct answer is B. False A third-party tool that supports standard JDBC or ODBC can connect to Snowflake even without a Snowflake-specific driver. This is because Snowflake supports standard JDBC and ODBC protocols, allowing tools that use these standard database connectivity interfaces to establish connections to Snowflake. The statement is false because: 1. Standard JDBC/ODBC support is sufficient for basic connectivity 2. Snowflake is designed to work with standard database connectivity protocols 3. While Snowflake-specific drivers might offer optimized performance or additional features, they are not strictly required for basic connectivity

Djama
Nov 19, 2024

Answer is B : False

YugendharsaiOption: A
Dec 16, 2024

Snowflake supports JDBC OR ODBC Does not care about driver it having its supported driver version to connect

Sudhansu21Option: B
Feb 18, 2025

A third-party tool that supports standard JDBC or ODBC can connect to Snowflake even if it does not have a Snowflake-specific driver. Snowflake provides its own JDBC and ODBC drivers that can be used by any tool that supports these standard interfaces. Therefore, as long as the tool can use a JDBC or ODBC driver, it can connect to Snowflake using Snowflake's provided drivers.