Google Cloud Digital LeaderDigital transformation with Google CloudEasy
A global retail company is experiencing challenges with its legacy on-premises inventory management system, leading to stockouts and inefficiencies. They want to adopt a cloud-based solution that offers high availability, scalability, and seamless integration with their existing point-of-sale systems, enabling real-time inventory updates across all stores. Which Google Cloud solution is best suited to address these requirements as part of their digital transformation?
- ACompute Engine for hosting custom inventory applications.
- BCloud SQL for relational inventory database.
- CCloud Storage for inventory data archival.
- DCloud CDN for accelerating inventory data access.
Show answer & explanationAnswer & explanation
Correct answer: B. Cloud SQL for relational inventory database.
Cloud SQL is a fully managed relational database service that provides high availability, scalability, and easy integration, making it ideal for a transactional inventory management system. It supports popular database engines like PostgreSQL and MySQL.
Why the other options are wrong
- A. Compute Engine provides virtual machines, requiring the company to manage the database themselves, which is not a fully managed solution.
- C. Cloud Storage is primarily for object storage and archival, not for real-time transactional databases.
- D. Cloud CDN is for content delivery, not for managing and storing transactional inventory data.
Cloud SQL
A fully managed relational database service for MySQL, PostgreSQL, and SQL Server.
- Automates database patching, backups, and replication.
- Offers high availability and scalability.
- Suitable for transactional workloads and web applications.
Memory trick: SQL sits on the Cloud, managing your data's flow.