Snowflake Exam DSA-C02 Topic 1 Question 13 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 13
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 Kati at Mar 08, 2024, 10:09 AM

Limited Time Offer

25%

7 months ago

I think the correct steps are in option C.

upvoted 0 times

...