SnowflakeSnowflake
DEA-C02 · Question #135
DEA-C02 Question #135: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.
Security and Governance
Question
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.)
Options
- AScalar SQL UDF - Snowflake allows the query to execute and returns NULL.
- BScalar SQL UDF - Snowflake blocks the query.
- CLogging & Event Tables - Snowflake allows the UDF to execute and captures log and event
- DLogging & Event Tables - Snowflake allows the UDF to execute but does not capture log and
- ELogging & Event Tables - Snowflake blocks the UDF but allows the statement calling the UDF to
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#User-Defined Functions (UDFs)#Dynamic Data Masking#Logging & Event Tables#Scalar SQL UDF behavior