Free COF-C02 Exam Braindumps
SnowPro Core Questions 521–525 (page: 106)

Updated On: 10-Feb-2026

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

  1. ACCESS_HYSTORY
  2. LOAD_HYSTORY
  3. QUERY_HISTORY
  4. REST_EVENT_HISTORY

Answer(s): D



A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.

How will those object names be resolved during execution?

  1. Snowflake will resolve them according to the SEARCH_PATH parameter.
  2. Snowflake will only check the schema the UDF belongs to.
  3. Snowflake will first check the current schema, and then the schema the previous query used.
  4. Snowflake will first check the current schema, and then the PUBLIC schema of the current database.

Answer(s): B



Why should a user select the economy scaling policy for a multi-cluster warehouse?

  1. To prevent/minimize query queuing
  2. To increase performance of the clusters
  3. To reduce queuing concurrent user queries
  4. To conserve credits by keeping running clusters fully loaded

Answer(s): D



What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

  1. READ
  2. OWNERSHIP
  3. USAGE
  4. WRITE

Answer(s): C



Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?

  1. ACCESS_HYSTORY
  2. LOGIN_HYSTORY
  3. SESSIONS
  4. QUERY_HISTORY

Answer(s): B



Viewing page 106 of 221
Viewing questions 526 - 530 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!