nerdexam
Snowflake

SOL-C01 · Question #193

A company stores unstructured text data (PDFs, DOCX) in an external stage (AWS S3). They want to use Snowflake Cortex's PARSE DOCUMENT function to extract specific information, but are encountering pe

Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #193. The question stem and answer options stay visible for context.

Querying and Performance

Question

A company stores unstructured text data (PDFs, DOCX) in an external stage (AWS S3). They want to use Snowflake Cortex's PARSE DOCUMENT function to extract specific information, but are encountering performance issues and high costs. Which of the following strategies could optimize performance and reduce costs when using PARSE DOCUMENT in this scenario?

Options

  • AIncrease the size of the virtual warehouse used for processing, even if it means paying for larger
  • BPre-process the documents to remove irrelevant sections (e.g., boilerplate text, headers, footers)
  • CUtilize Snowflake's caching mechanism by storing parsed results in a separate table and
  • DReduce the number of documents being processed in a single batch to minimize memory
  • EImplement a robust error handling mechanism to prevent processing from halting due to

Unlock SOL-C01 to see the answer

You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#PARSE DOCUMENT#Performance Tuning#Cost Optimization#Unstructured Data Processing
Full SOL-C01 Practice