Snowflake Exam DSA-C02 Topic 1 Question 33 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 33
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 Lashunda at Oct 24, 2024, 01:02 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Frank

1 months ago

The answer is C, no doubt. Though I'm honestly surprised they didn't include an option that involves throwing the data at the Snowflake server and hoping it sticks. That's how I usually do it.

upvoted 0 times

Cheryl

5 days ago

Haha, throwing data at the server and hoping it sticks sounds like a risky move!

upvoted 0 times

...

Veronique

7 days ago

I always go with the correct steps, C is the way to go.

upvoted 0 times

...

Lemuel

1 months ago

I'm going with C. Who needs step-by-step instructions when you've got the power of Spark? This is like a walk in the park... or a walk on the moon, in the case of Snowflake.

upvoted 0 times

...

Rasheeda

1 months ago

C is definitely the way to go. I've used this approach a bunch of times, it's rock solid. But hey, at least the other options don't involve using a ouija board to communicate with the Snowflake API, right?

upvoted 0 times