A BWA/ MDS file is simply a file which stores Physical Media Density information. This information is required in order to produce a working backup of games protected with the latest SecuROM protections.
And no the game is not in this file.
To use BWA you also need an image of your CD. The BWA/ MDS files are used in conjunction with your image file to give (hopefully) a good copy.