nerdexam
GoogleGoogle

ASSOCIATE-CLOUD-ENGINEER · Question #123

ASSOCIATE-CLOUD-ENGINEER Question #123: Real Exam Question with Answer & Explanation

Sign in or unlock ASSOCIATE-CLOUD-ENGINEER to reveal the answer and full explanation for question #123. The question stem and answer options stay visible for context.

Submitted by salim_om· Mar 30, 2026

Question

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?

Options

  • ARemove the profile_picture field from the table.
  • BAdd a secondary index on the person_id column.
  • CChange the primary key to not have monotonically increasing values.
  • DCreate a secondary index using the following Data Definition Language (DDL):

Unlock ASSOCIATE-CLOUD-ENGINEER to see the answer

You've previewed enough free ASSOCIATE-CLOUD-ENGINEER questions. Unlock ASSOCIATE-CLOUD-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full ASSOCIATE-CLOUD-ENGINEER PracticeBrowse All ASSOCIATE-CLOUD-ENGINEER Questions