Free COF-C02 Exam Braindumps
SnowPro Core Questions 421–425 (page: 86)

Updated On: 10-Feb-2026

According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)

  1. ACCOUNTADMIN
  2. SYSADMIN
  3. SECURITYADMIN
  4. USERADMIN
  5. ORGADMIN

Answer(s): C,D



What services are provided by the cloud services layer in Snowflake? (Choose two.)

  1. Metadata management
  2. Object authorization
  3. Authentication
  4. Query execution
  5. Result caching

Answer(s): A,C



Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)

  1. TRUE
  2. RETURN_ERROR_SUM
  3. RETURN_ALL_ERRORS
  4. RETURN_<N>_ROWS
  5. RETURN_FIRST__ERRORS

Answer(s): C,D



Snowflake virtual warehouses are part of which layer of the Snowflake architecture?

  1. Compute layer
  2. Storage layer
  3. Database layer
  4. Cloud services layer

Answer(s): A



Which of the following are characteristics of schemas used in Snowflake? (Choose two.)

  1. A schema may contain one or more databases.
  2. A database may contain one or more schemas.
  3. A schema represents a logical grouping of database objects.
  4. Each schema is contained within a virtual warehouse.
  5. A table can span more than one schema.

Answer(s): B,C



Viewing page 86 of 221
Viewing questions 426 - 430 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!