Thanks Jake. This is very helpful.
You mention "With a Hosted Service, a copy of the data is uploaded to ArcGIS Online, so it is independent of the data you have locally"
So if a user adds new data from the Collector app, how do I view this information in the underlying source enterprise geodatabase? I noticed when I sync, the records that were collected in the field do not appear in my enterprise geodatabase (they appear in AGOL web map).
How can I view the records generated using the Collector app in our enterprise geodatabase?