Yes, in rendering DPI definitely makes a difference, especially with materials that appear to cause banding, such as brick and mortar. See the attached files. The 600 DPI image shows much less apparent banding than the lesser two images. If you take a lower DPI image and just "UP" the resolution, the banding is still present. Be careful of your final image. If banding occurs, the only way to rid yourself of the banding is to change materials /contrast colors or up the resolution of the output image. (or at least the only ways I'm aware of).
Note I was going to post a true size 800 DPI jpeg for your comparison, but the 4.5"x 4.89 in images was 7.5 Megs compressed, 38.6 Megs uncompressed. If you are planning on working with say an 8x10 at 800 DPI the image will be 145 Megs in size or so.
That being said, look at the slate roofs. There is the same patterning occuring, yet as there is no true color contrasts in the joints, the banding is not nearly as evident in any of the resolutions.
Hope this helps