Snowflake Exam DSA-C02 Topic 1 Question 33 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 33
Topic #: 1

Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?

ASequences

BTables

CExternal tables

DSecure UDFs

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

Geraldo

3 months ago

Hold on, are we sure the answer isn't E. My hopes and dreams? Cause that's definitely not shareable in Snowflake!

upvoted 0 times

...

Jamika

3 months ago

Okay, let me think this through. I reckon the answer is A. Sequences. I mean, who even uses those in Snowflake, am I right?

upvoted 0 times

...

Oneida

3 months ago

Ha! I bet the answer is C. External tables. Those things are like a black box, you can't really share them, can you?

upvoted 0 times

Colton

1 months ago

D) Secure UDFs

upvoted 0 times

...

Adrianna

1 months ago

C) External tables

upvoted 0 times

...

Billy

2 months ago

B) Tables

upvoted 0 times

...

Alease

2 months ago

A) Sequences

upvoted 0 times

...

Giuseppe

3 months ago

Hmm, this is a tricky one. I'm leaning towards B. Tables, since that's the most obvious choice for data sharing.

upvoted 0 times

...

Earleen

3 months ago

I'm pretty sure the answer is D. Secure UDFs, since those are specifically designed for secure data sharing within your account.

upvoted 0 times

Jenelle

2 months ago

That makes sense, it's important to keep certain data secure and only share it within your own account.

upvoted 0 times

...

Milly

2 months ago

Yes, Secure UDFs are not shared with other Snowflake accounts for security reasons.

upvoted 0 times

...

Stanton

2 months ago

I think you're right, Secure UDFs are designed for secure data sharing within your account.

upvoted 0 times

...

Ressie

4 months ago

I'm not sure, but I think it's C) External tables because they are not part of the database in your account.

upvoted 0 times

...

Paulina

4 months ago

I agree with Dana, Secure UDFs should not be shared for secure data sharing.

upvoted 0 times

...

Dana

4 months ago

I think the answer is D) Secure UDFs.

upvoted 0 times

...