DPM = Data Protection Manager for anyone who didn't know that part.

I have no experience with this myself, but my understanding is that this product works by pausing all IO on the files while the snapshot is created, hence it is roughly the equivalent of the files actually being detached at snapshot creation time and your SQL Server will be able to bring the database back online if you restore these files.