SharePoint supports two types of managed paths: wildcard inclusion (like 'sites/*' that matches any URL under that path) and explicit inclusion (exact paths like 'teams' that must be directly specified). Wildcard paths are used for site collections under a parent path, while explicit paths are used for specific site collections. Option D correctly combines both types.