It's a light honk, here's an example: https://youtu.be/_rpEtxBo00U?t=23

I don't find it too bothersome, but maybe I'm just used to it. In some other videos people are suggesting that it can be disabled on most vehicles by holding the lock and unlock buttons simultaneously for 2 seconds.