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

Snowflake COF-C02 Exam (page: 23)
Snowflake SnowPro Core
Updated on: 16-Feb-2026

Viewing Page 23 of 139
COF-C02 PDF 1300 Questions

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  1. parse_json()
  2. json_extract_path_text()
  3. object_construct()
  4. flatten

Answer(s): A



How are serverless features billed?

  1. Per second multiplied by an automatic sizing for the job
  2. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
  3. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
  4. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Answer(s): A



Which Snowflake architectural layer is responsible for a query execution plan?

  1. Compute
  2. Data storage
  3. Cloud services
  4. Cloud provider

Answer(s): C



When unloading to a stage, which of the following is a recommended practice or approach?

  1. Set SINGLE = TRUE for larger files.
  2. Use OBJECT_CONSTRUCT(*) when using Parquet.
  3. Avoid the use of the CAST function.
  4. Define an individual file format.

Answer(s): C



Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  1. UPDATE TABLE FROM STREAM
  2. SELECT FROM STREAM
  3. INSERT INTO TABLE SELECT FROM STREAM
  4. ALTER TABLE AS SELECT FROM STREAM
  5. BEGIN COMMIT

Answer(s): A,C



Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  1. Use the DROP command after the load completes.
  2. Specify the TEMPORARY option when creating the file format.
  3. Specify the PURGE copy option in the COPY INTO command.
  4. Use the REMOVE command after the load completes.
  5. Use the DELETE LOAD HISTORY command after the load completes.

Answer(s): C,D



On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

  1. Amazon Web Services
  2. Private Virtual Cloud
  3. Oracle Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Alibaba Cloud

Answer(s): A,D,E



What Snowflake role must be granted for a user to create and manage accounts?

  1. ACCOUNTADMIN
  2. ORGADMIN
  3. SECURITYADMIN
  4. SYSADMIN

Answer(s): B



Viewing Page 23 of 139



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

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


Ch 11/20/2023 10:56:00 PM

is there a google drive link to the images? the links in questions are not working.
AUSTRALIA


Joey 5/16/2023 5:25:00 AM

very promising, looks great, so much wow!
Anonymous


alaska 10/24/2023 5:48:00 AM

i scored 87% on the az-204 exam. thanks! i always trust
GERMANY


nnn 7/9/2023 11:09:00 PM

good need more
Anonymous


User-sfdc 12/29/2023 7:21:00 AM

sample questions seems good
Anonymous


Tamer dam 8/4/2023 10:21:00 AM

huawei is ok
UNITED STATES


YK 12/11/2023 1:10:00 AM

good one nice
JAPAN


de 8/28/2023 2:38:00 AM

please continue
GERMANY


DMZ 6/25/2023 11:56:00 PM

this exam dumps just did the job. i donot want to ruffle your feathers but your exam dumps and mock test engine is amazing.
UNITED KINGDOM


Jose 8/30/2023 6:14:00 AM

nice questions
PORTUGAL


Tar01 7/24/2023 7:07:00 PM

the explanation are really helpful
Anonymous


DaveG 12/15/2023 4:50:00 PM

just passed my exam yesterday on my first attempt. these dumps were extremely helpful in passing first time. the questions were very, very similar to these questions!
Anonymous


A.K. 6/30/2023 6:34:00 AM

cosmos db is paas not saas
Anonymous


S Roychowdhury 6/26/2023 5:27:00 PM

what is the percentage of common questions in gcp exam compared to 197 dump questions? are they 100% matching with real gcp exam?
Anonymous


Bella 7/22/2023 2:05:00 AM

not able to see questions
Anonymous


Scott 9/8/2023 7:19:00 AM

by far one of the best sites for free questions. i have pass 2 exams with the help of this website.
CANADA


donald 8/19/2023 11:05:00 AM

excellent question bank.
Anonymous


Ashwini 8/22/2023 5:13:00 AM

it really helped
Anonymous


sk 5/13/2023 2:07:00 AM

excelent material
INDIA


Christopher 9/5/2022 10:54:00 PM

the new versoin of this exam which i downloaded has all the latest questions from the exam. i only saw 3 new questions in the exam which was not in this dump.
CANADA


Sam 9/7/2023 6:51:00 AM

question 8 - can cloudtrail be used for storing jobs? based on aws - aws cloudtrail is used for governance, compliance and investigating api usage across all of our aws accounts. every action that is taken by a user or script is an api call so this is logged to [aws] cloudtrail. something seems incorrect here.
UNITED STATES