We should investigate enabling test tenants when `SingleNodeTestClusterFactory` is used. Informs: #138912 Epic CRDB-48944 Jira issue: CRDB-48534