Which file functions are non-deterministic? (Choose two.)
Which file functions are non-deterministic? (Choose two.)
Non-deterministic file functions are those that can produce different outcomes when called with the same input. BUILD_SCOPED_FILE_URL is non-deterministic because it encodes the URL which can change depending on the context or the time it is generated. GET_PRESIGNED_URL is also non-deterministic because it generates URLs with temporary credentials that change with each request.
AD BUILD_SCOPED_FILE_URL encodes the URL. GET_PRESIGNED_URL adds credentials to the URL. These are both non-deterministic.
Correct
correct answer - BD https://docs.snowflake.com/en/sql-reference/functions-file GET_PRESIGNED_URL and BUILD_SCOPED_FILE_URL are non-deterministic functions; the others are deterministic.
Sorry, AD are correct