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.)
To raise an exception if the specified database, schema, or warehouse does not exist, the 'validate_default_parameters' parameter should be used. For improving download performance, 'client_prefetch_threads' is appropriate as it controls the number of threads used to download the result sets, thus enhancing performance.
client_prefetch_threads: Number of threads used to download the results sets (4 by default). Increasing the value improves fetch performance but requires more memory. validate_default_parameters: Raise an exception if the specified database, schema, or warehouse doesn’t exist.