DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ7

VerifiedOfficial exam objectives/topics

Assuming the session parameter USE_CACHED_RESULT is set to false, which characteristic applies to Snowflake virtual warehouses when using Snowpark?

Explanation

Snowpark defers DataFrame creation and transformation until an action executes the plan, so those operations alone do not start warehouse compute. session.call() executes the named stored procedure; a procedure that queries the database requires a running virtual warehouse. With USE_CACHED_RESULT set to false, the persisted query-result cache is not used.

Learn more

Community Discussion

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