SnowPro Core Certification — Question 1223

If a query is being used to unload a 1 TB table into a stage, which DML operator will be shown in the Query Profile?

Answer options

• A. INSERT
• B. UNLOAD
• C. COPY
• D. UPDATE

Correct answer: C

Explanation

The correct answer is C, COPY, because this operator is utilized to transfer data from a source to a destination, such as unloading data into a stage. The other options are not applicable: INSERT adds data to a table, UNLOAD is a command but not a DML operator, and UPDATE modifies existing records.