SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ39

Design and Manage Snowflake Resources and Performance

A Data Engineer is developing a Python script that uses the Snowflake Connector for Python. The Engineer will use the snowflake.connector.connect function to connect to Snowflake.

The requirements are:

  • Raise an exception when the specified database, schema, or warehouse does not exist.
  • Improve download performance.

Which connect function parameters should be used?

Choose two
Explanation

Setting validate_default_parameters to True raises an exception if the specified database, schema, or warehouse does not exist. client_prefetch_threads controls the number of threads used to download result sets; increasing it can improve fetch performance, with additional memory use.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!