Ultimate access to all questions.
To effectively create a new transaction table in Cloud Spanner for storing product sales data, it is crucial to choose an appropriate primary key to optimize performance. Cloud Spanner, a horizontally scalable, strongly consistent, relational database service from Google Cloud, leverages primary keys for indexing and query efficiency. Considering performance impacts such as distribution of write and read operations, data locality, and hot-spotting, which strategy should you choose for the primary key?