Not even remotely "always". These days, law enforcement will frequently talk to a service provider before they have a warrant, and the service provider will often cooperate without seeing a warrant.

However, the exceptions in Dropbox's ToS and Privacy Policy allow them to do the same under a broad set of circumstances, not just when required to by a warrant/subpoena.