Snowflake COF-R02 Exam (page: 9)
Snowflake SnowPro Core Recertification Exam
Updated on: 15-Feb-2026

Viewing Page 9 of 67

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  1. 4
  2. 16
  3. 32
  4. 128

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html



Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  1. Is available to all Snowflake Editions
  2. Is only available to customers with Business Critical Edition
  3. Restricts or enables access to specific IP addresses
  4. Is activated using an “ALTER DATABASE” command

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html



A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  1. The tables are now orphaned
  2. The user that deleted the role
  3. SYSADMIN
  4. The assumed role that dropped the role

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/drop-role.html



The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  1. 60 minutes
  2. 24 hours
  3. 14 days
  4. 30 days
  5. 1 year

Answer(s): C


Reference:

https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html



To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  1. Configure the Maximum Clusters setting to “Auto-Scale”
  2. Set the Warehouse type to “Auto”
  3. Set the Minimum Clusters and Maximum Clusters settings to the same value
  4. Set the Minimum Clusters and Maximum Clusters settings to the different values

Answer(s): D


Reference:

https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse



Viewing Page 9 of 67



Share your comments for Snowflake COF-R02 exam with other users:

Anonymous 9/14/2023 4:27:00 AM

question number 4s answer is 3, option c. i
UNITED STATES


p das 12/7/2023 11:41:00 PM

very good questions
UNITED STATES


Anna 1/5/2024 1:12:00 AM

i am confused about the answers to the questions. are the answers correct?
KOREA REPUBLIC OF


Bhavya 9/13/2023 10:15:00 AM

very usefull
Anonymous


Rahul Kumar 8/31/2023 12:30:00 PM

need certification.
CANADA


Diran Ole 9/17/2023 5:15:00 PM

great exam prep
CANADA


Venkata Subbarao Bandaru 6/24/2023 8:45:00 AM

i require dump
Anonymous


D 7/15/2023 1:38:00 AM

good morning, could you please upload this exam again,
Anonymous


Ann 9/15/2023 5:39:00 PM

hi can you please upload the dumps for sap contingent module. thanks
AUSTRALIA


Sridhar 1/16/2024 9:19:00 PM

good questions
Anonymous


Summer 10/4/2023 9:57:00 PM

looking forward to the real exam
Anonymous


vv 12/2/2023 2:45:00 PM

good ones for exam preparation
UNITED STATES


Danny Zas 9/15/2023 4:45:00 AM

this is a good experience
UNITED STATES


SM 1211 10/12/2023 10:06:00 PM

hi everyone
UNITED STATES


A 10/2/2023 6:08:00 PM

waiting for the dump. please upload.
UNITED STATES


Anonymous 7/16/2023 11:05:00 AM

upload cks exam questions
Anonymous


Johan 12/13/2023 8:16:00 AM

awesome training material
NETHERLANDS


PC 7/28/2023 3:49:00 PM

where is dump
Anonymous


YoloStar Yoloing 10/22/2023 9:58:00 PM

q. 289 - the correct answer should be b not d, since the question asks for the most secure way to provide access to a s3 bucket (a single one), and by principle of the least privilege you should not be giving access to all buckets.
Anonymous


Zelalem Nega 5/14/2023 12:45:00 PM

please i need if possible h12-831,
UNITED KINGDOM


unknown-R 11/23/2023 7:36:00 AM

good collection of questions and solution for pl500 certification
UNITED STATES


Swaminathan 5/11/2023 9:59:00 AM

i would like to appear the exam.
Anonymous


Veenu 10/24/2023 6:26:00 AM

i am very happy as i cleared my comptia a+ 220-1101 exam. i studied from as it has all exam dumps and mock tests available. i got 91% on the test.
Anonymous


Karan 5/17/2023 4:26:00 AM

need this dump
Anonymous


Ramesh Kutumbaka 12/30/2023 11:17:00 PM

its really good to eventuate knowledge before appearing for the actual exam.
Anonymous


anonymous 7/20/2023 10:31:00 PM

this is great
CANADA


Xenofon 6/26/2023 9:35:00 AM

please i want the questions to pass the exam
UNITED STATES


Diego 1/21/2024 8:21:00 PM

i need to pass exam
Anonymous


Vichhai 12/25/2023 3:25:00 AM

great, i appreciate it.
AUSTRALIA


P Simon 8/25/2023 2:39:00 AM

please could you upload (isc)2 certified in cybersecurity (cc) exam questions
SOUTH AFRICA


Karim 10/8/2023 8:34:00 PM

good questions, wrong answers
Anonymous


Itumeleng 1/6/2024 12:53:00 PM

im preparing for exams
Anonymous


MS 1/19/2024 2:56:00 PM

question no: 42 isnt azure vm an iaas solution? so, shouldnt the answer be "no"?
Anonymous


keylly 11/28/2023 10:10:00 AM

im study azure
Anonymous