nerdexam
Snowflake

COF-R02 · Question #108

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

The correct answer is D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Data Loading and Unloading

Question

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

Options

  • ACreate a task that runs a copy into operation from an external stage every 5 minutes
  • BCreate a task that puts the files in an internal stage and automate the data loading wizard
  • CCreate a task that runs a GET operation to intermittently check for new files
  • DSet up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

How the community answered

(59 responses)
  • A
    14% (8)
  • B
    3% (2)
  • C
    10% (6)
  • D
    73% (43)

Explanation

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Topics

#Snowpipe#auto-ingest#cloud notifications#continuous loading

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice