Answer: COPY

The correct answer is C (COPY) because when unloading data from a Snowflake table into a stage (either internal or external), the operation is performed using the COPY INTO <location> command. In the Query Profile, this appears as the COPY operator. While there was some initial confusion in the community discussion about whether COPY is considered a DML operation, the consensus (supported by upvoted comments and 67% community selection) confirms that COPY INTO is classified as a Data Manipulation Language (DML) operation in Snowflake and appears as such in query profiles. The other options are incorrect: INSERT (A) is for loading data into tables, UNLOAD (B) is not a Snowflake DML operator (COPY is used for unloading), and UPDATE (D) is for modifying existing records in tables.

Author: LeetQuiz Editorial Team