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?
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?
Calling a Snowpark stored procedure to query the database with session.call() will start a virtual warehouse. This is because the operation involves querying the database, which requires compute resources from a virtual warehouse to execute the query. Other operations like creating and transforming DataFrames are typically performed in-memory and do not necessitate starting a virtual warehouse.
A. Creating a DataFrame from a table will start a virtual warehouse. Incorrect. Creating a DataFrame from a table does not necessarily start a virtual warehouse. It's a common operation that doesn't trigger the initiation of a virtual warehouse. B. Creating a DataFrame from a staged file with the read() method will start a virtual warehouse. Incorrect. Similar to option A, creating a DataFrame from a staged file using the read() method does not trigger the initiation of a virtual warehouse. C. Transforming a DataFrame with methods like replace() will start a virtual warehouse. Incorrect. DataFrame transformations, such as using the replace() method, do not start a virtual warehouse. These operations are performed locally on the DataFrame. D. Calling a Snowpark stored procedure to query the database with session.call() will start a virtual warehouse.
ABC are all transformations so D
I think D