An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
1. There will be 50-100 concurrent users running reports
2. Minimize costs based on the number of active users at a given time
3. The virtual warehouse should suspend and resume automatically based on user activity
Which configuration will meet these requirements?

• A. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = false;
• B. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  auto_suspend = 60
  auto_resume = true;
• C. create or replace warehouse reporting_wh
  warehouse_size = medium
  auto_suspend = 600
  auto_resume = true;
• D. create or replace warehouse reporting_wh
  warehouse_size = medium
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = true;

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

• A. Queries executed within a given transaction see that transaction's uncommitted changes.
• B. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
• C. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
• D. Transaction locking in Snowflake is enforced exclusively at the row and table levels.

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?

• A. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• B. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
• C. There should be another 2XL warehouse deployed to handle a portion of the load queries.
• D. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

• A. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
• B. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
• C. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
• D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

• A. Create views over the incoming shared database and apply the desired RBAC onto these views.
• B. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
• C. Individually grant imported privileges onto the schema in the share.
• D. Apply RBAC directly onto the partner's shared secure views.