By default, which role can create resource monitors?
Correct Answer: A
The role that can by default create resource monitors in Snowflake is theACCOUNTADMINrole. Resource monitors are a crucial feature in Snowflake that allows administrators to track and control the consumption of compute resources, ensuring that usage stays within specified limits. The creation and management of resource monitors involve defining thresholds for credits usage, setting up notifications, and specifying actions to be taken when certain thresholds are exceeded. Given the significant impact that resource monitors can have on the operational aspects and billing of a Snowflake account, the capability to create and manage them is restricted to theACCOUNTADMINrole. This role has the broadest set of privileges in Snowflake, including the ability to manage all aspects of the account, such as users, roles, warehouses, databases, and resource monitors, among others. References: * Snowflake Documentation on Resource Monitors: Managing Resource Monitors
Question 617
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Correct Answer: C,E
Question 618
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Correct Answer: C
Question 619
Which Snowflake data type is used to store JSON key value pairs?
Correct Answer: D
The VARIANT data type in Snowflake is used to store JSON key-value pairs along with other semi-structured data formats like AVRO, BSON, and XML. The VARIANT data type allows for flexible and dynamic data structures within a single column, accommodating complex and nested data. This data type is crucial for handling semi-structured data in Snowflake, enabling users to perform SQL operations on JSON objects and arrays directly. Reference: Snowflake Documentation: Semi-structured Data Types
Question 620
Which activities are included in the Cloud Sen/ices layer? (Select TWO).
Correct Answer: D,E
The Cloud Services layer in Snowflake includes activities such as user authentication and infrastructure management. This layer coordinates activities across Snowflake, including security enforcement, query compilation and optimization, and more
