SOL-C01 · Question #176
You are loading data from a set of compressed (gzip) JSON files in an external stage named 'json_stage'. The target table is named raw_event' , and it has a single VARIANT column named 'event_data'. Y
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #176. The question stem and answer options stay visible for context.
Question
You are loading data from a set of compressed (gzip) JSON files in an external stage named 'json_stage'. The target table is named raw_event' , and it has a single VARIANT column named 'event_data'. You want to load the data using a virtual warehouse named 'LOAD WH'. You also need to ensure only new files added to the stage since the last load are processed and any pre- existing data is not reloaded. What combination of parameters and setup do you need to use to successfully accomplish this?
Options
- AUse the 'COPY INTO command with the NATCH_BY COLUMN_NAME option set to
- BUse the `COPY INTO command with the FILES = ('json_stage/ option, a warehouse clause,
- CUse the 'COPY INTO' command with a warehouse clause, enable snowpipe auto-ingest using
- DUse the 'COPY INTO' command with a warehouse clause, specifying the file format to handle gzip
- EUse the 'COPY INTO' command with a warehouse clause, specifying the file format to handle gzip
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.