Microsoft · DP-300
Partitioning, sharding, and compression
DP-300 · Lesson 4 of 22 · 27:36
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: planning table partitioning with partition functions and schemes, switching, splitting, and merging partitions for a sliding window, sharding tenants with the Elastic Database client library or choosing Hyperscale instead, row and page compression with estimated savings, and columnstore compression for analytics. Includes three original practice questions.
Preview the topics
- Every month, Contoso must remove the oldest month from a partitioned table of ten years of prescriptions, without long locks on the live rows. What should the team do?
- Contoso’s loyalty platform serves forty regional partners, and each partner’s data must be isolated and scaled on its own, in identically structured databases. Which approach fits?
- Contoso’s prescriptions history keeps ten years of rows, rarely updated, mostly read by monthly reports that scan millions of rows. Storage costs keep growing. What should the team apply?