Designing Partition Strategy for Azure Synapse Analytics
Azure Synapse Analytics is the premium analytics service that Azure is investing in quite heavily. When Azure Synapse Analytics is mentioned, you might think of it as an SQL Data Warehouse; however, in reality, Synapse Analytics is a complete suite of integrated analytical services.
Note
This section primarily focuses on the Implement a partition strategy for Azure Synapse Analytics concept of the DP-203: Data Engineering on Microsoft Azure exam.
Synapse Analytics has integrated support for several Azure Storage services, compute technologies such as SQL Data Warehouse and Synapse Spark, orchestration engines such as ADF, specialized stores such as Cosmos DB, cloud-based Identity and Access Management (IAM) services such as Azure AD, data governance support via Azure Purview, and more.
Azure Synapse Analytics also doubles as the analytics store for the serving layer as it has a highly scalable SQL Warehouse store...