SnowPro Core Certification — Question 517

Which command should a Snowflake user execute to load data into a table?

Answer options

• A. copy into mytable purge_mode = TRUE;
• B. copy into mytable from @my_int_stage;
• C. copy into mytable file_format = (format_name);
• D. copy into mytable validation = ‘RETURN_ERRORS’;

Correct answer: B

Explanation

The correct command for loading data into a table in Snowflake is option B, as it specifies the source stage from which to pull the data. The other options either specify parameters or settings that do not directly load data, making them unsuitable for this task.