Chapter 10: Account and Resource Management Flashcards
When configuring a resource monitor, which of the following are actions that can be configured? (Choose all that apply.)
Notify
Suspend and Notify
Suspend Immediately and Notify
Stop
Which of the following statements are true regarding resource monitors? (Choose all that apply.)
Resource monitors cannot be deleted once they have been created.
If a resource monitor monitors a virtual warehouse, another resource monitor cannot monitor the same virtual warehouse.
Resource monitors can be configured to track multiple virtual warehouses.
A resource monitor can be created at an account level, which means that the monitor tracks the credit usage at the whole account level, including all virtual warehouses’ credit usage.
Only account administrators can create new resource monitors.
True or False: Resource monitors can be used to control credit usage for serverless services such as cloud services, Snowpipe, or Auto Clustering.
True
False
Which of the following privileges must be granted to other roles by the account administrator for other roles to see and modify resource monitors? (Choose all that apply.)
READ
MODIFY
MONITOR
WRITE
Which of the following are valid methods through which account administrators can receive notifications generated by resource monitors? (Choose all that apply.)
SQS notification
Snowflake web interface
Email
SMS notification
Which of the following can you use to view the last 365 days of the history of warehouse credit usage?
The WAREHOUSE_METERING_HISTORY view in the ACCOUNT_USAGE schema
The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
The WAREHOUSE_METERING_HISTORY table function in the INFORMATION_SCHEMA schema
The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema
Which of the following statements are true regarding the ACCOUNT_USAGE schema? (Choose all that apply.)
ACCOUNT_USAGE views can only have 7 days of history.
The data in ACCOUNT_USAGE views is real time.
The data in ACCOUNT_USAGE views can have a latency of 45 minutes up to 3 hours.
ACCOUNT_USAGE views can have 365 days of history.
Which of the following statements are true regarding the INFORMATION_SCHEMA schema? (Choose all that apply.)
Data in INFORMATION_SCHMEA has a latency of 3 hours.
Every database in Snowflake has an INFORMATION_SCHEMA schema.
Data in INFORMATION_SCHEMA is real time.
History retention of data in INFORMATION_SCHEMA varies from 7 days to 6 months.
INFORMATION_SCHEMA is a special schema found only under the Snowflake database.
True or False: INFORMATION_SCHEMA provides several table functions that can be used to return account-level storage, compute usage, login history, and query history.
True
False
You want to write a SQL query that shows successful and failed login attempts made in the last 10 minutes. Which of the following should you use?
ACCOUNT_USAGE.LOGIN_HISTORY view.
ACCOUNT_USAGE.ACCESS_HISTORY view.
The table function LOGIN_HISTORY in INFORMATION_SCHEMA.
It is not possible to view login attempts.
Snowflake releases new features or bug fixes at what frequency?
Daily
Weekly
Monthly
Yearly
Daily
When Snowflake releases new features or bug fixes, which accounts get the new software ahead of all other accounts?
Standard edition accounts
All Enterprise edition and above accounts
Business-critical accounts
Enterprise edition accounts that have opted for early access
