Question 2
DP-800 is a newly released exam. These practice questions reflect our best current understanding — the exact wording and question formats may change in the live exam until the certification matures. Use them to learn the concepts, not to memorize.
DP-800 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →A fact table stores ten years of monthly sales data. The business retains only the last 36 months in the primary database, and old partitions must be archived with minimal downtime. DRAG DROP - Arrange the actions in the correct order. ```mermaid flowchart LR S1[Create a partition function and partition scheme] S2[Align the fact table to the partition scheme] S1 --> S2 S3[Load current data into the correct partitions] S2 --> S3 S4[Switch out and archive old partitions as part of the retention process] S3 --> S4 ```