SnowPro Core Certification — Question 845

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

Answer options

• A. Use the RESULT_SCAN function.
• B. Create a CURSOR for the command.
• C. Put it in the FROM clause in brackets.
• D. Assign the command to RESULTSET.

Correct answer: A

Explanation

The correct answer is A, as the RESULT_SCAN function allows users to retrieve and process the results of previously executed statements. The other options do not provide a way to post-process the output of the SHOW FILE FORMATS command effectively.