In 2007, I was falsely accused of minor assault by a former neighbour, who had actually assaulted me, but told the cops he was the victim. Since the police didn't ask for jail time in the event of conviction, (they only asked for a DNA sample), I didn't qualify for court-appointed counsel at the trial date, but I successfully defended myself, and won acquittal, without having to present my defense case, through the cross examination of the two prosecution witnesses. I had refused the Crown's offer to have charges dropped after the first cross.
As was my right, I applied in writing to the police department to have the record of my arrest, my fingerprints, and mug shot expunged from the their records, and about a year later, I got a letter from the RCMP, confirming that this had been done. I don't think border guards would have a record of this arrest.
If I had accepted the Crown's offer to have charges dropped, I could not have applied to have the arrest records removed. If I had not made the written request to the police, they could have kept the arrest record, fingerprints, and mug shot on file, despite my acquittal.