SnowPro Advanced: Architect — Question 55

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

Answer options

• A. An external table
• B. A pipe
• C. A stream
• D. A copy command at regular intervals

Correct answer: D

Explanation

Using a copy command at regular intervals is the most cost-effective approach for loading numerous small files into Snowflake, as it optimizes processing and minimizes costs associated with frequent data ingestion. The other options, such as external tables, pipes, and streams, may incur higher costs or not be as efficient for handling such a high volume of small files.