Question 46

Your company is planning to migrate their 5 TB on-premises MySQL database to Cloud SQL for MySQL. You need a Google-recommended approach for schema and data migration. You must keep downtime to a minimum while ensuring continuous data replication.
What should you do?
  • Question 47

    You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
    Work with transactions and offer strong consistency.
    Work with structured and semi-structured (JSON) data.
    Scale transparently to multiple regions globally as the operation grows.
    You need a Google Cloud database that meets all the requirements of the application. What should you do?
  • Question 48

    Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
  • Question 49

    Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
  • Question 50

    You are migrating an on-premises online transactional process (OLTP) PostgreSQL database to Google Cloud. You want to reduce the administrative overhead on database maintenance activities, such as vacuum and memory tuning. You are also planning to introduce analytic use cases in this database. You need the migration to have minimal schema and application changes.
    What should you do-