Why people ask
Most people asking are not expecting a single answer. Modern software runs on many services at once: one for documents, another for sign-in, another for email delivery, another for payments. Any of them can operate in a different country. The person asking wants to know that you have thought about it.
There are usually three concerns underneath. Whose laws apply to information held in another country, and could a foreign government compel access? Who is responsible if something goes wrong? And does the arrangement fit any rules the asker is bound by, such as an agency's cloud policy or a European partner's privacy obligations?