Snowpro Core · Free Practice Question Easy
Question 10
What is the role required to query the TABLE_STORAGE_METRICS view from the account usage schema in Snowflake?
-
A
SECURITYADMIN
-
B
PUBLIC
-
C
ACCOUNTADMIN
-
D
SYSADMIN
Reveal correct answer
Correct answer: C
A.
This role focuses on managing security settings rather than accessing storage metrics.
B.
This is a default role with minimal privileges; it cannot access account-level storage metrics.
C.
To access detailed account usage information, including the TABLE_STORAGE_METRICS view, the ACCOUNTADMIN role is required. This role provides the necessary privileges for viewing comprehensive account-wide data.
D.
This role primarily manages database objects but doesn’t have the necessary permissions to access account-wide metrics.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
