Summary
To implement a project with large-scale data analytics, Azure offers a variety of solutions, such as Azure Synapse Analytics, Azure Databricks, Azure HDInsights, Azure Machine Learning, and Azure Data Explorer, among others.
The DP-900 exam requires the knowledge to explore these options, with a greater focus on the motivations for using each tool, and has some more detailed questions based on Azure Synapse Analytics, which is the main Azure platform for these projects. The knowledge gained in this chapter and our exploration of the tool is not only very important for answering these questions but also for directing your path when it comes to a real-life project.
To sum up what we covered in the chapter, we started by exploring the SQL pools further – serverless and dedicated – executing SQL scripts to exercise them. Then, we had an overview of the Spark pools, Data Explorer pools, Azure Synapse Link, and the integration of Azure Synapse with Azure Machine...