Validate a site collection name

Validates whether a proposed site collection name is available and meets naming requirements before creating a collection. Returns validation status and any error messages.