Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ADA-C01 Topic 1 Question 15 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 15
Topic #: 1
[All ADA-C01 Questions]

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?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Margart
8 hours ago
The correct answer is C. Using a multi-cluster SMALL or XSMALL warehouse will likely provide better concurrency and cost savings than a single large warehouse.
upvoted 0 times
...
Alisha
2 days ago
I disagree with Elden. I believe option C is the way to go. Configuring the warehouse as a multi-cluster warehouse can handle parallel load queries more efficiently.
upvoted 0 times
...
Elden
8 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
...

Save Cancel