Just happened to see this great set of comprehensive blog/tutorials on how to deploy Drill on Azure and use it with a variety of sources on Azure. Wanted to share the link with the other users that might be interested in this topic.
https://blogs.msdn.microsoft.com/data_otaku/2016/05/27/deploying-apache-drill-on-azure/