Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DEA-C01 Topic 2 Question 31 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 31
Topic #: 2
[All DEA-C01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Creating a DataFrame from a table will start a virtual warehouse because it requires reading data from Snowflake. The other options will not start a virtual warehouse because they either operate on local data or use an existing session to query Snowflake.


by Isadora at Aug 29, 2024, 12:11 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Janessa
8 months ago
Ah, the joys of Snowflake and their virtual warehouses. At this rate, I'll need a whole farm of them to get anything done!
upvoted 0 times
Gail
7 months ago
C
upvoted 0 times
...
Pilar
8 months ago
B
upvoted 0 times
...
Cornell
8 months ago
A
upvoted 0 times
...
...
Marvel
9 months ago
Hmm, this is tricky. I'm leaning towards B and D, but C also seems plausible. I hope I get partial credit if I miss one!
upvoted 0 times
Haydee
8 months ago
Let's go with B and D for now, but keep C in mind just in case.
upvoted 0 times
...
Suzi
8 months ago
C could also be a possibility since transforming a DataFrame might trigger a virtual warehouse.
upvoted 0 times
...
Shannon
8 months ago
I agree, D makes sense too since calling a stored procedure would also need a virtual warehouse.
upvoted 0 times
...
Hyun
8 months ago
I think B is correct because reading from a staged file would require a virtual warehouse.
upvoted 0 times
...
...
Ressie
9 months ago
That's a good point, Viola. Calling a stored procedure does require processing power as well, so it could also trigger the virtual warehouse.
upvoted 0 times
...
Viola
9 months ago
I'm not sure about that, I think the answer might be D) Calling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse.
upvoted 0 times
...
Jose
9 months ago
I agree with Ressie, because when you create a DataFrame from a table, it requires processing power which triggers the virtual warehouse.
upvoted 0 times
...
Ressie
9 months ago
I think the answer is A) Creating a DataFrame from a table will start a virtual warehouse.
upvoted 0 times
...
Graciela
9 months ago
I'm pretty sure B and D are the correct answers here. Creating a DataFrame from a file and calling a stored procedure both require a virtual warehouse to be running.
upvoted 0 times
Whitney
9 months ago
Good to know that B and D are the correct answers for using Snowpark with virtual warehouses.
upvoted 0 times
...
Bette
9 months ago
Yes, that's correct. Those actions indeed require a virtual warehouse to be started.
upvoted 0 times
...
Olive
9 months ago
I think you're right, creating a DataFrame from a staged file and calling a stored procedure both trigger a virtual warehouse.
upvoted 0 times
...
...
Lelia
10 months ago
A, B, C, and D all sound like they would start a virtual warehouse. I guess Snowflake really wants us to use those warehouses!
upvoted 0 times
Ruby
8 months ago
D) Calling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse
upvoted 0 times
...
Jennifer
8 months ago
C) Transforming a DataFrame with methods like replace () will start a virtual warehouse
upvoted 0 times
...
Alida
8 months ago
B) Creating a DataFrame from a staged file with the read () method will start a virtual warehouse
upvoted 0 times
...
Lemuel
9 months ago
A) Creating a DataFrame from a table will start a virtual warehouse
upvoted 0 times
...
...

Save Cancel