Will this alcohol offense be on my criminal record?

The record will still be available to police officers when you come in contact with them, as far as employment/background checks will have the deferred charge, etc...