Oh I meant to mention - if this is your first cruise - and pardon me for 'assuming' from yoru signature...lol there are a few things to look at before choosing your room. Now with the Dream still being built there is no way to know what will be noisy and what won't but if you look at your deck plans, see what is above you on the deck above for the room you want and go for that.
If you go to http://www.seauonboard.com/ and look at 'Cruise 101 - The basics' - and then 'Cabin Selection' it tells you what rooms to avoid on other ships and thats how I picked my room on The Spirit. I had stateroom 8234 and above was the Lido Deck so I knew there would be no noise above. However, what I didn't realize was that it was beside the housekeeping room and first thing in the morning it was noisy - I don't sleep in so it didn't bother me.
Also my stateroom was directly behind the elevators and there was NO noise from those nor the passengers getting off. I think the higher you are on the ship - the quieter it becomes (for me). On the Spa Deck on the Dream - I have the 'serenity section' above my stateroom so I know there won't be any noise.....lol 
<center>
<small>
MySpace Countdown Clocks</small></center>
Carnival Dream April 17, 2010
Carnival Spirit May 14, 2008