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

Questions 16–20

1. 16application · medium

   A company runs a Cloud Spanner instance for a financial application. They have collected metrics showing that the current instance has 5 nodes and handles 20,000 reads per second and 5,000 writes per second. They expect a 50% increase in both reads and writes over the next year. They need to maintain a p99 latency of under 10 ms. What should they do?

   • AReduce the number of nodes to save cost, as the workload is not expected to grow.
   • BKeep the current node count because the latency is currently acceptable.
   • CIncrease the number of nodes to handle the projected increase in reads and writes.
   • DAdd a read replica to offload read traffic.
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A financial services company is planning to migrate their Oracle database to Cloud SQL for PostgreSQL. They have collected metrics: average CPU 60%, peak CPU 90%, and the database handles 5,000 TPS during end-of-day processing. They expect a 20% growth in TPS over the next two years. They need to meet a latency SLA of under 100 ms for critical queries. What is the most appropriate sizing approach?

   • ASelect a machine type that can handle the peak TPS with at least 30% headroom, and verify it meets the latency SLA.
   • BProvision the largest machine type available to guarantee the latency SLA is met.
   • CUse the same machine type as the on-premises server to ensure compatibility.
   • DChoose the cheapest machine type that can handle the average TPS, assuming the peak is rare.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A database administrator is analyzing historical usage data to project future capacity needs. Which factor is most important to consider when extrapolating future workload from historical trends?

   • AThe number of database administrators on the team
   • BThe cost of the current infrastructure
   • CSeasonal patterns and business growth projections
   • DThe database vendor's recommended best practices
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   When choosing between SSD persistent disk and standard persistent disk for a Cloud SQL instance, which tradeoff is most important to consider?

   • AStandard disk provides higher IOPS but lower durability
   • BSSD has lower latency but is limited to smaller sizes
   • CSSD provides higher IOPS but at a higher cost per GB
   • DStandard disk is cheaper but has higher latency
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   A database workload is primarily memory-bound, with high cache hit ratios but low CPU utilization. Which compute configuration change would most directly improve performance?

   • AIncreasing the amount of memory allocated to the instance
   • BIncreasing the number of vCPUs
   • CDecreasing the amount of memory to reduce cost
   • DSwitching to a smaller machine type
   Reveal Solution Discussion Select an answer first