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

Viewing Page 20 of 139
COF-C02 PDF 1300 Questions

What is a key feature of Snowflake architecture?

  1. Zero-copy cloning creates a mirror copy of a database that updates with the original.
  2. Software updates are automatically applied on a quarterly basis.
  3. Snowflake eliminates resource contention with its virtual warehouse implementation.
  4. Multi-cluster warehouses allow users to run a query that spans across multiple clusters.
  5. Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date.

Answer(s): C



When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  1. There is no need to have a Snowflake account in the target region, a share will be created for each user.
  2. The listing is replicated into all selected regions automatically, the data is not.
  3. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
  4. Shares attached to listings in remote regions can be viewed from any account in an organization.
  5. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Answer(s): B,E



When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

  1. 10-50 MB
  2. 100-250 MB
  3. 300-500 MB
  4. 1000-1500 MB

Answer(s): B



Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

  1. External Tokenization
  2. External Tables
  3. Materialized Views
  4. User-Defined Table Functions (UDTF)

Answer(s): A



Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)

  1. MIN(<< column value >>)
  2. COPY
  3. SUM(<< column value >>)
  4. UPDATE

Answer(s): B,C,D



What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  1. VIEWS_HISTORY
  2. OBJECT_HISTORY
  3. ACCESS_HISTORY
  4. LOGIN_HISTORY

Answer(s): C



Which feature is only available in the Enterprise or higher editions of Snowflake?

  1. Column-level security
  2. SOC 2 type II certification
  3. Multi-factor Authentication (MFA)
  4. Object-level access control

Answer(s): A


Reference:

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



Will data cached in a warehouse be lost when the warehouse is resized?

  1. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  2. Yes, because the compute resource is replaced in its entirety with a new compute resource.
  3. No, because the size of the cache is independent from the warehouse size.
  4. Yes, because the new compute resource will no longer have access to the cache encryption key.

Answer(s): D



Viewing Page 20 of 139



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

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

please upload this
UNITED STATES


Naveena 1/13/2024 9:55:00 AM

good material
Anonymous


WildWilly 1/19/2024 10:43:00 AM

lets see if this is good stuff...
Anonymous


Lavanya 11/2/2023 1:53:00 AM

useful information
UNITED STATES


Moussa 12/12/2023 5:52:00 AM

intéressant
BURKINA FASO


Madan 6/22/2023 9:22:00 AM

thank you for making the interactive questions
Anonymous


Vavz 11/2/2023 6:51:00 AM

questions are accurate
Anonymous


Su 11/23/2023 4:34:00 AM

i need questions/dumps for this exam.
Anonymous


LuvSN 7/16/2023 11:19:00 AM

i need this exam, when will it be uploaded
ROMANIA


Mihai 7/19/2023 12:03:00 PM

i need the dumps !
Anonymous


Wafa 11/13/2023 3:06:00 AM

very helpful
Anonymous


Alokit 7/3/2023 2:13:00 PM

good source
Anonymous


Show-Stopper 7/27/2022 11:19:00 PM

my 3rd test and passed on first try. hats off to this brain dumps site.
UNITED STATES


Michelle 6/23/2023 4:06:00 AM

please upload it
Anonymous


Lele 11/20/2023 11:55:00 AM

does anybody know if are these real exam questions?
EUROPEAN UNION


Girish Jain 10/9/2023 12:01:00 PM

are these questions similar to actual questions in the exam? because they seem to be too easy
Anonymous


Phil 12/8/2022 11:16:00 PM

i have a lot of experience but what comes in the exam is totally different from the practical day to day tasks. so i thought i would rather rely on these brain dumps rather failing the exam.
GERMANY


BV 6/8/2023 4:35:00 AM

good questions
NETHERLANDS


krishna 12/19/2023 2:05:00 AM

valied exam dumps. they were very helpful and i got a pretty good score. i am very grateful for this service and exam questions
Anonymous


Pie 9/3/2023 4:56:00 AM

will it help?
INDIA


Lucio 10/6/2023 1:45:00 PM

very useful to verify knowledge before exam
POLAND


Ajay 5/17/2023 4:54:00 AM

good stuffs
Anonymous


TestPD1 8/10/2023 12:19:00 PM

question 17 : responses arent b and c ?
EUROPEAN UNION


Nhlanhla 12/13/2023 5:26:00 AM

just passed the exam on my first try using these dumps.
Anonymous


Rizwan 1/6/2024 2:18:00 AM

very helpful
INDIA


Yady 5/24/2023 10:40:00 PM

these questions look good.
SINGAPORE


Kettie 10/12/2023 1:18:00 AM

this is very helpful content
Anonymous


SB 7/21/2023 3:18:00 AM

please provide the dumps
UNITED STATES


David 8/2/2023 8:20:00 AM

it is amazing
Anonymous


User 8/3/2023 3:32:00 AM

quesion 178 about "a banking system that predicts whether a loan will be repaid is an example of the" the answer is classification. not regresion, you should fix it.
EUROPEAN UNION


quen 7/26/2023 10:39:00 AM

please upload apache spark dumps
Anonymous


Erineo 11/2/2023 5:34:00 PM

q14 is b&c to reduce you will switch off mail for every single alert and you will switch on daily digest to get a mail once per day, you might even skip the empty digest mail but i see this as a part of the daily digest adjustment
Anonymous


Paul 10/21/2023 8:25:00 AM

i think it is good question
Anonymous


Unknown 8/15/2023 5:09:00 AM

good for students who wish to give certification.
INDIA