The Best Database Solution for Scaling Your Application
Question
You are building an application that stores relational data from users.
Users across the globe will use this application.
Your CTO is concerned about the scaling requirements because the size of the user base is unknown.
You need to implement a database solution that can scale with your user growth with minimum configuration changes.
Which storage solution should you use?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.B.
To build an application that can store relational data from users and is globally available, a database solution that can scale with user growth is necessary. The CTO's concern about scaling requirements indicates that the user base may increase rapidly, and the database should be able to handle the increase without requiring significant configuration changes.
Of the options provided, Cloud Spanner is the best solution for this scenario. Cloud Spanner is a horizontally scalable, globally distributed relational database that can handle large amounts of data and traffic. It is designed to provide high availability and consistent performance, making it ideal for global applications with unpredictable traffic patterns.
Cloud SQL is a managed relational database service that can handle moderate traffic and data sizes. However, it may require significant configuration changes as the user base grows, which can affect performance.
Cloud Firestore and Cloud Datastore are NoSQL document databases designed for small to medium-sized applications. While they can handle global traffic, they may not be the best fit for a relational database scenario, especially when the user base is unknown.
In conclusion, Cloud Spanner is the most appropriate storage solution for this scenario, as it is designed to handle large amounts of relational data and can scale horizontally with minimal configuration changes.
