Question 76
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
Question 77
You are deploying a Cloud SQL for MySQL database to serve a non-critical application. The database size is 10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read-only traffic from the application during the day. The data locality requirement of this application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do-
Question 78
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
Question 79
You are building the database layer for a multinational ticketing marketplace on Google Cloud.
Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?
Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?
Question 80
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
