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

16 days 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

...

Lemuel

18 days 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

...

1 months ago

Wait, is this a trick question? I'm going to go with B just to be safe. Snowflake is like a magical unicorn, you never know what's going to happen.

upvoted 0 times

Jess

15 days ago

User1: I think the correct steps are in option C.

upvoted 0 times

...

Jaime

20 days ago

User3: Yeah, I'm going with option C as well.

upvoted 0 times

...

Margurite

23 days ago

User2: I agree, option C looks like the right choice.

upvoted 0 times

...

Barney

24 days ago

User1: I think the correct steps are in option C.

upvoted 0 times

...

1 months ago

I think the correct steps are in option C.

upvoted 0 times

...