Your company has an IoT application running on Google Cloud, collecting real-time data from thousands of geographically dispersed physical devices. The collected data is published to Pub/Sub and then streamed into an SSD Cloud Bigtable cluster via a Dataflow pipeline for storage and processing. Recently, the operations team has reported a performance issue where the Cloud Bigtable cluster is experiencing a hotspot, causing queries to take longer than expected. As the cloud architect, you need to identify and implement a solution to resolve the hotspot issue and prevent it from occurring in the future. What should you do?