Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

• A.Schedule automated backups.
• B.Configure single zone availability for automated backups.
• C.Create a PostgreSQL database on-premises as the HA option.
• D.Enable point-in-time recovery.
• E.Set up manual backups.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Perform the gcloud sql operations list command.
• B.Use Cloud Audit Logs to verify the status.
• C.Use the Google Cloud Console.
• D.Check the cloudsql.googleapis.com/postgres.log instance log.

Comment: *

Name: *

Email: *

Verification: *

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

• A.Create another schema to load older data.
• B.Compress the data using a different compression algorithm.
• C.Normalize the database to the third normal form.
• D.Manually or automatically increase the storage capacity.

Comment: *

Name: *

Email: *

Verification: *

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

• A.Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
• B.Configure the primary, standby, and read replica instances in zone A, all in the same region.
• C.Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
• D.Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

Comment: *

Name: *

Email: *

Verification: *

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

• A.Identify whether the database has over 512 tables.
• B.Identify all tables that do not have a primary key.
• C.Identify whether the source database uses customer-managed encryption keys (CMEK).
• D.Identify whether the source database is encrypted using pgcrypto extension.
• E.Identity all tables that do not have at least one foreign key.

Comment: *

Name: *

Email: *

Verification: *