Is there any difference between having a service managed by Portal and another made from ArcGIS Server ?
It is already known that for one ArcGIS Data Store ( hosted Feature Layer ) is required and the other one is about DBMS ( feature layer) , the query is referred to when to use one instead of the other