
Answer-first summary for fast verification
Answer: Cloud Spanner
The question involves migrating a User Profiles database from Oracle to Google Cloud Platform. Key considerations include the existing relational structure (Oracle with complex tables), global user base, and 20TB size. While Datastore (D) is commonly recommended for user profiles in Google documentation and has community support (59% in poll, upvoted comments citing its suitability), the consensus from detailed reasoning favors Cloud Spanner (A). Cloud Spanner is a globally distributed relational database that supports SQL, making it a better fit for migrating from Oracle without significant architectural changes. It handles the 20TB size and global latency requirements effectively. BigQuery (B) is for analytics, not OLTP. Cloud SQL (C) is regional and has scaling limits. Although Datastore is ideal for user profiles, the migration from a complex relational schema to NoSQL would require substantial rework, whereas Spanner offers a smoother transition with relational consistency and global scalability.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.