If you wish to purchase alcohol for consumption during your stay, we advise you to buy it from Dubai Airport Duty Free, upon arrival, after passing through immigration counter, near the baggage collection area.  Although there are a limited number of stores in Dubai selling alcohol, you will not be able to buy from them without presenting a local liquor license which can only be obtained/applied by an expat with valid UAE residency visa.