Free COF-C02 Exam Braindumps
SnowPro Core Questions 271–275 (page: 56)

Updated On: 10-Feb-2026

Which object types are protected by Fail-safe? (Choose two.)

  1. Permanent Tables
  2. Temporary Tables
  3. External Tables
  4. Materialized Views
  5. Transient Tables

Answer(s): A,D



Snowflake's approach to the management of system access combines which of the following models? (Choose two.)

  1. Security Assertion Markup Language (SAML)
  2. Role-Based Access Control (RBAC)
  3. Identity Access Management (AM)
  4. Create, Read, Update, and Delete (CRUD)
  5. Discretionary Access Control (DAC)
  6. Mandatory Access Control (MAC)

Answer(s): B



According to Snowflake best practice recommendations, which role should be used to create databases?

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

Answer(s): B



To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)

  1. The MODIFY privilege on the table
  2. The OWNERSHIP privilege on the table
  3. A SECURITYADMIN role
  4. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
  5. The SELECT privilege on the table

Answer(s): B,D



While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?

  1. Statements that insert a duplicate record during a load
  2. Statements that have a specific data type in the source
  3. Statements that have duplicate file names
  4. Statements that transform data during a load

Answer(s): D



Viewing page 56 of 221
Viewing questions 276 - 280 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!