Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake DSA-C02 Exam - Topic 1 Question 33 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 33
Topic #: 1
[All DSA-C02 Questions]

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

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Tayna
4 months ago
Secure UDFs are shareable, just not Sequences!
upvoted 0 times
...
Jaleesa
4 months ago
Yup, only Tables and External tables can be shared.
upvoted 0 times
...
Vashti
4 months ago
Wait, are you sure about that? I thought you could share everything.
upvoted 0 times
...
Brande
5 months ago
Totally agree, Sequences are off-limits!
upvoted 0 times
...
Rima
5 months ago
You can't share Sequences with other accounts.
upvoted 0 times
...
Aretha
5 months ago
I’m a bit confused; I thought secure UDFs were shareable too, but maybe they have restrictions like sequences?
upvoted 0 times
...
Catarina
5 months ago
I feel like tables and external tables are definitely shareable, but sequences seem like the odd one out.
upvoted 0 times
...
Earlean
5 months ago
I remember practicing a similar question, and I think secure UDFs might also be restricted from sharing.
upvoted 0 times
...
Edwin
5 months ago
I think we discussed that sequences can't be shared, but I'm not entirely sure if that's the only one.
upvoted 0 times
...
Tamra
5 months ago
This is a tricky one, but I think I've got it. The question is asking about what you can't share with Secure Data Sharing, so the answer must be A. Sequences can't be shared across accounts, but tables, external tables, and secure UDFs can.
upvoted 0 times
...
Audry
5 months ago
I'm a little unsure about this one. I know Secure Data Sharing is all about controlling access to data, but I can't quite remember the specifics of what can and can't be shared. I'll have to review my notes before answering.
upvoted 0 times
...
Carolynn
5 months ago
Okay, I've got this. Secure Data Sharing doesn't let you share external tables or secure UDFs, so the answer must be C and D. Tables and sequences can be shared, so those aren't the right options.
upvoted 0 times
...
Cammy
6 months ago
Hmm, I'm a bit confused on this one. I know Secure Data Sharing allows you to share certain objects, but I'm not sure which ones are excluded. I'll have to think this through carefully.
upvoted 0 times
...
Francis
6 months ago
I'm pretty sure this is asking about the limitations of Secure Data Sharing in Snowflake. I think the answer is Sequences, since those can't be shared across accounts.
upvoted 0 times
...
Geraldo
10 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
10 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
10 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
9 months ago
D) Secure UDFs
upvoted 0 times
...
Adrianna
9 months ago
C) External tables
upvoted 0 times
...
Billy
9 months ago
B) Tables
upvoted 0 times
...
Alease
10 months ago
A) Sequences
upvoted 0 times
...
...
Giuseppe
10 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
11 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
9 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
9 months ago
Yes, Secure UDFs are not shared with other Snowflake accounts for security reasons.
upvoted 0 times
...
Stanton
10 months ago
I think you're right, Secure UDFs are designed for secure data sharing within your account.
upvoted 0 times
...
...
Ressie
12 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
12 months ago
I agree with Dana, Secure UDFs should not be shared for secure data sharing.
upvoted 0 times
...
Dana
12 months ago
I think the answer is D) Secure UDFs.
upvoted 0 times
...

Save Cancel