DEA-C02 Question #122: Real Exam Question with Answer & Explanation

Question

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?

Options

• AThe external function will not be supported in the view.
• BThe external function will not be supported in the share.
• CThe external function will not be supported in the schema cross-reference.
• DThe external function is not supported in the Standard edition.

Explanation

Option B is correct because Snowflake does not support external functions in secure views that are added to a Data Share. When a consumer account accesses shared data, Snowflake cannot guarantee that the external service referenced by the external function is accessible from the consumer's context, so this combination is explicitly prohibited - the share creation or grant will fail.

Why the distractors are wrong:

• A is wrong because external functions are supported inside views (including secure views) within the same account - the issue only arises when that view is shared.
• C is wrong because cross-schema references (using schema A's external function inside schema B's view) are perfectly valid in Snowflake.
• D is wrong because external functions are available on Snowflake Standard edition - they are not an Enterprise-only feature.

Memory tip: Think "you can't SHARE what calls outside." Snowflake Data Sharing is designed to share data that lives entirely within Snowflake's storage boundary. External functions reach out to a third-party API, which breaks that boundary for the consumer - so Snowflake simply blocks it.

No community discussion yet for this question.