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?
Given the scenario of storing numerous small JSON files and the necessity for a cost-effective solution, using a COPY command at regular intervals is optimal. This approach allows the aggregation of many small files into larger, more manageable batches before they are imported into a Snowflake table. By doing so, it avoids the overhead associated with processing each small file individually, which can be resource-intensive and costly. Therefore, periodically using the COPY command helps to maintain efficiency and reduce costs.
Answer is B and is validated
Correct answer