Snowflake Exam DEA-C01 Topic 1 Question 42 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 42
Topic #: 1

[All DEA-C01 Questions]

A secure function returns data coming through an inbound share

What will happen if a Data Engineer tries to assign usage privileges on this function to an outbound share?

AAn error will be returned because the Engineer cannot share data that has already been shared

BAn error will be returned because only views and secure stored procedures can be shared

CAn error will be returned because only secure functions can be shared with inbound shares

DThe Engineer will be able to share the secure function with other accounts

Show Suggested Answer

Suggested Answer: A

An error will be returned because the Engineer cannot share data that has already been shared. A secure function is a Snowflake function that can access data from an inbound share, which is a share that is created by another account and consumed by the current account. A secure function can only be shared with an inbound share, not an outbound share, which is a share that is created by the current account and shared with other accounts. This is to prevent data leakage or unauthorized access to the data from the inbound share.

by Franklyn at Jan 24, 2025, 08:23 PM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Julian

24 days ago

Wait, is this a trick question? I mean, who would try to share a secure function with an outbound share? That's like trying to share your secret diary with your nosy neighbor. Option C all the way!

upvoted 0 times

...

Hortencia

26 days ago

I think B) is incorrect because secure functions can be shared with inbound shares

upvoted 0 times

...

Mariann

26 days ago

I'm feeling lucky today, so I'm going to go with option D. The Engineer should be able to share the secure function with other accounts. What could go wrong, right? *wink wink*

upvoted 0 times

Xochitl

5 days ago

User 2: No, that's not right. An error will be returned because only secure functions can be shared with inbound shares.

upvoted 0 times

...

Leonor

8 days ago

User 1: I think option D is correct. The Engineer should be able to share the secure function with other accounts.

upvoted 0 times

...

Theron

1 months ago

I'm not sure, but I think C) could also be a possibility

upvoted 0 times

...

Jamie

1 months ago

Hmm, this is a tricky one. I'm going to have to go with option A - an error will be returned because you can't share data that's already been shared. It just doesn't seem right to be able to share a secure function with an outbound share.

upvoted 0 times

...

Rhea

1 months ago

I disagree, I believe the answer is D)

upvoted 0 times

...

Johnna

1 months ago

Option D seems a bit too easy. I'm going to go with option B - the Engineer can't share a secure function, only views and stored procedures can be shared.

upvoted 0 times

Emmett

3 days ago

I agree, it makes sense that only certain types of objects can be shared.

upvoted 0 times

...

Patti

12 days ago

Option B is correct. Secure functions cannot be shared, only views and stored procedures.

upvoted 0 times

...

Kaycee

14 days ago

Exactly, it's important to understand the limitations when sharing data in a secure environment.

upvoted 0 times

...

Leonora

17 days ago

I agree, sharing secure functions with outbound shares is not allowed.

upvoted 0 times

...

Benedict

17 days ago

So, the Data Engineer will receive an error if they try to assign usage privileges on the secure function to an outbound share.

upvoted 0 times

...

Dean

20 days ago

I think option B is correct. Views and stored procedures can be shared, not secure functions.

upvoted 0 times

...

Margart

1 months ago

I think option C is the correct answer. A secure function is designed to only share data with inbound shares, so trying to share it with an outbound share would result in an error.

upvoted 0 times

Lea

28 days ago

Yes, trying to assign usage privileges on a secure function to an outbound share would not be allowed.

upvoted 0 times

...

Christiane

1 months ago

I agree, option C seems to be the most logical choice.

upvoted 0 times

...

Bok

2 months ago

I think the answer is A)

upvoted 0 times

...