SnowPro Core Certification — Question 187

When unloading to a stage, which of the following is a recommended practice or approach?

Answer options

• A. Set SINGLE = TRUE for larger files.
• B. Use OBJECT_CONSTRUCT(*) when using Parquet.
• C. Avoid the use of the CAST function.
• D. Define an individual file format.

Correct answer: D

Explanation

Defining an individual file format is crucial for ensuring that the data is correctly interpreted and processed upon unloading. Options A and B may not be suitable for all situations, and avoiding the CAST function (Option C) does not necessarily contribute to best practices when unloading data.