Snowflake DSA-C02 Exam - Topic 1 Question 39 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 39
Topic #: 1

Mark the correct steps for saving the contents of a DataFrame to a Snowflake table as part of Moving Data from Spark to Snowflake?

AStep 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter.
Step 2.Specify SNOWFLAKE_SOURCE_NAME using the NAME() method.
Step 3.Use the dbtable option to specify the table to which data is written.
Step 4.Specify the connector options using either the option() or options() method.
Step 5.Use the save() method to specify the save mode for the content.

BStep 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter.
Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.
Step 3.Specify the connector options using either the option() or options() method.
Step 4.Use the dbtable option to specify the table to which data is written.
Step 5.Use the save() method to specify the save mode for the content.

CStep 1.Use the write() method of the DataFrame to construct a DataFrameWriter.
Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.
Step 3.Specify the connector options using either the option() or options() method.
Step 4.Use the dbtable option to specify the table to which data is written.
Step 5.Use the mode() method to specify the save mode for the content.
(Correct)

DStep 1.Use the writer() method of the DataFrame to construct a DataFrameWriter.
Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method.
Step 3.Use the dbtable option to specify the table to which data is written.
Step 4.Specify the connector options using either the option() or options() method.
Step 5.Use the save() method to specify the save mode for the content.

Show Suggested Answer

Suggested Answer: C

Moving Data from Spark to Snowflake

The steps for saving the contents of a DataFrame to a Snowflake table are similar to writing from Snowflake to Spark:

1. Use the write() method of the DataFrame to construct a DataFrameWriter.

2. Specify SNOWFLAKE_SOURCE_NAME using the format() method.

3. Specify the connector options using either the option() or options() method.

4. Use the dbtable option to specify the table to which data is written.

5. Use the mode() method to specify the save mode for the content.

Examples

1. df.write

2. .format(SNOWFLAKE_SOURCE_NAME)

3. .options(sfOptions)

4. .option('dbtable', 't2')

5. .mode(SaveMode.Overwrite)

6. .save()

by Terry at Mar 05, 2025, 12:17 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blair

4 months ago

I’m surprised there’s no mention of authentication steps!

upvoted 0 times

...

Georgiana

4 months ago

Wait, isn't it write() instead of PUT()?

upvoted 0 times

...

Gianna

4 months ago

I think option() is the right way to go for connector options.

upvoted 0 times

...

Jennie

4 months ago

Totally agree, C looks correct to me!

upvoted 0 times

...

Colette

5 months ago

Step 3 should definitely be dbtable!

upvoted 0 times

...

Virgie

5 months ago

I feel like the save() method is definitely involved, but I can't recall if it should come before or after specifying the table. This is tricky!

upvoted 0 times

...

Dana

5 months ago

I practiced a similar question where we had to specify connector options first. I think that might be a common mistake to watch out for.

upvoted 0 times

...

Krystal

5 months ago

I’m a bit unsure about the order of the steps. I think specifying the dbtable option comes after setting the source name, but I could be wrong.

upvoted 0 times

...

Annamae

6 months ago

I remember we discussed the importance of using the write() method instead of PUT() for saving DataFrames. That might be a key point here.

upvoted 0 times

...

Candida

6 months ago

Ah, I remember covering this in class. The correct sequence is write(), format(), option(), dbtable, and mode(). I feel confident I can apply this to the exam question.

upvoted 0 times

...

Goldie

6 months ago

Okay, I see the key steps - use the write() method, specify the Snowflake source, set the table name and options, and choose the save mode. I think I can work through this step-by-step.

upvoted 0 times

...

Ruby

6 months ago

Hmm, I'm a bit unsure about the exact method names and order here. I'll need to review the Spark-Snowflake connector documentation to make sure I get this right.

upvoted 0 times

...

Lizette

6 months ago

This looks like a straightforward DataFrame to Snowflake table write operation. I think I've got the steps down, but I'll double-check the details.

upvoted 0 times

...

Meaghan

1 year ago

That's true, option C is the only one that mentions the correct method for specifying the save mode.

upvoted 0 times

...

Dannette

1 year ago

Option A doesn't specify the correct method for specifying the save mode.

upvoted 0 times

...

Frederica

1 year ago

I'm not sure, I think option A could also be correct.

upvoted 0 times

...

Meaghan

1 year ago

I agree with Dannette, option C seems to be the right one.

upvoted 0 times

...

Nelida

1 year ago

Snowflake, huh? I wonder if they have a special 'snow mode' for writing data. Maybe it'll make everything look like it's covered in a layer of frost. Wouldn't that be cool?

upvoted 0 times

...

Laticia

1 year ago

Ah, yes, the good old Spark to Snowflake data migration. I've done this dance a few times before. Option C seems to have all the right steps.

upvoted 0 times

Jennie

1 year ago

User 3: Option C is the way to go for saving DataFrame contents to a Snowflake table.

upvoted 0 times

...

Brendan

1 year ago

User 2: Yeah, Option C has the right steps for moving data from Spark to Snowflake.

upvoted 0 times

...

Ryan

1 year ago

User 1: I agree, Option C is the correct one for saving DataFrame to Snowflake table.

upvoted 0 times

...

Dannette

1 year ago

I think the correct steps are in option C.

upvoted 0 times

...

Vinnie

1 year ago

Hmm, let's see... I think option C looks the most straightforward. Plus, it has the word 'correct' in it, so it must be right. Easy peasy!

upvoted 0 times

Trina

1 year ago

User1: Let's go with option C then, it seems like the best choice.

upvoted 0 times

...

Gregg

1 year ago

User3: Definitely, the word 'correct' in it is a good sign.

upvoted 0 times

...

Maynard

1 year ago

User2: Yeah, it looks like the most straightforward option.

upvoted 0 times

...

Ozell

1 year ago

User1: I agree, option C seems to be the right choice.

upvoted 0 times

...

Ma

1 year ago

Wait, did we just get a question about saving data to Snowflake? I thought this was an exam on Spark, not a winter sports competition!

upvoted 0 times

Chi

1 year ago

C) Step 1.Use the write() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method. Step 3.Specify the connector options using either the option() or options() method. Step 4.Use the dbtable option to specify the table to which data is written. Step 5.Use the mode() method to specify the save mode for the content. (Correct)

upvoted 0 times

...

Jerlene

1 year ago

A) Step 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the NAME() method. Step 3.Use the dbtable option to specify the table to which data is written. Step 4.Specify the connector options using either the option() or options() method. Step 5.Use the save() method to specify the save mode for the content.

upvoted 0 times

...