Chapter 5: Implementing Physical Data Storage Structures
Hope you have had a good learning experience up till now. Let's continue our journey toward certification with more interesting topics in this chapter. Till the previous chapter, we have been focusing on the design aspects, but from now on, we will be focusing on the implementation details. We will learn how to implement the storage-level concepts that we learned in the previous chapters. Once you complete this chapter, you should be able to decide on and implement the following: what kind of data sharding is required, when to compress your data, how many partitions to create, what kind of data redundancy to maintain, and so on.
We will cover the following topics in this chapter:
- Getting started with Azure Synapse Analytics
- Implementing compression
- Implementing partitioning
- Implementing horizontal partitioning or sharding
- Implementing distributions
- Implementing different table geometries with...