A friend in college wanted to be an FBI agent, so I got to hear alot about this.

I believed they polygraphed you about drug use, and I recall that they had a threshold number of "experimental" sessions with marijuana that were ok, as long as you disclosed them during the background check and polygraph.