Google Cloud Professional Cloud Database Engineer — Question 43

You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?

Answer options

• A. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
• B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
• C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
• D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

Correct answer: B

Explanation

The correct answer is B, as Cloud Spanner is designed for high scalability and low-latency transactions, making it ideal for your needs while retaining the relational schema. Option A, Firestore, is more suited for document storage rather than relational databases. Option C, Memorystore, is an in-memory cache and does not provide persistent storage for transactions. Option D, Bigtable, is optimized for large analytical workloads and is not intended for relational data storage.