For example, using Canon EF 24-70mm lens on a EOS 1DS Mark II body which setup is recommended?

What negative issues would I experience with using a zoom versus a prime lens?