Snowpro Core · Free Practice Question Medium

Question 19

The COPY command allows the following options for selecting files for loading data from a stage. Select all that apply.
  • A Load files that match a pattern.
  • B Load specific files by providing exact file names.
  • C Load all files in a specific path.
Reveal correct answers

Correct answers: A, B, C

Explanation

All of these options are correct. You can load by providing exact file names, load all files from a specific path, or load files that match a pattern. https://docs.snowflake.com/en/user-guide/data-load-considerations-load#options-for-selecting-staged-data-files

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need