Provisioning and Configuring Large-Scale Data Analytics in Azure

In the previous chapter, we explored the components of a modern data warehouse in Azure. Now, let’s see how to use the Azure Synapse Analytics toolset to implement our data analytics projects on Azure.

This chapter will look at content that will map to the Describe an analytics workload on Azure section of Skills measured in the DP-900 certification. You can take a look at the detailed requirements of DP-900 on the official website: https://docs.microsoft.com/en-us/certifications/exams/dp-900.

This hands-on chapter is a complement to our previous chapter to dive deeper into the Azure Data Analytics tools.

By the end of this chapter, we will have covered the following topics:

• Common practices for data loading
• Data storage and processing
• Azure Synapse Analytics:
  • Synapse Studio
  • Synapse Pipelines
  • Synapse SQL pools – serverless and dedicated
  • Synapse Spark pools
  • Synapse Link
  • Synapse Data Explorer...