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 1 year, 6 months agonexerSnow
Most Recent 1 month ago_yyukta
3 months, 4 weeks ago0e504b5
4 months, 3 weeks agoHeetec
7 months, 4 weeks agoromega2
8 months, 3 weeks agoRajivnb
9 months agojackjack123
10 months, 3 weeks agoMultiCloudIronMan
11 months, 1 week agoSatyamKishore
1 year, 1 month agodmitriypo
1 year, 1 month agolearner2023
1 year, 2 months agoRajivnb
11 months agolordchao
1 year, 2 months agoAkexS
10 months, 4 weeks agoEmiB
1 year, 3 months agoppsingh001
1 year, 4 months agoGeera
1 year, 5 months agoBigDataBB
1 year, 5 months agoGeera
1 year, 5 months ago