SQL Warehouse Resource Monitor DDL

Question 1

ALTER RESOURCE MONITOR

Answer 1

Modifies the properties and triggers for an existing resource monitor.

Question 2

ALTER WAREHOUSE

Answer 2

Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse.

Question 3

CREATE RESOURCE MONITOR

Answer 3

Creates a new resource monitor.

Question 4

CREATE WAREHOUSE

Answer 4

Creates a newvirtual warehousein the system.

Question 5

DESCRIBE WAREHOUSE

Answer 5

Describes the warehouse.

Question 6

DROP RESOURCE MONITOR

Answer 6

Removes the specified resource monitor from the system.

Question 7

DROP WAREHOUSE

Answer 7

Removes the specified virtual warehouse from the system.

Question 8

SHOW RESOURCE MONITORS

Answer 8

Lists all the resource monitors in your account for which you have access privileges.

Question 9

SHOW WAREHOUSES

Answer 9

Lists all the warehouses in your account for which you have access privileges.

Question 10

USE WAREHOUSE

Answer 10

Specifies the active/current warehouse for the session.