can I transfer data from my ipad 2nd generation to my new ipad 9th generation?

You should be able to do that with a Mac or PC. What will be transferred (especially app data) might be limited if the app compatibility is different. It should be able to copy over things like photos/video as well as notes and other Apple app data, but again there could be limitations if the versions are considerably different.

Use the Finder or iTunes to transfer data from your previous iOS device to your new iPhone, iPad, or iPod touch - Apple Support

Yes, on your 2nd generation iPad go to Settings > Apple ID (your name at the top) > iCloud and select all items you wish to sync.

If you login to the same Apple ID on your new iPad and ensure the sync is the same all items you have selected should sync between the new devices as they’ll be saved on the cloud.

to restore from a backup the devices needs to be the same ios version and the ipad 2 released in 2011 don't support a higher ios version than ios 9.x.y iPad 2 - Wikipedia

but if you use the same appleID it will get the data you synced with icloud