SnowPro Core Certification — Question 623

What is the recommended approach for unloading data to a cloud storage location from Snowflake?

Answer options

• A. Use a third-party tool to unload the data to cloud storage.
• B. Unload the data directly to the cloud storage location.
• C. Unload the data to a local file system, then upload it to cloud storage.
• D. Unload the data to a user stage, then upload the data to cloud storage

Correct answer: B

Explanation

The correct answer is B because Snowflake supports unloading data directly to cloud storage, which is efficient and minimizes the need for additional steps. Options A, C, and D are less efficient as they involve unnecessary intermediate steps or third-party tools, which can complicate the process and increase the chance of errors.