QuestionQ4

Manage and maintain database objects and virtual warehouses

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.

An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?

Choose two
Explanation

The USAGE privilege permits use of a virtual warehouse to execute queries; with auto-resume enabled, submitting a query automatically resumes it. The MONITOR privilege permits viewing warehouse usage statistics, including the information needed to track compute-credit consumption. Neither warehouse-state control nor configuration changes are required.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!