question

UcarCihan-8515 avatar image
0 Votes"
UcarCihan-8515 asked UcarCihan-8515 commented

What is the difference between Azure Synapse Analytics and Azue Data Lake Analytics

Hi Guys,

I am currently preparing my Exam for AZ-900 Certification. One Question in a training was:

Which service is an on-demand analytics job service that helps you to write queries to transform your data and extract valuable insights?

My answer was Azure Synapse analytics, obviously this was wrong. The suggested answer was Azure Data Lake analytics. So I have searched in the internet about the differences of these services. Unfortunately, I was not successful.

This is the reason I posted my question now here.

Cheers,
Chico

azure-synapse-analyticsazure-data-lake-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT edited

Hello @UcarCihan-8515,

Thanks for the question and using MS Q&A platform.

Yes, the correct answer for the question is Azure Data Lake Analytics.

Azure Data Lake Analytics is an on-demand analytics job service to simplify big data analytics. You can focus on writing, running, and managing jobs rather than on operating distributed infrastructure. Instead of deploying, configuring, and tuning hardware, you write queries to transform your data and extract valuable insights.

What is the difference between Azure Synapse Analytics and Azure Data Lake Analytics?

Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data. Instead of deploying, configuring, and tuning hardware, you write queries to transform your data and extract valuable insights. The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need. You only pay for your job when it is running, making it cost-effective.

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
1 Vote"
HimanshuSinha-MSFT answered UcarCihan-8515 commented

Hello @UcarCihan-8515,

Just to add to what @PRADEEPCHEEKATLA-MSFT called out above . ADLA is a solution which was introduced before Synapse and was used for data transformation . In ADLA you write the logic in U -SQL /.Net / Python etc , but the logic was deployed as a job on Azure . So it was the successful execution of the job which guaranteed the fact the data moved / transformed . So in your question the word “job service” is vital .

Fast forward in current times , Synapse does not offer jobs but pipelines ( there are other big changes apart from this )
If you ask me to rewrite a solution which I wrote using ADLA few years back again , I will use Synapse analytics only , AFAIK Synapse can take care of the use case which ADLA supports barring the fact that it does support U-SQL .

All the best for your exam :)

Please do let me know how it goes .

Thanks
Himanshu


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @HimanshuSinha-MSFT ,

thank you so much for your valuable feedback. Your feedback is exactly from the perspective of a use who has to understand the difference in a practical manner. Which service I would use in which use case.

I am still preparing my exam. I have constantly the feeling that I am preparing for "Azure Architect Technologies" rather than for "AZ Fundamentals" :-)

Cheers,
Chico

0 Votes 0 ·