SnowPro Core Certification — Question 556

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 is D, as Java User-Defined Functions (UDFs) can be used to process the content of PDF files in Snowflake. The FLATTEN function is used for normalizing semi-structured data, while Window functions are for analytical computations and HyperLogLog (HLL) is specifically for approximate counting. None of these functions can directly extract content from PDF files.