nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #187

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #187: Real Exam Question with Answer & Explanation

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

Designing and Implementing Cloud Spanner Solutions

Question

You are migrating your on-premises PostgreSQL database to Spanner. You need to identify a solution for handling existing integer-based table primary keys. You want minimal changes to the applications while also following Google-recommended practices. What should you do-

Options

  • AUse application generated sequential integer values as primary keys.
  • BUpdate default primary key values to max(primary_key) + 1.
  • CUse a UUID function that generates UUID Version 4 values as primary keys.
  • DGenerate values by using BIT_REVERSED_POSITIVE sequences.

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-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.

Topics

#Spanner#Primary Keys#Database Migration#Distributed Databases
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions