You are running a Cloud SQL for PostgreSQL 13 Enterprise Edition instance. During an audit, you discovered that the write-ahead logs used for point-in-time recovery (PITR) are stored on disk. You need to store PITR logs in a Cloud Storage bucket going forward. How should you do this without compromising recoverability or losing the current PITR logs-

• A. Change the transaction logs (WAL) retention period.
• B. Disable PITR, then enable PITR.
• C. Clone the instance. Create a new instance with PITR retention set to 30 days.
• D. Upgrade to Enterprise Plus Edition.

Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do-

• A. Enable and use Query Insights.
• B. Use the underprovisioned instance recommender.
• C. Increase the Cloud SQL instance read_buffer_sizeflag.
• D. Create a Cloud Monitoring alert based on the database/mysql/queriesmetric.

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process data. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

• A. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
• B. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
• C. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
• D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

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

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

• A. Use high availability (HA) Cloud SQL with multiple zones.
• B. Use zonal Cloud SQL without high availability (HA).
• C. Use Cloud Spanner in a regional configuration.
• D. Use Cloud SQL with cross-region replicas.