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: 4)
Snowflake SnowPro Core
Updated on: 12-Feb-2026

Viewing Page 4 of 139
COF-C02 PDF 1300 Questions

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  1. True
  2. False

Answer(s): A



Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  1. Customers can change the size of the Warehouse after creation
  2. A Warehouse can be resized while running
  3. A Warehouse can be configured to suspend after a period of inactivity
  4. A Warehouse can be configured to auto-resume when new queries are submitted

Answer(s): A,B



The PUT command: (Choose two.)

  1. Automatically creates a File Format object
  2. Automatically uses the last Stage created
  3. Automatically compresses files using Gzip
  4. Automatically encrypts files

Answer(s): C,D


Reference:

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



Which type of table corresponds to a single Snowflake session?

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

Answer(s): A



Which interfaces can be used to create and/or manage Virtual Warehouses?

  1. The Snowflake Web Interface (UI)
  2. SQL commands
  3. Data integration tools
  4. All of the above

Answer(s): D



When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

  1. The Pipe load history is reset to empty
  2. The REFRESH parameter is set to TRUE
  3. Previously loaded files will be ignored
  4. All of the above

Answer(s): A



What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  1. Standard
  2. Premier
  3. Enterprise
  4. Business Critical Edition

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html



Select the three types of tables that exist within Snowflake. (Choose three.)

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

Answer(s): A,B,D


Reference:

https://community.snowflake.com/s/article/Making-Transient-table-by-Default



Viewing Page 4 of 139



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

Kvana 9/28/2023 12:08:00 PM

good info about oml
UNITED STATES


Checo Lee 7/3/2023 5:45:00 PM

very useful to practice
UNITED STATES


dixitdnoh@gmail.com 8/27/2023 2:58:00 PM

this website is very helpful.
UNITED STATES


Sanjay 8/14/2023 8:07:00 AM

good content
INDIA


Blessious Phiri 8/12/2023 2:19:00 PM

so challenging
Anonymous


PAYAL 10/17/2023 7:14:00 AM

17 should be d ,for morequery its scale out
Anonymous


Karthik 10/12/2023 10:51:00 AM

nice question
Anonymous


Godmode 5/7/2023 10:52:00 AM

yes.
NETHERLANDS


Bhuddhiman 7/30/2023 1:18:00 AM

good mateial
Anonymous


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