I think it's ambiguous question
B or D
It depends on the data source
COPY unloads the data from table into stage
PUT uploads a file from local file system into a stage
https://docs.snowflake.com/en/user-guide/data-unload-overview
https://docs.snowflake.com/en/sql-reference/sql/put
Its not PUT. The question is about loading data (i.e., rows). Not placing FILES. If the questions is about Unloading Data Files then its PUT. Its just Data Load, which means row transfer. So its COPY
PUT command is for uploading the files from local system to cloud environment (snowflake internal stages).
GET command is for unload the files from cloud environment (snowflake internal stages) to local system.
COPY INTO is used to load data into a Snowflake table
Answer is D
We need 'PUT' to uploads data files from a local directory/folder into Internal Stage;
Then we can use 'COPY INTO' command to load data into a table from the staged files
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#types-of-internal-stages
If the question was "Which command can be used to UNLOAD ..." then is correct copy, but loading on stage means that You are loading external data, so is correct D
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
halol
Highly Voted 2 years agonexerSnow
Most Recent 6 months, 4 weeks ago_yyukta
9 months, 3 weeks ago0e504b5
10 months, 2 weeks agoHeetec
1 year, 1 month agoromega2
1 year, 2 months agoRajivnb
1 year, 2 months agojackjack123
1 year, 4 months agoMultiCloudIronMan
1 year, 4 months agoSatyamKishore
1 year, 7 months agodmitriypo
1 year, 7 months agolearner2023
1 year, 8 months agoRajivnb
1 year, 4 months agolordchao
1 year, 8 months agoAkexS
1 year, 4 months agoEmiB
1 year, 9 months agoppsingh001
1 year, 10 months agoGeera
1 year, 11 months agoBigDataBB
1 year, 11 months agoGeera
1 year, 11 months ago