Snowflake Exam DEA-C01 Topic 2 Question 40 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 40
Topic #: 2

[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 Vincent at Dec 04, 2024, 09:09 AM

Limited Time Offer

25%

13 days ago

Option C sounds correct to me. A secure function can only be shared with inbound shares, not outbound ones.

upvoted 0 times

Deonna

5 days ago

Yes, you're right. Outbound shares cannot be assigned usage privileges on a secure function.

upvoted 0 times

...

Val

6 days ago

I think option C is correct. Secure functions can only be shared with inbound shares.

upvoted 0 times

...

Tenesha

18 days ago

I disagree, I believe the answer is D. The Engineer will be able to share the secure function with other accounts.

upvoted 0 times

...

Gianna

23 days ago

I think the answer is A. The Engineer cannot share data that has already been shared.

upvoted 0 times

...