The loudness of the card will depend on which custom model of the card you pick from. Although with the thickness of the 4090, you're unlikely to see it spin up too high. As just the heatsink will allow a lot of heat away. With the fans moving it away so unless you get coil whine or a poor model you shouldn't really hear it.