On some cars, dual exhaust has a fake exhaust tip on one side just for the look
That particular photo is of an aftermarket exhaust system. Many current cars though with dual outlets use a vacuum operated flap to close off one pipe at idle and low load conditions, and open the flap for full throttle or high load conditions. Done primarily to keep noise levels down.