It is an mot failure to do anything but replace it with a working unit, you'll need the car remapped to delete it which is easy enough for most cars nowadays.
You'll need to either force a hole through it from end to end the diameter of the exhaust pipework or cut it open and remove the contents and then weld it closed but you'd need to make sure there's no sign of that having been done or it will fail an mot.