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

Questions 21–23

1. 21foundation · easy

   A database team wants to offload read-only queries from the primary database instance to improve performance. Which replication strategy is appropriate?

   • ACreating a read replica and routing SELECT queries to it.
   • BIncreasing the storage capacity of the primary instance.
   • CEnabling automatic failover to a standby instance.
   • DUsing point-in-time recovery to restore a copy.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A gaming company uses Cloud SQL for PostgreSQL for player data. A new reporting query joins a large `player_actions` table with a small `players` table. The query is slow and the team suspects it is scanning too much data. They have already added indexes on the join columns. What should they do next to improve performance?

   • ARewrite the query to use a subquery instead of a join.
   • BCreate a read replica to offload the reporting query.
   • CIncrease the instance memory to fit the entire `player_actions` table in memory.
   • DUse the `EXPLAIN ANALYZE` command to identify the query plan and bottlenecks.
   Reveal Solution Discussion Select an answer first
3. 23application · medium

   A SaaS company runs a Cloud Spanner instance for its multi-tenant application. The workload is write-heavy, and the team is experiencing high latency during peak hours. They have already scaled up the instance to the maximum number of nodes. What is the most effective next step to improve write throughput?

   • AMigrate to Cloud Bigtable for higher write throughput.
   • BSwitch to a multi-region configuration to improve write latency.
   • CAdd more nodes to the instance.
   • DReview the schema and query patterns to identify hotspots.
   Reveal Solution Discussion Select an answer first