Summary
In this chapter, you learned advanced aspects of data management regarding Data Explorer pools. We started this journey by discussing extents, and how Azure Synapse Data Explorer uses data sharding techniques to split very large tables into smaller, more manageable files across the cluster. You learned about merge policies and how the Data Explorer pool engine decides which extents should be merged when needed. You also learned about tagging extents and how to move them to a different table for archival, as well as how to drop extents.
Next, you learned about how to implement data purges in Data Explorer pool databases to ensure you adhere to regulatory requirements, such as the GDPR. You learned how to enable a data purge in your Data Explorer pool, and how to use the two-step process to start and eventually trigger the data purge process. We also covered how you could track data purges to see their statuses, as they run asynchronously, and how the data purge process takes...