Free COF-C02 Exam Braindumps
SnowPro Core Questions 231–235 (page: 48)

Updated On: 10-Feb-2026

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  1. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
  2. An error will occur, as views with qualified references cannot be cloned.
  3. An error will occur, as stored objects cannot be cloned.
  4. The stored procedures and views will refer to tables in the source database.

Answer(s): D



When loading data into Snowflake, how should the data be organized?

  1. Into single files with 100-250 MB of compressed data per file
  2. Into single files with 1-100 MB of compressed data per file
  3. Into files of maximum size of 1 GB of compressed data per file
  4. Into files of maximum size of 4 GB of compressed data per file

Answer(s): A



Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  1. Schema
  2. View
  3. Internal stage
  4. Table
  5. User
  6. Role

Answer(s): A,D



Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  1. SHOW GRANTS OF ROLE MY_ROLE
  2. SHOW GRANTS TO ROLE MY_ROLE
  3. SHOW GRANTS FOR ROLE MY_ROLE
  4. SHOW GRANTS ON ROLE MY_ROLE

Answer(s): A



What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

  1. Business Critical Edition
  2. Standard Edition
  3. Virtual Private Snowflake (VPS)
  4. Enterprise Edition

Answer(s): B



Viewing page 48 of 221
Viewing questions 236 - 240 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!