Exam SOL-C01 Topic 1 Question 271 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 271
Topic #: 1
You have a table 'DOCUMENT STORE' with a column 'FILE CONTENT' of type BINARY containing PDF files. You want to extract text from these PDFs using 'PARSE DOCUMENT and store the extracted text along with the file name in a new table 'EXTRACTED TEXT. Which of the following code snippets correctly implements this, assuming you have a virtual warehouse named
'COMPUTE WH'?

Suggested Answer: B Vote an answer

Option B is correct because PARSE_DOCUMENT expects a VARCHAR as input, representing the file content. The TO_VARCHAR function converts the BINARY data to a VARCHAR. Option A will cause an error because PARSE DOCUMENT cannot directly process BINARY data. Option C's additional 'PDF' parameter is not the correct syntax. PARSE_DOCUMENT infers file type based on content, unless provided through URL of stage. TO_BINARY is not required here as already stored as binary. OBJECT CONSTRUCT is not the right way, here, but still will expect VARCHAR file content.

by Sigrid at Nov 16, 2025, 12:41 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10