Summary

In this module, you learned that Azure SQL Data Warehouse is a cloud-based enterprise data warehouse (EDW) that uses massively parallel processing (MPP) to run complex queries across petabytes of data quickly. You learned how to optimize data storage by using round-robin, hash distribution, and replicated tables. Finally, you created a data warehouse.

Cleanup

To avoid additional costs in your Azure account, delete the mslearn-demodw resource group. Deleting the resource group removes all the resources that you created in this module.

To delete the resource group:

  1. Find the mslearn-demodw resource group. To quickly locate the resource group, in the left menu, select Resource groups.

  2. Select the resource group. Then, either right-click on the row or use the ... button on the far-right side of the row to open the context menu.

  3. Select Delete resource group.

    Screenshot showing the Delete resource group menu

  4. Enter the name of the resource group, and then select Delete. Azure deprovisions all related resources for you.

Check your knowledge

1.

Which of the following terms refers to the compute scale that's used in a data warehouse in Azure Synapse Analytics?

2.

You have an Azure Synapse Analytics database. Within the database, you have a dimension table named Stores that contains store information in 3 columns; StoreID as an integer, StoreName as varchar(200) and Category as as varchar(40). You have a total of 263 stores nationwide. Store information is retrieved in more than half of the queries that are issued against this database. These queries include staff information per store, sales information per store, and finance information. You want to improve the query performance of these queries by configuring the table geometry of the Stores table. Which is the appropriate table geometry to select for the Stores table?