Answer: BUILD_SCOPED_FILE_URL, GET_PRESIGNED_URL

The question asks for two non-deterministic file functions. According to Snowflake documentation and the community discussion consensus, BUILD_SCOPED_FILE_URL (A) and GET_PRESIGNED_URL (D) are non-deterministic. BUILD_SCOPED_FILE_URL encodes the URL with scoped access, making it non-deterministic as it generates different encoded URLs. GET_PRESIGNED_URL adds time-limited credentials to the URL, which changes with each call, making it non-deterministic. The other options (B, C, E) are deterministic functions: BUILD_STAGE_FILE_URL constructs a consistent URL path, GET_ABSOLUTE_PATH returns a fixed absolute path, and GET_RELATIVE_PATH returns a fixed relative path, none of which involve variable elements like encoding or credentials. The community discussion shows strong consensus for AD, with the highest upvoted comment (6 upvotes) confirming this, while an alternative suggestion of BD was corrected in a follow-up comment.

Author: LeetQuiz Editorial Team