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:

Eudicots

One of the two major groups of flowering plants, characterized by having two cotyledons (seed leaves), net-veined leaves, and flower parts usually in multiples of four or five.

Monocots

A group of flowering plants (angiosperms) that have a single embryonic leaf, or cotyledon, in their seeds.

Blade

The broad, flat part of a leaf or similar structure, specialized for photosynthesis in most plants.

Sessile

Describes organisms or parts thereof that are attached directly at the base and are not freely moving.