Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-C02

Snowflake COF-C02 Exam Questions
SnowPro Core (Page 41 )

Updated On: 17-Feb-2026
Page 41 of 221
PDF with 1300 Questions

Users are responsible for data storage costs until what occurs?

  1. Data expires from Time Travel
  2. Data expires from Fail-safe
  3. Data is deleted from a table
  4. Data is truncated from a table

Answer(s): B



A user has an application that writes a new file to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

  1. Create a task that runs a COPY INTO operation from an external stage every 5 minutes.
  2. Create a task that PUTS the files in an internal stage and automate the data loading wizard.
  3. Create a task that runs a GET operation to intermittently check for new files.
  4. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

Answer(s): D



What affects whether the query results cache can be used?

  1. If the query contains a deterministic function
  2. If the virtual warehouse has been suspended
  3. If the referenced data in the table has changed
  4. If multiple users are using the same virtual warehouse

Answer(s): C



Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

  1. SELECT SUM (ORDER_AMT) FROM SALES;
  2. SELECT AVG(ORDER_QTY) FROM SALES;
  3. SELECT MIN(ORDER_AMT) FROM SALES;
  4. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Answer(s): C



How many days is load history for Snowpipe retained?

  1. 1 day
  2. 7 days
  3. 14 days
  4. 64 days

Answer(s): C






Post your Comments and Discuss Snowflake COF-C02 exam dumps with other Community members:

Join the COF-C02 Discussion