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

Questions 6–10

1. 6foundation · easy

   When evaluating compute configurations for a Cloud SQL instance, which tradeoff is most directly associated with choosing a machine type with more vCPUs?

   • ALower latency but reduced network bandwidth
   • BLower cost but reduced storage capacity
   • CHigher cost but potentially better query processing performance
   • DHigher availability but increased maintenance windows
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   A database workload requires a 99th percentile read latency of under 10 milliseconds. Which compute sizing consideration is most directly relevant to meeting this latency requirement?

   • AA larger number of read replicas to distribute reads
   • BA larger disk size to store more data
   • CSufficient vCPUs and memory to handle peak concurrency without CPU saturation
   • DA higher network bandwidth to the application
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   When collecting workload metrics for capacity planning of a database migration, which set of metrics provides the most complete picture of the current environment's resource usage?

   • ANetwork bandwidth and disk capacity
   • BQuery throughput and connection count only
   • CCPU, memory, disk I/O, and query throughput
   • DCPU and memory only
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A database administrator is collecting metrics from a production PostgreSQL instance to plan for a migration to Cloud SQL. Which metric directly measures the rate at which queries are being executed by the database?

   • AQuery throughput
   • BDisk I/O latency
   • CMemory usage
   • DCPU utilization
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   When sizing compute resources for a database that must handle a high volume of concurrent transactions, which metric is most important to monitor to ensure the compute size is adequate?

   • ACPU utilization
   • BNumber of read replicas
   • CStorage capacity used
   • DNetwork bytes sent
   Reveal Solution Discussion Select an answer first