Snowflake Exam ADA-C01 Topic 1 Question 15 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 15
Topic #: 1

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?

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 parallel load queries.

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

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

Show Suggested Answer

Suggested Answer: D

The SIMULATED_DATA_SHARING_CONSUMER session parameter allows a data provider to test the integrity of secure views based on the account that is accessing that view2. By setting this parameter to the name of the consumer account, the data provider can query the secure view and see the results that a user in the consumer account will see2. This helps to ensure that sensitive data in a shared database is not exposed to unauthorized users1. The other options are not valid session parameters in Snowflake3

by Pete at Jun 03, 2024, 01:50 AM

Limited Time Offer

25%

22 days ago

I think option B is the best choice. Increasing the number of threads available for parallel load queries can help reduce costs and minimize load times.

upvoted 0 times

...