Exam SnowPro Advanced Architect topic 1 question 60 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 60
Topic #: 1

[All SnowPro Advanced Architect Questions]

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?

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

Show Suggested Answer

Suggested Answer: B 🗳️

by hillcat111 at June 9, 2023, 12:45 p.m.

Comments

Submit Cancel

potatosack

2 months, 4 weeks ago

Selected Answer: D

If only looking at cost-effective, D. If also take into account real-time capability, then it would be B. Pipe can get very expensive handling a lot of small files, its best for real-time/ near real-time scenarios

upvoted 2 times

...