Which privilege is required to use the search optimization service in Snowflake?
Correct Answer: D
Question 127
What happens when a virtual warehouse is resized?
Correct Answer: B
Question 128
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 129
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Correct Answer: D
Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process
Question 130
What is the default access of a securable object until other access is granted?
Correct Answer: A
In Snowflake, the default access level for any securable object (such as a table, view, or schema) is "No access" until explicit access is granted. This means that when an object is created, only the owner of the object and roles with the necessary privileges can access it. Other users or roles will not have any form of access to the object until it is explicitly granted. This design adheres to the principle of least privilege, ensuring that access to data is tightly controlled and that users and roles only have the access necessary for their functions. To grant access, the owner of the object or a role with the GRANT option can use the GRANT statement to provide specific privileges to other users or roles. For example, to grant SELECT access on a table to a specific role, you would use a command similar to: GRANT SELECT ON TABLE my_table TO ROLE my_role; Reference: Snowflake Documentation on Access Control (https://docs.snowflake.com/en/user-guide/security-access-control-overview.html)
