Your Customer Has Implemented a Solution That Uses Cloud Spanner

question 73

Multiple Choice

Your customer has implemented a solution that uses Cloud Spanner and notices some read latency-related performance issues on one table. This table is accessed only by their users using a primary key. The table schema is shown below. You want to resolve the issue. What should you do?

• A) Remove the profile_picture field from the table.
• B) Add a secondary index on the person_id column.
• C) Change the primary key to not have monotonically increasing values.
• D) Create a secondary index using the following Data Definition Language (DD

---

Definitions:

Personal Attributes

The qualitative or characteristic features of an individual, including traits, behaviors, and personal qualities.

The Self

A reference to an individual's consciousness of their own identity and personal character.

Cultural Difference

Variations in the customs, beliefs, practices, and social behavior between different societies or groups, often leading to diverse worldviews and ways of life.

Internal Attribution

The process of assigning the cause of behavior to internal characteristics, such as personality or disposition.