Will the DPM download function in SpeechExec send the dictations to the SpeechDrive cloud storage automatically?

Yes, if you have configured your DPM download options accordingly your dictations are automatically sent to your SpeechDrive folder.