Exam DEA-C02 Topic 1 Question 200 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 200
Topic #: 1
You have a directory table 'my_directory_table' pointing to a stage containing CSV files with headers. You need to query the directory table to find all files modified in the last 24 hours and load those CSV files using COPY INTO into a target table Assume the target table exists and has appropriate schema'. Which of the following SQL statements, or set of statements, will accomplish this efficiently? Note: Consider efficient file loading.

Suggested Answer: E Vote an answer

Option E is the most efficient way to load the files using 'COPY INTO' and the 'FILES' parameter. The 'FILES' parameter accepts a list of filenames to load. Option D is incorrect because the 'PATTERN' parameter expects a regular expression, not a concatenation of filenames. Options A, B, and C require more complex processing. Using subquery expression in the copy command is the best approach for filtering files based on directory table data.

by Phoebe at Jul 08, 2026, 01:52 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