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. Reference: Snowflake Documentation on REST EVENT HISTORY (https://docs.snowflake.com/en/sql-reference/functions/rest_event_history.html)
Question 682
Which data type can be used for floating-point numbers without losing precision?
Correct Answer: D
In Snowflake, the DOUBLE data type is used for floating-point numbers and can represent a wide range of values without losing precision. This data type is ideal for storing numerical values that require decimal precision. Define the Column: When creating a table, specify the column with the DOUBLE data type to store floating-point numbers. CREATE TABLE example_table ( id INTEGER, value DOUBLE ); Insert Data: Insert floating-point numbers into the DOUBLE column. INSERT INTO example_table (id, value) VALUES (1, 123.456); Reference: Snowflake Documentation: Data Types Snowflake Documentation: Numeric Data Types
Question 683
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
Correct Answer: B,C,E
Question 684
Which features are included in Snowsight? (Select TWO)
Correct Answer: A,D
Question 685
What happens to the privileges granted to Snowflake system-defined roles?
Correct Answer: A
The privileges granted to Snowflake's system-defined roles cannot be revoked. System-defined roles, such as SYSADMIN, ACCOUNTADMIN, SECURITYADMIN, and others, come with a set of predefined privileges that are essential for the roles to function correctly within the Snowflake environment. These privileges are intrinsic to the roles and ensure that users assigned these roles can perform the necessary tasks and operations relevant to their responsibilities. The design of Snowflake's role-based access control (RBAC) model ensures that system-defined roles have a specific set of non-revocable privileges to maintain the security, integrity, and operational efficiency of the Snowflake environment. This approach prevents accidental or intentional modification of privileges that could disrupt the essential functions or compromise the security of the Snowflake account. References: * Snowflake Documentation on Access Control: Understanding Role-Based Access Control (RBAC)
