Snowflake Exam DSA-C02 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%

1 months 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

10 days ago

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

upvoted 0 times

...

Brendan

16 days ago

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

upvoted 0 times

...

Ryan

23 days ago

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

upvoted 0 times

...

Dannette

1 months ago

I think the correct steps are in option C.

upvoted 0 times

...

1 months 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 months 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 months 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

...