Câu 14: SnowPro Advanced Administrator ADA-C01

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?

1. A. There should be another 2XL warehouse deployed to handle a portion of the load queries.
2. B. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
3. C. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries. — đáp án hiện tại
4. D. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.