SOL-C01 Question #176: Real Exam Question with Answer & Explanation

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

Explanation

Option C is the most appropriate because it leverages Snowpipe's auto-ingest feature using event notifications. Snowpipe automatically tracks which files have already been loaded, preventing reprocessing. Using a virtual warehouse in the 'COPY INTO' statement ensures that the data is loaded with the specified compute resources.

No community discussion yet for this question.