DEA-C02 · Question #38
A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation pr
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process. The average file size is 300-500 MB. The Engineer needs to ensure that Snowpipe is performant while minimizing costs. How can this be achieved?
Options
- AIncrease the size of the virtual warehouse used by Snowpipe.
- BSplit the files before loading them and set the SIZE_LIMIT option to 250 MB.
- CChange the file compression size and increase the frequency of the Snowpipe loads.
- DDecrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 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.