Depends on what inputs your monitor has. I'm using a mini-DP to Display port adapter cable that's significantly cheaper than the Apple mDP to Dual-Link DVI and it works fine.
But if you have to connect to DVI, then yes, you need the dual-link version.