SOL-C01 Question #196: Real Exam Question with Answer & Explanation

Question

You are using PARSE DOCUMENT on documents stored in an external stage. You notice that some documents are skipped during processing without any explicit error messages. Which of the following could be the MOST likely reason(s) for this behavior, and how would you address it?

Options

• AThe documents are too large. Increase the virtual warehouse size and set the MAX FILE SIZE
• BThe documents are in an unsupported format. Ensure that the documents are in a supported
• CThe virtual warehouse is being automatically suspended due to inactivity. Configure auto-resume
• DSnowflake encountered an internal error during processing and silently skipped the document.
• EThe documents do not contain any text. Verify that the documents actually contain readable text

Explanation

Option B is a common cause, where unsupported format and permissions are key things to consider and `VALIDATE' helps ensure data is valid. Option C is also correct, because virtual warehouse suspension can interrupt processing and specifying the warehouse ensures it's used. Option A, while relevant to performance, doesn't explain silent skipping unless the files grossly exceed limits. Option D is possible but less likely than B or C and harder to diagnose without specific error messages. Option E is less likely, because even if the content is not parseable, it still doesn't explain why document is skipped silently.

No community discussion yet for this question.