ISPN-4464 Unify test suite for remote and embedded DSL based query tests

* Fixed test so it will properly close cache manager and continue build
Insert a delay between clearing the cache store and the data container
to allow any running clustered get commands to finish.