You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

1. A. Use log messages produced by Cloud SQL.
2. B. Use Query Insights for Cloud SQL.
3. C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
4. D. Use Cloud SQL instance monitoring in the Google Cloud Console.

Correct Answer: B
https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on- premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?

1. A. Use the native export and import functionality of the source database.
2. B. Create a database on Google Cloud, and use database links to perform the migration.
3. C. Create a database on Google Cloud, and use Dataflow for database migration.
4. D. Use Database Migration Service.

Correct Answer: D
Simplify migrations to the cloud. Available now for MySQL and PostgreSQL, with SQL Server and Oracle migrations in preview.
• Migrate to Cloud SQL and AlloyDB for PostgreSQL from on-premises, Google Cloud, or other clouds
• Replicate data continuously for minimal downtime migrations
• Serverless and easy to set up

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

1. A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
2. B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us- east1 and us-west1.
3. C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
4. D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us- central1, us-east1 and us-west1.

Correct Answer: A
https://cloud.google.com/sql/docs/mysql/quotas#table_limit

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to
launch the game in multiple regions. What should you do?

1. A. Use Cloud Spanner to deploy the database.
2. B. Use Bigtable with clusters in multiple regions to deploy the database
3. C. Use BigQuery to deploy the database
4. D. Use Cloud SQL with a regional read replica to deploy the database.

Correct Answer: A
Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

1. A. Use Logs Explorer to analyze log data.
2. B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
3. C. Use Error Reporting to count, analyze, and aggregate the data.
4. D. Use Cloud Debugger to inspect the state of an application.

Correct Answer: B
https://cloud.google.com/sql/docs/mysql/diagnose-issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%20is%20degraded%2C%20make%20sure%20it%20conforms%20to%20the%20Operational%20Guidelines