Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 6 Topic 1 Discussion

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 6 Topic 1 Discussion

ADA-C02 Exam Topic 1 Question 6 Discussion:
Question #: 6
Topic #: 1

A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.

How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?


A.

There should be another 2XL warehouse deployed to handle a portion of the load queries.


B.

The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.


C.

The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.


D.

The INSERTs should be converted to several tables to avoid contention on large tables that slows down query processing.


Get Premium ADA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.