As soon as you remove the DPF and Catalytic converter you will hear the turbo whistle without a doubt. If you leave the Cat in it will remove it slightly or you can get an aftermarket Cat that cuts down on the smell as well as the whistle.

That being said, having your X5 sound like a jet fighter during take off is one of the cool things about doing a delete. Haha!