I need to use the antenna for internet conection via 3g/2g, and I need at least a 3 meter/9 feet cable. And I also, need to keep a low power consumption, the Arduino will be powered via a battery.
That antenna uses N-type connector. GSM modem uses something else. An adapter is needed. It is a booster, so it may or may not work. Besides, boosters need power. I have used a GSM antenna with low loss coaxial cable and correct connector. It worked. The cable lenght was about one meter. You have to try to see if longer cables work or not.
I read once again what was in your link. This booster does need extra power. But if you want to boost or amplify antenna signal without extra power, you need a special antenna which is not omnidirectional. Omindirectional antenna works as well up, down and sideways. A boosting antenna may work only sideways. Or all this may just be marketing talk without any real justification.
I would search more antennas and study some about them. Or use some specialist dealer who knows these things and whom you can fully trust.