Identifying which iOS app caused the notification sound to play
In the settings, go to Notifications, and select Notification Center for every app with Sound selected.

Then chose to Sort Apps by time.

That way, when you hear the sound, just access your Notification Center, and the culprit app will be on top.