ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam
Go to Exam

Exam SnowPro Advanced Data Engineer topic 1 question 105 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 105
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

A Data Engineer has created a scalar User-Defined Function (UDF) that contains a SELECT statement based on a projection constraint column. The Engineer notices that the UDF behaves differently depending on how it is being used.

What are the expected behaviors of the UDF for the named context? (Choose two.)

  • A. Scalar SQL UDF - Snowflake allows the query to execute and returns NULL.
  • B. Scalar SQL UDF - Snowflake blocks the query.
  • C. Logging & Event Tables - Snowflake allows the UDF to execute and captures log and event details.
  • D. Logging & Event Tables - Snowflake allows the UDF to execute but does not capture log and event details.
  • E. Logging & Event Tables - Snowflake blocks the UDF but allows the statement calling the UDF to run to support logging requirements.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by KeylorCR at Aug. 3, 2025, 7:50 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
KeylorCR
1 week, 6 days ago
Selected Answer: BD
https://docs.snowflake.com/en/user-guide/projection-policies#label-projection-constraint-udfs
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel