How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Correct Answer: D
To monitor updates, such as SCIM API requests sent to Snowflake by the identity provider, an administrator can use the REST EVENT HISTORY feature. This feature allows administrators to query historical data about REST API calls made to Snowflake, including those related to user and role management through SCIM (System for Cross-domain Identity Management). The REST EVENT HISTORY table function returns information about REST API calls made over a specified period. It is particularly useful for auditing and monitoring purposes, especially when integrating Snowflake with third-party identity providers that use SCIM for automated user provisioning and deprovisioning. An example query to check for SCIM API requests might look like this: SELECT * FROM TABLE(information_schema.rest_event_history(date_range_start=>dateadd('hours',-1,current_timestamp()))) WHERE request_type = 'SCIM'; This query returns details on SCIM API requests made in the last hour, including the request type, the identity provider's details, and the outcome of each request.
Question 697
When should a multi-cluster virtual warehouse be used in Snowflake?
Correct Answer: A
A multi-cluster virtual warehouse in Snowflake is designed to handle high concurrency and workload demands by allowing multiple clusters of compute resources to operate simultaneously. The correct scenario to use a multi-cluster virtual warehouse is: * A. When queuing is delaying query execution on the warehouse: Multi-cluster warehouses are ideal when the demand for compute resources exceeds the capacity of a single cluster, leading to query queuing. By enabling additional clusters, you can distribute the workload across multiple compute clusters, thereby reducing queuing and improving query performance. This is especially useful in scenarios with fluctuating workloads or where it's critical to maintain low response times for a large number of concurrent queries. References: * Snowflake Documentation: Multi-Cluster Warehouses at Snowflake Documentation
Question 698
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Correct Answer: B
In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a sizeSmall virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2. Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 699
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Correct Answer: D
Question 700
By definition, a secure view is exposed only to users with what privilege?
