Terribly phrased options to choose.
A clustered index physically rearanges data on disk.
rearranges?
I think this option should look like this: "When created or rebuilded, a clustered index physically rearranges data on disk".
A quote from the explanation (and from the Delaney's book):
Once created, a clustered index is maintained logically rather than physically.
...
After that (after creation), maintaining the clustered index is a logical operation.
Another option from the question:
Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives.
Maybe, "Dropping and rebuilding"?
"Move disk to other drives" – what is the meaning of this? Sounds like abracadabra for me 🙂
Maybe, it means "moving logical disks C:, D:, E: to other hard disk drives"? :hehe: