Azure Data Lake Analytics Vs Azure SQL Data Warehouse

Question

Can anyone help me were to use Azure data lake analytics and were to use Azure SQL data warehouse? I want to do some transformation and use SSRS reports for creating cubes.

Answer 1

So, basically, Azure Data lake is meant to be used when you are dealing with petabyte size big data processing whereas Azure SQL data warehouse for 250-500 GB and up. With Azure Data lake you will get NoSQL database, a SSAS cube, a data mart. Whereas with Azure SQL data warehouse you can have cubes, Power BI reports and SSRS.

I hope this will help.

Want to become an Azure expert? join Azure Training now!!