Refactor kedro-datasets testing

[AhdraMeraliQB]

Description

After discussion of #104 @jmholzer mentioned there are other areas of the test suite that may not be as robust as hoped. This issue proposes going in and exploring the test setup, identifying weaker tests and refactoring/rewriting them.