Domain 2.3: Planning and configuring data storage options

You need a fully managed relational database for a new application. The database will be approximately 50 GB in size and requires standard MySQL compatibility. Which service should you choose?

Your application generates massive amounts of time-series IoT data (petabytes). You need a NoSQL database capable of high-throughput, low-latency writes and reads. Which service is MOST appropriate?

Your company is building a global inventory management system. The database must be fully relational (SQL), support strong consistency, and scale horizontally to handle thousands of transactions per second across multiple continents. Which GCP database service should you choose?

You need to store 50 TB of compliance logs. These logs must be kept for 5 years for regulatory reasons. They will likely never be accessed, but if they are, you can wait a few hours to retrieve them. You need the lowest possible storage cost. Which Cloud Storage class should you use?

Your company is building a global financial trading platform. The application requires a fully managed relational database that provides strong consistency, horizontal scalability, and high availability across multiple regions globally. Which Google Cloud database service should you choose?

Your company needs to store petabytes of compliance logs. These logs must be kept for 7 years but are typically only accessed once a year during an audit. You need to select the most cost-effective Cloud Storage class for this data. Which storage class should you choose?

Your company needs to store petabytes of compliance logs. These logs must be kept for 7 years but are rarely accessed (perhaps once a year in the event of an audit). When an audit occurs, the data must be retrievable within a few hours. You want to minimize storage costs. Which Cloud Storage class should you choose?

You are designing the database backend for a global inventory management system. The system requires relational database semantics (ACID transactions, SQL queries) but must scale horizontally to handle tens of thousands of reads and writes per second globally, with strong consistency across multiple continents. Which GCP database service should you choose?

Your company is migrating an on-premises MySQL database to Google Cloud. The database is 500 GB in size. The application requires full MySQL compatibility, high availability within a single region, and automatic backups. The team wants to minimize database administration overhead. Which Google Cloud database service should you choose?

Your company needs to store petabytes of compliance logs. These logs must be kept for 5 years but are expected to be accessed less than once a year. You need to select the most cost-effective storage option. Which Cloud Storage class should you choose?

Your company needs to store petabytes of compliance logs. These logs must be kept for 7 years for regulatory reasons. It is highly unlikely that these logs will ever be accessed, but if an audit occurs, the data must be retrievable within a few hours. You want to minimize storage costs. Which Cloud Storage class should you choose?

You are designing the database backend for a new global e-commerce platform. The database must support strong relational consistency (ACID transactions), handle massive horizontal scaling to support millions of users globally, and provide high availability across multiple regions. Which Google Cloud database service is the BEST fit for these requirements?

Your company needs to store petabytes of compliance logs. These logs must be kept for 5 years for regulatory reasons. They are rarely accessed—perhaps once a year during an audit—but when they are needed, they must be available immediately. You want to minimize storage costs. Which Cloud Storage class should you choose?

You are designing the database backend for a new global multiplayer game. The database must support strong relational consistency (ACID transactions), handle millions of reads and writes per second, and scale horizontally across multiple regions worldwide without sharding the database manually. Which Google Cloud database service should you choose?