SnowPro Advanced: Architect — Question 106

An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must manually download the failed file and check for errors.

Which downloading method should the Architect recommend that requires the LEAST amount of operational overhead?

Answer options

• A. Use the Snowflake Connector for Python, connect to remote storage and download the file.
• B. Use the GET command in SnowSQL to retrieve the file.
• C. Use the GET command in Snowsight to retrieve the file.
• D. Use the Snowflake API endpoint and download the file.

Correct answer: B

Explanation

The correct answer is B, as using the GET command in SnowSQL is straightforward and requires minimal manual intervention, making it efficient for downloading failed files. Options A and D involve additional complexity with external connections and API calls, which add to operational overhead. Option C, while viable, is less commonly used than SnowSQL for such tasks.