TeamSpeed's example from Sam's Club is the perfect example of what happens in 99.99% of cases where you are making photo prints in a "lab" setting. You are interacting with the labs software on it's server, be that directly on the kiosk in the shop, or via the web. The system will generally ignore any value inserted in the DPI/PPI field of the Exif data, and simply look at the number of pixels provided, and the print size requested. Opening another can of worms that really should stay closed my understanding of most of these systems is that if there is no colour space specified it will assume sRGB, just as the web does. If there is a profile associated with the file then it will colour manage the image correctly.
Very occasionally you will find a lab that has an option which will require that you ensure that you correctly size the number of pixels to match the size of the print, and the PPI resolution that the printer works at. On top will be the requirement to sort out the correct colour profile to use. These labs are usually quite few and far between, and will make the requirements of this option very plain when using it. I actually use a lab that offers this service, they literally feed the file into the printer without even checking it first, but you do have to also accept that unless their is some obvious physical fault with the print, you bought it. I like this service since it is about as close as I can get to owning my own Fuji wet lab system. Oh and they say that you are very unlikely to not find a print made with sRGB instead of the actual paper profile unacceptable colour wise. Not saying that you couldn't see a difference between a pair of prints side by side though.
Alan
Sams Club minimum DPI is 175, but it isn't really advertised anywhere for the consumer, at least not easily accessible.

