Unclear question. Do you mean the diff between SSDs and spinners?
SSDs plug right into sata transport protocols. There is no such thing as a "sata drive". You can plug an old IDE spinner into sata with an adapter. SSDs plug into USB with a $9 case.
SSDs are like USB flash drives except faster. And at 512 Gb or larger they are cheaper. Faster. than spinners too. When you load 10K+ files you will appreciate speed.
Noise is not an issue unless you live in a cave.