Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Snowflake
  3. COF-C02

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

Viewing Page 9 of 139
COF-C02 PDF 1300 Questions

Fail-safe is unavailable on which table types? (Choose two.)

  1. Temporary
  2. Transient
  3. Provisional
  4. Permanent

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html



Which of the following objects is not covered by Time Travel?

  1. Tables
  2. Schemas
  3. Databases
  4. Stages

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/data-time-travel.html



True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  1. True
  2. False

Answer(s): A


Reference:

https://blog.ippon.tech/innovative-snowflake-features-caching/



Which of the following commands are not blocking operations? (Choose two.)

  1. UPDATE
  2. INSERT
  3. MERGE
  4. COPY

Answer(s): B,D



Which of the following is true of Snowpipe via REST API? (Choose two.)

  1. You can only use it on Internal Stages
  2. All COPY INTO options are available during pipe creation
  3. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
  4. Snowpipe keeps track of which files it has loaded

Answer(s): C,D



Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

  1. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
  2. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
  3. SECURITYADMIN, ACCOUNTADMIN
  4. ACCOUNTADMIN

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/security-mfa.html



When can a Virtual Warehouse start running queries?

  1. 12am-5am
  2. Only during administrator defined time slots
  3. When its provisioning is complete
  4. After replication

Answer(s): C



True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html



Viewing Page 9 of 139



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

KJ 11/17/2023 3:50:00 PM

good practice exam
Anonymous


sowm 10/29/2023 2:44:00 PM

impressivre qustion
Anonymous


CW 7/6/2023 7:06:00 PM

questions seem helpful
Anonymous


luke 9/26/2023 10:52:00 AM

good content
Anonymous


zazza 6/16/2023 9:08:00 AM

question 21 answer is alerts
ITALY


Abwoch Peter 7/4/2023 3:08:00 AM

am preparing for exam
Anonymous


mohamed 9/12/2023 5:26:00 AM

good one thanks
EGYPT


Mfc 10/23/2023 3:35:00 PM

only got thru 5 questions, need more to evaluate
Anonymous


Whizzle 7/24/2023 6:19:00 AM

q26 should be b
Anonymous


sarra 1/17/2024 3:44:00 AM

the aaa triad in information security is authentication, accounting and authorisation so the answer should be d 1, 3 and 5.
UNITED KINGDOM


DBS 5/14/2023 12:56:00 PM

need to attend this
UNITED STATES


Da_costa 8/1/2023 5:28:00 PM

these are free brain dumps i understand, how can one get free pdf
Anonymous


vikas 10/28/2023 6:57:00 AM

provide access
EUROPEAN UNION


Abdullah 9/29/2023 2:06:00 AM

good morning
Anonymous


Raj 6/26/2023 3:12:00 PM

please upload the ncp-mci 6.5 dumps, really need to practice this one. thanks guys
Anonymous


Miguel 10/5/2023 12:21:00 PM

question 16: https://help.salesforce.com/s/articleview?id=sf.care_console_overview.htm&type=5
SPAIN


Hiren Ladva 7/8/2023 10:34:00 PM

yes i m prepared exam
Anonymous


oliverjames 10/24/2023 5:37:00 AM

my experience was great with this site as i studied for the ms-900 from here and got 900/1000 on the test. my main focus was on the tutorials which were provided and practice questions. thanks!
GERMANY


Bhuddhiman 7/20/2023 11:52:00 AM

great course
UNITED STATES


Anuj 1/14/2024 4:07:00 PM

very good question
Anonymous


Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA


Lue 3/30/2023 11:43:00 PM

highly recommend just passed my exam.
CANADA


DC 1/7/2024 10:17:00 AM

great practice! thanks
UNITED STATES


Anonymus 11/9/2023 5:41:00 AM

anyone who wrote this exam recently?
SOUTH AFRICA


Khalid Javid 11/17/2023 3:46:00 PM

kindly share the dump
Anonymous


Na 8/9/2023 8:39:00 AM

could you please upload cfe fraud prevention and deterrence questions? it will be very much helpful.
Anonymous


shime 10/23/2023 10:03:00 AM

this is really very very helpful for mcd level 1
ETHIOPIA


Vnu 6/3/2023 2:39:00 AM

very helpful!
Anonymous


Steve 8/17/2023 2:19:00 PM

question #18s answer should be a, not d. this should be corrected. it should be minvalidityperiod
CANADA


RITEISH 12/24/2023 4:33:00 AM

thanks for the exact solution
Anonymous


SB 10/15/2023 7:58:00 AM

need to refer the questions and have to give the exam
INDIA


Mike Derfalem 7/16/2023 7:59:00 PM

i need it right now if it was possible please
Anonymous


Isak 7/6/2023 3:21:00 AM

i need it very much please share it in the fastest time.
Anonymous


Maria 6/23/2023 11:40:00 AM

correct answer is d for student.java program
IRELAND