Free Microsoft Azure DP-300 Actual Exam Questions - Question 9 Discussion

D, since compression targets indexes directly, not the entire table here.

I think C can be ruled out because it talks about altering the table with a data compression option, which might not apply here. D makes more sense since we’re focusing on the clustered index itself.

I went with D because enabling compression directly on the clustered index seems the most straightforward, without touching the whole table or other indexes. C felt off since that’s more about row-level settings.

C