Exam DEA-C02 Topic 1 Question 6 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 6
Topic #: 1
You need to unload data from a Snowflake table named 'CUSTOMER DATA to an AWS S3 bucket The data should be unloaded in Parquet format, partitioned by the 'CUSTOMER REGION' column, and automatically compressed with GZIP. Furthermore, you only want to unload customers whose 'REGISTRATION DATE is after '2023-01-01'. Which of the following 'COPY INTO' statement correctly achieves this?

Suggested Answer: E Vote an answer

The correct 'COPY INTO' statement requires using a named stage and a named file format. A subquery is used to filter the data based on the 'REGISTRATION_DATE. The 'PARTITION BY clause is used to partition the data by 'CUSTOMER REGION'. You must create a FILE FORMAT seperately and refer to it later. Other solutions have syntax errors, incorrect stage references, or incorrect ordering of clauses. Option 'A' doesn't use a stage nor it allows for a where condition. Option 'B' doesn't work since 'TYPE' and 'COMPRESSIONS are properties of a file format, not direct arguments to FILE_FORMAT. 'C' includes the 'TYPE and 'COMPRESSION' inline when this is not allowed. 'D' contains the same error with FILE FORMAT as 'C' and 'B' and does not use a stage.

by Jim at Jul 16, 2025, 03:04 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10