SnowPro Advanced: Data Engineer — Question 57

Assuming that the session parameter USE_CACHED_RESULT is set to false, what are characteristics of Snowflake virtual warehouses in terms of the use of Snowpark?

Answer options

• A. Creating a DataFrame from a table will start a virtual warehouse.
• B. Creating a DataFrame from a staged file with the read() method will start a virtual warehouse.
• C. Transforming a DataFrame with methods like replace() will start a virtual warehouse.
• D. Calling a Snowpark stored procedure to query the database with session.call() will start a virtual warehouse.

Correct answer: D

Explanation

The correct answer is D because calling a Snowpark stored procedure with session.call() requires a virtual warehouse to execute the query. Options A, B, and C do not initiate a virtual warehouse under the given condition of USE_CACHED_RESULT being false, as they either use cached results or do not require a warehouse to execute the operation.