Try our Free Demo Practice Tests for Comprehensive ADA-C01 Exam Preparation

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed. 

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend andauto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run