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

Questions 21–25

1. 21application · medium

   A company runs a Cloud SQL for SQL Server instance with 8 vCPUs and 32 GB memory. Monitoring shows CPU utilization is consistently below 10%, but memory usage is at 90%. The database is used for a reporting workload with large in-memory sorts. They want to optimize cost without sacrificing performance. What should they do?

   • AReduce memory by scaling down to a smaller machine type with the same vCPUs.
   • BScale down to a smaller machine type with fewer vCPUs but the same memory.
   • CKeep the current configuration because it is already balanced.
   • DScale up to a larger machine type with more vCPUs and memory.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   A database workload requires high sustained IOPS for a large dataset. Which storage configuration would best meet this requirement?

   • ALocal SSD with a smaller disk size
   • BStandard persistent disk with a larger disk size
   • CStandard persistent disk with a smaller disk size
   • DSSD persistent disk with a larger disk size to increase IOPS
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A company is migrating an on-premises PostgreSQL database to Cloud SQL. They have collected metrics for the past month: average CPU utilization is 70%, memory usage peaks at 85%, and the busiest hour sees 2,000 transactions per second (TPS). The application team expects a 50% increase in TPS over the next year. They want to size the Cloud SQL instance to handle the projected load with headroom. What should they do first?

   • AProvision a machine type with double the vCPUs and memory of the current on-premises server.
   • BChoose the largest available machine type to ensure sufficient capacity for any future growth.
   • CUse the collected metrics to model the projected workload and then select a machine type that meets the peak TPS and latency targets.
   • DMigrate first and then monitor Cloud SQL metrics to determine if the instance is too small.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which sequence correctly represents a systematic approach to sizing a database solution?

   • ASelect a configuration, collect metrics, project growth, validate
   • BCollect current metrics, project future growth, select a configuration, validate against requirements
   • CProject growth, select a configuration, collect metrics, validate
   • DCollect metrics, select a configuration, validate, project growth
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   A database workload requires high write throughput with low latency. Which storage performance characteristic is most important to consider when sizing the storage?

   • AIOPS and throughput limits of the disk type
   • BThe number of vCPUs on the instance
   • CThe network bandwidth of the region
   • DThe total storage capacity in GB
   Reveal Solution Discussion Select an answer first