Why not? If you've got reasonably static 100TB datasets you want to be able to fire queries at, then -- if the price is right -- a single huge-memory box could be a great solution.

Need to run more queries than the box can handle? Buy another one.