It will be the path you define; by default on a machine with ArcGIS Desktop installed it is under the users profile folder where the connections for ArcCatalog are stored. You have the ability to create new connections in a folder on a mapped or UNC share.
You just need to define the path to the connection once you have created it and pass that string to your script.
