A query needs ordering on multiple properties. What index capability should be evaluated when required by the query pattern?

1. A resource-group lock
2. An appropriate composite index
3. A private DNS zone
4. A client password change