Understanding common practices for data loading

To start an analytics database, we need to load data from transactional databases, where the data that is generated by enterprise systems is stored.

In Azure, we have some options for performing data ingestion as we covered in Chapter 11, Components of a Modern Data Warehouse, using batch loads and data streaming, concepts we also learned about in Chapter 5, Exploring Data Analytics Concepts.

In this chapter, we’ll explore Azure Synapse Analytics so that you can materialize that knowledge to help you answer DP-900 questions and have a foundation for your Data Analytics projects in Azure.

So, let’s start step by step.

Provisioning an Azure Synapse workspace

To get started, let’s navigate the Azure portal (http://portal.azure.com) and search for the Azure Synapse Analytics session. When you’re in the Azure Synapse Analytics session, click the + Create button to provision a new workspace and fill...