PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #165
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #165: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #165. The question stem and answer options stay visible for context.
Question
You are migrating an on-premises database to Spanner. There are a few tables, each with a few hundred records that do not have a primary key on the source database. You need to migrate all of the tables over to the news database while avoiding hot-spotting issues. What should you do-
Options
- ALoad the data into Spanner, and designate a primary key later based on business need.
- BUse the GENERATE_UUID() function to generate universally unique identifier (UUID) values with
- CDuring the migration, swap the order of keys so that the column that contains the monotonically
- DMigrate the tables with no primary key to maintain consistency with source.
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.