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

Reveal Solution 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

Reveal Solution 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?

SELECT SUM (ORDER_AMT) FROM SALES;
SELECT AVG(ORDER_QTY) FROM SALES;
SELECT MIN(ORDER_AMT) FROM SALES;
SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Answer(s): C

Reveal Solution Next Question

QUESTION: 200

How many days is load history for Snowpipe retained?

1 day
7 days
14 days
64 days

Answer(s): C

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 51)

QUESTION: 197

QUESTION: 198

QUESTION: 199

QUESTION: 200

SnowPro Core Exam Discussions & Posts