Snowflake
ADA-C01 · Question #4
ADA-C01 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads. How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?
Options
- AThere should be another 2XL warehouse deployed to handle a portion of the load queries.
- BThe 2XL warehouse should be changed to 4XL to increase the number of threads available for
- CThe warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster
- DThe INSERTS should be converted to several tables to avoid contention on large tables that
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-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.