When I upload my Shiny app to the server, where is the data stored? Are there any constraints on the size of the data source that can be uploaded?

There are different ways your app can access data. You could bundle the data in with your application. You could also have your data on a shared filesystem, or in a database. The limit to how much data you can load is usually the amount of memory that you have on the computer.