The way to handle this is to ask the prosecutor to allow you to plead in exchange for a dismissal if you do not get into trouble within a certain period of time. That way, the entire matter is dismissed. However, keep in mind that if they do character and fitness, like lawyers have to go through, and they ask if you have ever been arrested, you would still have to answer affirmatively. A friend of mine got into trouble by forgetting to mention an arrest when the question was posed in that manner.
Yes, guilty or not, it is a misdemeanor, and it will show up on your criminal record as an arrest. You should consult with an attorney who can assist you in protecting your record moving forward.
My answer to this question is for general informational purposes only and does not establish an attorney-client relationship. You should seek the assistance of an attorney to determine the best approach and potential consequences for your situation.
Unless the court sentences you where the charges are dismissed when the court is satisfied, it will show up. Regardless, your arrest record will remain. It cannot be removed or expunged.