2.4 Optimize Database Cost and Performance in Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   A database team needs to support a workload that has grown beyond the maximum machine size available for a single Cloud SQL instance. Which strategy aligns with scaling out?

   • AMoving to a different region to access larger machine types.
   • BSharding the data across multiple instances.
   • CAdding more storage to the existing instance.
   • DIncreasing the number of vCPUs on the existing instance.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company runs a Cloud SQL for PostgreSQL instance for its content management system. The workload is variable, with high traffic during the day and low traffic at night. The team wants to automate scaling to match the workload and reduce costs. What should they do?

   • AUse the Cloud SQL API to scale up during the day and scale down at night.
   • BMigrate to Cloud Spanner for automatic scaling.
   • CEnable automatic storage increases.
   • DUse a read replica to handle the daytime traffic.
   Reveal Solution Discussion Select an answer first
4. 8expert · medium

   A company runs a Cloud SQL for MySQL instance for its user database. The instance is in `us-central1`. The application is read-heavy, and the team wants to improve read performance for users in `europe-west1`. They have already added a read replica in `europe-west1`. What is the most important factor to consider for the read replica to be effective?

   • AThe read replica must be in the same region as the primary instance.
   • BThe read replica must have the same machine type as the primary instance.
   • CThe application must be configured to use the read replica's IP address for read queries.
   • DThe primary instance must be stopped for the replica to be used.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A database administrator needs to manually increase the compute capacity of a Cloud SQL instance ahead of a known traffic spike. Which action should be taken?

   • AIncrease the allocated storage size.
   • BChange the machine type to a tier with more vCPUs and memory.
   • CEnable point-in-time recovery.
   • DAdd a read replica and promote it to primary.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company runs a Cloud SQL for PostgreSQL instance for its reporting database. A query that joins two large tables is slow. The team has added indexes on the join columns, but the query is still slow. What should they do next?

   • ARun `EXPLAIN ANALYZE` to see the query execution plan.
   • BRewrite the query to use a subquery instead of a join.
   • CCreate a read replica to offload the query.
   • DIncrease the instance memory to cache the tables.
   Reveal Solution Discussion Select an answer first