You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google- recommended practices. What should you do?

Your company is developing a new global transactional application that must be ACID-compliant and have
99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices.
What should you do?

You are setting up a new AlloyDB instance and want users to be able to use their existing Identity and Access Management (IAM) identities to connect to AlloyDB. You have performed the following steps:
- Manually enabled IAM authentication on the AlloyDB instance
- Granted the alloydb.databaseUserand serviceusage.serviceUsageconsumerIAM roles to the users
- Created new AlloyDB database users based on corresponding IAM identities Users are able to connect but are reporting that they are not able to SELECTfrom application tables. What should you do-

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.)