Snowflake Exam DEA-C01 Topic 2 Question 31 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 31
Topic #: 2

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?

ACreating a DataFrame from a table will start a virtual warehouse

BCreating a DataFrame from a staged file with the read () method will start a virtual warehouse

CTransforming a DataFrame with methods like replace () will start a virtual warehouse -

DCalling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse

Show Suggested 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

2 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

2 months ago

upvoted 0 times

...

Pilar

2 months ago

upvoted 0 times

...

Cornell

2 months ago

upvoted 0 times

...

Marvel

3 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

2 months ago

Let's go with B and D for now, but keep C in mind just in case.

upvoted 0 times

...

Suzi

2 months ago

C could also be a possibility since transforming a DataFrame might trigger a virtual warehouse.

upvoted 0 times

...

Shannon

2 months ago

I agree, D makes sense too since calling a stored procedure would also need a virtual warehouse.

upvoted 0 times

...

Hyun

2 months ago

I think B is correct because reading from a staged file would require a virtual warehouse.

upvoted 0 times

...

Ressie

3 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

3 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

3 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

3 months ago

I think the answer is A) Creating a DataFrame from a table will start a virtual warehouse.

upvoted 0 times

...

Graciela

3 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

3 months ago

Good to know that B and D are the correct answers for using Snowpark with virtual warehouses.

upvoted 0 times

...

Bette

3 months ago

Yes, that's correct. Those actions indeed require a virtual warehouse to be started.

upvoted 0 times

...

Olive

3 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

4 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

2 months ago

D) Calling a Snowpark stored procedure to query the database with session, call () will start a virtual warehouse

upvoted 0 times

...

Jennifer

2 months ago

C) Transforming a DataFrame with methods like replace () will start a virtual warehouse

upvoted 0 times

...

Alida

3 months ago

B) Creating a DataFrame from a staged file with the read () method will start a virtual warehouse

upvoted 0 times

...

Lemuel

3 months ago

A) Creating a DataFrame from a table will start a virtual warehouse

upvoted 0 times

...