SNOW-DEA Question 19

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 2

  RETURNS NULL ON NULL INPUT (or its synonym STRICT) will not call the UDF if any input is null. Instead, a null value will always be returned for that row. Note that the UDF might still return null for non-null inputs. see: https://docs.snowflake.com/en/sql-reference/sql/create-function

• 2

  "return null on null input"

• Chose D7

  in the documentation, it says: RETURNS NULL ON NULL INPUT will not call the stored procedure if any input is null, so the statements inside the stored procedure will not be executed.