SnowPro Advanced: Data Engineer — Question 42

A Data Engineer is writing a Python script using the Snowflake Connector for Python. The Engineer will use the snowflake.connector.connect function to connect to Snowflake.
The requirements are:
Raise an exception if the specified database, schema, or warehouse does not exist

Improve download performance -
Which parameters of the connect function should be used? (Choose two.)

Answer options

• A. authenticator
• B. arrow_number_to_decimal
• C. client_prefetch_threads
• D. client_session_keep_alive
• E. validate_default_parameters

Correct answer: C, E

Explanation

The correct parameters for improving download performance while ensuring the existence of the specified database, schema, or warehouse are 'client_prefetch_threads' and 'validate_default_parameters'. 'client_prefetch_threads' enhances the speed of data retrieval by allowing concurrent data fetching, while 'validate_default_parameters' ensures that the connection will raise an exception if any default parameters are incorrect, fulfilling the requirement.