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?
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.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
prshntdxt7
9 months, 3 weeks agoSnow_P
11 months, 2 weeks agoSnow_P
11 months, 2 weeks ago