SnowPro Core Certification — Question 531

What is used to extract the content of PDF files stored in Snowflake stages?

Answer options

• A. FLATTEN function
• B. Window function
• C. HyperLogLog (HLL) function
• D. Java User-Defined Function (UDF)

Correct answer: D

Explanation

The correct answer, D, is a Java User-Defined Function (UDF), which allows for custom processing of PDF files in Snowflake. The other options, such as the FLATTEN function and Window function, do not have the capability to extract content from PDF files, while HyperLogLog (HLL) is used for approximate distinct count calculations.