Google Professional Cloud Database Engineer Question 87
Single answerGoogle Cloud PlatformYour team is evaluating database solutions for a new application on Google Cloud. The application requires scalability to handle unpredictable traffic spikes, minimal operational overhead, and cost-efficiency. You are considering Cloud SQL, Cloud Spanner, and Firestore. Which database solution would be the most cost-effective for this use case?
- A
Cloud SQL, as it offers a balance of cost and performance for scalable applications.
- B
Cloud Spanner, as it provides global scalability and strong consistency at a lower cost than other options.
- C
Firestore, as it is serverless, scales automatically, and charges only for actual usage.
- D
None of the above, as all options are equally cost-efficient for this use case.
Show answer and explanation
Correct answer: C
Explanation
Firestore is the most cost-effective solution for this use case because it is serverless, scales automatically to handle unpredictable workloads, and operates on a pay-as-you-go pricing model. This minimizes costs during periods of low activity while ensuring the application can handle traffic spikes without requiring manual intervention or over-provisioning resources, which can result in unnecessary expenses.
- A. Incorrect.
Cloud SQL is suitable for many use cases, but it requires provisioning and managing instances, which can lead to higher costs during unpredictable traffic spikes compared to serverless options.
- B. Incorrect.
Cloud Spanner is designed for globally distributed workloads and provides exceptional scalability and consistency, but it comes with a higher cost compared to other database options.
- C. Correct.
Firestore is a serverless database that automatically scales to handle traffic spikes and charges only for actual usage, making it the most cost-efficient option for this use case.
- D. Incorrect.
Not all database options are equally cost-efficient. The cost depends on the specific use case and requirements, and in this scenario, Firestore is the most cost-effective choice.