An organization has an ecommerce application that requires a cost-effective, transactional database. The application will only serve customers in a single region. Which service should they use?
D. Cloud SQL.
Cloud SQL is a fully-managed relational database service that is ideal for transactional workloads (OLTP—Online Transaction Processing) in applications such as ecommerce platforms. It supports SQL databases like MySQL, PostgreSQL, and SQL Server, which are commonly used for cost-effective and transactional databases. Since the ecommerce application will serve customers in a single region, Cloud SQL is an optimal choice as it provides high availability within a region and is relatively simple to set up and manage.
Why the other options are incorrect:
A. BigQuery: BigQuery is a fully-managed, serverless data warehouse designed for large-scale analytics (OLAP—Online Analytical Processing), not transactional workloads. It's optimized for running complex queries over large datasets, rather than handling real-time transactional data. BigQuery is also not designed for typical transactional use cases like those required by ecommerce applications, making it unsuitable for the application described in the question.
B. Cloud Bigtable: Cloud Bigtable is a NoSQL database designed for high-throughput, low-latency applications that require large-scale storage, such as time-series data, IoT data, and analytical workloads. While it is fast and scalable, it is not a relational database and is not suitable for transactional systems that require strong consistency and SQL support. It would not be a good fit for an ecommerce application that requires transactional integrity.
C. Cloud Spanner: Cloud Spanner is a horizontally scalable, globally distributed relational database that provides strong consistency and high availability across regions. While Cloud Spanner is an excellent choice for large-scale, globally distributed applications, it is typically more expensive than Cloud SQL for smaller, regionally focused applications. Since the ecommerce application only serves customers in a single region, Cloud Spanner may be overkill in terms of both cost and complexity.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
joshnort
3Â months, 1Â week agojoshnort
3Â months, 1Â week agojoshnort
3Â months, 1Â week ago