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 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?

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

Off

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

Contribute your Thoughts:

Submit Cancel
Maybelle
5 months ago
Hold on, are we sure this is a real exam question? I feel like the options are a bit too straightforward. Where's the curveball?
upvoted 0 times
Antonette
4 months ago
D) The Engineer will be able to share the secure function with other accounts
upvoted 0 times
...
Abel
5 months ago
C) An error will be returned because only secure functions can be shared with inbound shares
upvoted 0 times
...
Galen
5 months ago
B) An error will be returned because only views and secure stored procedures can be shared
upvoted 0 times
...
Melissa
5 months ago
A) An error will be returned because the Engineer cannot share data that has already been shared
upvoted 0 times
...
...
Paris
6 months ago
Hmm, I think D is the right answer. The engineer should be able to share the secure function with other accounts if they have the necessary permissions.
upvoted 0 times
...
Nickie
6 months ago
I'm pretty sure the answer is B. Sharing a secure function with an outbound share is not allowed, only views and secure stored procedures can be shared.
upvoted 0 times
Joaquin
5 months ago
Yes, you're correct. Only views and secure stored procedures can be shared with outbound shares.
upvoted 0 times
...
Deandrea
5 months ago
I think you're right, the answer is B.
upvoted 0 times
...
...
Jerry
6 months ago
I'm not sure, but I think the answer is C. Only secure functions can be shared with inbound shares.
upvoted 0 times
...
Alyce
6 months ago
Option C sounds correct to me. A secure function can only be shared with inbound shares, not outbound ones.
upvoted 0 times
Naomi
5 months ago
Exactly. It's important to understand the limitations of sharing secure functions.
upvoted 0 times
...
Tony
5 months ago
So, the Data Engineer would receive an error if they tried to assign usage privileges on an outbound share.
upvoted 0 times
...
Deonna
6 months ago
Yes, you're right. Outbound shares cannot be assigned usage privileges on a secure function.
upvoted 0 times
...
Val
6 months ago
I think option C is correct. Secure functions can only be shared with inbound shares.
upvoted 0 times
...
...
Tenesha
6 months 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
6 months ago
I think the answer is A. The Engineer cannot share data that has already been shared.
upvoted 0 times
...

Save Cancel