SnowPro Advanced: Data Engineer — Question 91

A Data Engineer is using a Snowflake Standard edition and has an external function in schema A, a view in schema B, and then creates a SHARE and adds the view to the SHARE as follows:

create secure view B.my_shared_view as select A.my_external_function(x) ...; create share things_to_share; grant select on view my_shared_view to share things_to_share;

What will be true about this command?

Answer options

• A. The external function will not be supported in the view.
• B. The external function will not be supported in the share.
• C. The external function will not be supported in the schema cross-reference.
• D. The external function is not supported in the Standard edition.

Correct answer: B

Explanation

The correct answer is B because in Snowflake, when sharing a view that depends on an external function, the external function cannot be executed through the SHARE. Options A and C are incorrect as they misrepresent the context of the view and schema references. Option D is also incorrect because the external function can be used in the Standard edition but not shared.