Sharp Impossibility Results for Hypergraph Testing