ADA-C01 · Question #31
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant. An application with the accountant role should use this warehouse…
The correct answer is C. MONITOR D. USAGE. The MONITOR privilege on a warehouse grants the ability to view the warehouse usage and performance metrics, such as the number of credits consumed, the average and maximum run time, and the number of queries executed. The USAGE privilege on a warehouse grants the ability to…
Question
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant. An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse. What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
Options
- AOPERATE
- BMODIFY
- CMONITOR
- DUSAGE
- EOWNERSHIP
How the community answered
(59 responses)- A8% (5)
- B3% (2)
- C85% (50)
- E3% (2)
Explanation
The MONITOR privilege on a warehouse grants the ability to view the warehouse usage and performance metrics, such as the number of credits consumed, the average and maximum run time, and the number of queries executed. The USAGE privilege on a warehouse grants the ability to use the warehouse to execute queries and load data. Therefore, the minimal privileges on the warehouse that should be granted to the role to meet the requirements for the application are MONITOR and USAGE.
Topics
Community Discussion
No community discussion yet for this question.