1.1 Analyze Relevant Variables to Perform Database Capacity and Usage Planning PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A company runs a Cloud SQL for PostgreSQL instance for an OLTP workload. They have collected metrics showing that the current instance has 4 vCPUs and 16 GB memory, and the CPU utilization is at 80% during peak hours. They expect a 40% increase in traffic. They need to keep query latency under 50 ms. What should they do?

   • AEnable connection pooling to reduce the number of connections.
   • BAdd more storage to the existing instance.
   • CUpgrade to a machine type with 8 vCPUs and 32 GB memory.
   • DCreate a read replica to offload read traffic.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company is migrating a MongoDB database to Cloud Spanner. They have collected metrics showing the workload is write-heavy with an average of 10,000 writes per second and a peak of 20,000 writes per second. They need to ensure low write latency. What storage configuration should they choose?

   • AUse multi-regional HDD storage to handle the peak write throughput.
   • BUse SSD storage for the database to provide low-latency writes.
   • CUse regional SSD storage to ensure high availability.
   • DUse HDD storage to reduce cost, as the workload is write-heavy.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company is planning to migrate their on-premises MySQL database to Cloud SQL. They have collected metrics showing the database size is 500 GB and grows by 10% annually. The workload is read-heavy with a peak of 3,000 reads per second. They need to ensure the storage can handle the growth for the next three years and provide sufficient IOPS. What should they do?

   • AProvision 1 TB of SSD storage to ensure plenty of headroom.
   • BEnable automatic storage increases and use HDD storage.
   • CProvision 700 GB of SSD storage to accommodate the projected growth.
   • DProvision 500 GB of HDD storage to minimize cost.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A company runs a Cloud Spanner instance for a global application. They have collected metrics showing that the current instance has 3 nodes and handles 10,000 reads per second and 2,000 writes per second. They expect the read traffic to double in the next year, but write traffic will remain stable. They want to optimize cost while maintaining performance. What should they do?

   • AReduce the number of nodes to save cost because write traffic is stable.
   • BKeep the current node count because write traffic is stable.
   • CAdd a read replica to offload read traffic.
   • DIncrease the number of nodes to handle the projected read traffic.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company is planning to migrate their on-premises SQL Server database to Cloud SQL. They have collected metrics for the past six months, but they notice that the metrics do not include the end-of-quarter processing that causes a significant spike in CPU and I/O. What should they do to ensure their capacity plan is accurate?

   • AUse the average metrics from the six months and add a 20% buffer.
   • BCollect additional metrics during the next end-of-quarter period to capture the peak load.
   • CProceed with the migration and adjust the instance size after observing the peak.
   • DUse the maximum metrics from the six months to size the instance.
   Reveal Solution Discussion Select an answer first