Question 116
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
Question 117
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
Question 118
At Nimbus Retail you manage a Cloud SQL for MySQL instance called reporting-sql-01. The team needs to export a full database to Cloud Storage and later import it back into the same instance using gcloud without doing any format conversion. Which command should you run to create the export so that it can be imported back into Cloud SQL?
Question 119
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?
- 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 120
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
