SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 147


Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Show Answer
Correct Answer: D

To load data from a file located in an external stage into a table in Snowflake, the COPY command should be used. This command is specifically designed for bulk data loading operations, allowing data to be transferred efficiently from external sources into Snowflake tables.

Discussion

9 comments
Sign in to comment
MMT123764kOption: D
Nov 9, 2022

Correct answer Copy

sdnv89Option: D
Nov 19, 2022

copy into table

SV1122Option: D
Dec 26, 2022

GET does not support downloading files from external stages https://docs.snowflake.com/en/sql-reference/sql/get.html So the answer is COPY

NabilROption: A
Jan 10, 2023

Why not INSERT ?

EmiBOption: D
Mar 11, 2023

D - COPY INTO exactly

MultiCloudIronManOption: D
Jul 17, 2023

Correct

_yyuktaOption: D
Feb 25, 2024

D. COPY

pranaligOption: D
Jun 15, 2024

Correct Answer: D

Mallikharjuna452Option: D
Jul 19, 2024

COPY COMMAND