SnowPro Advanced: Architect — Question 170

An Architect has selected the Snowflake Connector for Python to integrate and manipulate Snowflake data using Python to handle large data sets and complex analyses.

Which features should the Architect consider in terms of query execution and data type conversion? (Choose two.)

Answer options

• A. The large queries will require conn.cursor() to execute.
• B. The Connector supports asynchronous and synchronous queries.
• C. The Connector converts NUMBER data types to DECIMAL by default.
• D. The Connector converts Snowflake data types to native Python data types by default.
• E. The Connector converts data types to STRING by default.

Correct answer: B, D

Explanation

Option B is correct because the Snowflake Connector for Python indeed supports both asynchronous and synchronous queries, which is essential for performance in handling large data. Option D is also correct as the Connector automatically converts Snowflake data types to native Python types, aiding in seamless integration. Options A, C, and E are incorrect as they do not accurately represent the features of the Connector in terms of execution and conversion processes.