ExamGecko
Question list
Search
Search

List of questions

Search

Question 75 - DEA-C01 discussion

Report
Export

Data Engineer Loading File named snowdata.tsv in the /datadir directory from his local machine to Snowflake stage and try to prefix the file with a folder named tablestage, please mark the correct command which helps him to load the files data into snowflake internal Table stage?

A.
put file://c:\datadir\snowdata.tsv @~/tablestage;
Answers
A.
put file://c:\datadir\snowdata.tsv @~/tablestage;
B.
put file://c:\datadir\snowdata.tsv @%tablestage;
Answers
B.
put file://c:\datadir\snowdata.tsv @%tablestage;
C.
put file://c:\datadir\snowdata.tsv @tablestage;
Answers
C.
put file://c:\datadir\snowdata.tsv @tablestage;
D.
put file:///datadir/snowdata.tsv @%tablestage;
Answers
D.
put file:///datadir/snowdata.tsv @%tablestage;
Suggested answer: B

Explanation:

Execute PUT to upload (stage) local data files into an internal stage.

@% character combination identifies a table stage.

asked 23/09/2024
Asif Ibrahim
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first