Fired at the muzzle, a representative .40 S&W load (11.7 g, FMJ, 300 m/s) reaches roughly 176 mm (6.9 inches) into packed sand. That is enough to defeat a typical barrier of this material — treat anything behind it as exposed.
Packed sand (~150 mm), e.g. a single sandbag.