An ODBC application on a Linux server connects to Snowflake successfully from the command line, but fails when run as a service. The service runs under a different user account. What is the most likely cause?

The service user does not have network access

The service user's password is incorrect

The Snowflake account is restricted to certain users

The ODBC driver is not installed in the service user's environment

A Python application opens a new Snowflake connection for every query, causing performance issues. The team wants to reuse connections. Which Python connector feature should they use?

Setting 'session_parameters' to enable connection reuse

Increasing the 'timeout' parameter

Connection pooling with the 'snowflake.connector.pool' module

Using the 'cursor' object to maintain a persistent connection

SnowPro® Core Certification

Domain 4Objective 4

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

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 21–25

21foundation · easy
Which of the following is a required parameter when configuring a Snowflake ODBC DSN?
Select an answer first
22foundation · easy
Which Snowflake driver is used for Go applications?
Select an answer first
23foundation · easy
Which Python connector method is used to execute a SQL query and return the results?
Select an answer first
24expert · medium
An ODBC application on a Linux server connects to Snowflake successfully from the command line, but fails when run as a service. The service runs under a different user account. What is the most likely cause?
Select an answer first
25application · medium
A Python application opens a new Snowflake connection for every query, causing performance issues. The team wants to reuse connections. Which Python connector feature should they use?
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 5)

Questions 21–25

Which of the following is a required parameter when configuring a Snowflake ODBC DSN?

Which Snowflake driver is used for Go applications?

Which Python connector method is used to execute a SQL query and return the results?

An ODBC application on a Linux server connects to Snowflake successfully from the command line, but fails when run as a service. The service runs under a different user account. What is the most likely cause?

A Python application opens a new Snowflake connection for every query, causing performance issues. The team wants to reuse connections. Which Python connector feature should they use?

Keep studying — Data Loading, Unloading, and Connectivity