ExamGecko
Question list
Search
Search

Question 306 - SnowPro Core discussion

Report
Export

How does Snowflake handle the bulk unloading of data into single or multiple files?

A.
It assigns each unloaded data file a unique name.
Answers
A.
It assigns each unloaded data file a unique name.
B.
It uses the put command to download the data by default.
Answers
B.
It uses the put command to download the data by default.
C.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
Answers
C.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
D.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Answers
D.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Suggested answer: A

Explanation:

When unloading data, Snowflake assigns each file a unique name to ensure there is no overlap or confusion between files.This is part of the bulk unloading process where data is exported from Snowflake tables into flat files3.

asked 23/09/2024
Julius Nammeh
44 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first