Which statement is true about running tasks in Snowflake?
Correct Answer: B
In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.
Question 712
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Correct Answer: A,D
Snowflake supports the VARIANT and ARRAY data types for semi-structured data. VARIANT can store values of any other type, including OBJECT and ARRAY, making it suitable for semi-structured data formats like JSON. ARRAY is used to store an ordered list of elements
Question 713
Which Snowflake layer is associated with virtual warehouses?
Correct Answer: B
The layer of Snowflake's architecture associated with virtual warehouses is the Query Processing layer. Virtual warehouses in Snowflake are dedicated compute clusters that execute SQL queries against the stored data. This layer is responsible for the entire query execution process, including parsing, optimization, and the actual computation. It operates independently of the storage layer, enabling Snowflake to scale compute and storage resources separately for efficiency and cost-effectiveness. References: * Snowflake Documentation: Snowflake Architecture
Question 714
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately". What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Correct Answer: B
In the provided exhibit, Warehouse 2 is under Resource Monitor 2, which has a credit quota of 1000 credits. However, it's important to note that warehouses can also draw from the account-level resource monitor if they consume their dedicated monitor's quota. In this exhibit, Resource Monitor 1 is set for the account with a credit quota of 500 credits. The exhibit does not clearly show whether Warehouse 2 is also subject to the account-level Resource Monitor 1, but if we assume the typical case where all warehouses can draw from the account-level monitor, the maximum limit of credits Warehouse 2 can consume would be the sum of its dedicated resource monitor (Resource Monitor 2) and the account-level resource monitor (Resource Monitor 1). Thus, Warehouse 2 can consume: * 1000 credits from Resource Monitor 2 * 500 credits from Resource Monitor 1 (if applicable) This gives a total of 1500 credits. Therefore, the maximum credit limit that Warehouse 2 can consume, taking into account the possibility of the account-level monitor's contribution, would be 1500 credits. However, without explicit confirmation that Warehouse 2 can use credits from Resource Monitor 1, one would default to the specific resource monitor assigned to the warehouse, which is 1000 credits. Given the available options, the closest and most accurate answer is B. 1500, as it represents the sum of credits from both monitors that potentially apply to Warehouse 2. References: * Snowflake Documentation on Resource Monitors: Managing Resource Monitors
Question 715
Which SQL command can be used to verify the privileges that are granted to a role?
