ARA-C01 · Question #105
ARA-C01 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables. The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database. What step can be taken to improve the pruning of the reporting tables?
Options
- AEliminate the use of Snowpipe and load the files into internal stages using PUT commands.
- BIncrease the size of the virtual warehouse to a size 5X-Large.
- CUse an ORDER BY <cluster_key (s) > command to load the reporting tables.
- DCreate larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-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.