Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References: Snowflake Documentation on Resource Monitors
Top of Form
Question 2
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Options:
A.
Account
B.
Database
C.
Schema
D.
Table
Answer:
A
Explanation:
Explanation:
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter is set at the account level. This parameter determines the minimum number of days Snowflake retains historical data for Time Travel operations
Question 3
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Options:
A.
OWNERSHIP
B.
MODIFY
C.
CREATE
D.
USAGE
Answer:
A
Explanation:
Explanation:
To see the definition of a secure view in Snowflake, the minimum privilege required is OWNERSHIP of the view. Ownership grants the ability to view the definition as well as to modify or drop the view. Secure views are designed to protect sensitive data, and thus the definition of these views is restricted to users with sufficient privileges to ensure data security.