ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 435 - SnowPro Core discussion

Report
Export

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

A.

ACCESS_HISTORY

Answers
A.

ACCESS_HISTORY

B.

LOAD_HISTORY

Answers
B.

LOAD_HISTORY

C.

QUERY_HISTORY

Answers
C.

QUERY_HISTORY

D.

REST EVENT HISTORY

Answers
D.

REST EVENT HISTORY

Suggested answer: D

Explanation:

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.

Show Answer
asked 29/10/2024
Darren Bajada
46 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms