Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

QUESTION: 196

Users are responsible for data storage costs until what occurs?

Data expires from Time Travel
Data expires from Fail-safe
Data is deleted from a table
Data is truncated from a table

Answer(s): B

QUESTION: 197

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?

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

Answer(s): D

Show Answer Next Question

QUESTION: 198

What affects whether the query results cache can be used?

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

Answer(s): C

Show Answer Next Question

QUESTION: 199

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