What it does, depends on what option exactly you have turned on or not.
If you have iCloud Photos turned on in Settings ➜ Photos, then it syncs photos to iCloud and anything you remove locally on a device or computer will sync and be removed from iCloud as well.
If you don't have iCloud Photos turned on, then the iOS device backup process can actually backup the photos in the photos app to iCloud if the option is turned on in Settings ➜ Account (top of Settings) ➜ iCloud ➜ iCloud Backup ➜ Your iPad ➜ Photo Library. This backup is not directly accessible by you, and can only be restored to a device during setup. Deleting items from your device will not affect the backup until the next time the backup is updated.
To backup to an external drive from an iPad or iPhone, you would need to do so manually, by connecting the external drive to the iPad, and then in the Photos app, selecting the photos to be copied over, then tapping on the share icon at the bottom of the screen, then tap on Save to Files, and then navigate to the connected external drive to save them onto it.
click here ➜ Connect external storage devices to iPad - Apple Support