ExamGecko
Home / Snowflake / ARA-C01 / Practice Test 5
Ask Question

Snowflake ARA-C01 Practice Test 5

Add to Whishlist
00:00:00
Show Answer
Report Issue   Restart test

Question 1 / 2

An Architect needs to improve the performance of reports that pull data from multiple Snowflake tables, join, and then aggregate the data. Users access the reports using several dashboards. There are performance issues on Monday mornings between 9:00am-11:00am when many users check the sales reports.

The size of the group has increased from 4 to 8 users. Waiting times to refresh the dashboards has increased significantly. Currently this workload is being served by a virtual warehouse with the following parameters:

AUTO-RESUME = TRUE AUTO_SUSPEND = 60 SIZE = Medium

What is the MOST cost-effective way to increase the availability of the reports?

Become a Premium Member for full access
  Unlock Premium Member