The use of Cloud computing for materials science is possible indeed, although I've never done it personally. Besides, I'm pretty sure it is costlier in the end than running it on a dedicated workstation or HPC if you're planning to use it intensively.
You might want to check the following link (and the related ones on the website) for examples, they don't talk about MS Azure but they're giving other alternatives :