Is this ventilator noisy?

No. When installed correctly, attic ventilators are designed to run quietly. Most of the sound stays in the attic and is not noticeable inside your home.