MacBook Pro Mid 2012 (MD101) makes weird sound on wake up/start up
There is no problem as that is the sound the SuperDrive makes when power is applied to it. I found it quite annoying on my first MacBook Pro however my current MacBook Pro doesn't have an internal SuperDrive although the external one make the same sound.

There is nothing you can do to solve it as it's that way by design.