Question

Difference between ADLS and Azure Synapse Analytics

Answer 1

Both  Azure Data Lake Storage Gen2 and Azure Synapse Analytics are highly scalable and can ingest and process vast amounts of data (on a Peta Byte scale). But there are some differences:

ADLS Gen2	Azure Synapse Analytics
Optimised for storing and processing structured and non-structured data	Optimised for processing structured data in a well-defined schema
Used for data exploration and analytics by data scientists and engineers	Used for Business Analytics or disseminating data to business users
Built to work with Hadoop	Built on SQL Server
No regulatory compliance	Compliant with regulatory standards such as HIPAA
USQL (combination of C# and TSQL) and Hadoop are used for accessing data	Synapse SQL (improved version of TSQL) is used for accessing data
Can handle data streaming using tools such as Azure Stream Analytics	Built-in data pipelines and data streaming capabilities