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

Questions 1–5

1. 1foundation · easy

   A database is expected to grow to 2 TB of data over the next two years. Which storage sizing decision is most directly based on this projection?

   • AProvisioning a disk size that can accommodate the projected 2 TB with room for growth
   • BChoosing a machine type with more vCPUs
   • CSelecting a higher network tier for faster connectivity
   • DEnabling automatic backups with a longer retention period
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company is designing a new Cloud SQL for MySQL instance for a logging application. The workload is write-heavy with an average of 5,000 writes per second and a peak of 10,000 writes per second. They expect the data to grow by 1 TB per year. They need to keep write latency under 10 ms. What storage configuration should they choose?

   • AUse SSD storage with sufficient capacity for the projected growth.
   • BUse HDD storage with automatic storage increases.
   • CUse HDD storage to reduce cost, as the workload is write-heavy.
   • DUse SSD storage but only provision capacity for the first year.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A retail company runs an e-commerce platform on Cloud SQL for MySQL. They have collected metrics showing that during Black Friday, CPU utilization reaches 95% and query latency spikes to 2 seconds. The marketing team expects a 30% increase in traffic next year. The database administrator wants to ensure the database can handle the peak without performance degradation. What should they do?

   • AIncrease the storage capacity to accommodate the expected growth in data volume.
   • BAdd a read replica to offload read traffic from the primary instance.
   • CUpgrade to a larger machine type with more vCPUs and memory to handle the projected peak load.
   • DEnable automatic storage increases to avoid running out of space during the peak.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the primary purpose of applying a systematic sizing methodology when designing a cloud database solution?

   • ATo simplify the migration process from on-premises to cloud
   • BTo ensure the selected configuration meets both current and future workload requirements
   • CTo minimize the number of database instances required
   • DTo guarantee the lowest possible cost for the database service
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A database team is planning capacity for a new application that will launch in six months. They have no historical data for the new application. Which approach is most appropriate for estimating future workload requirements?

   • AWait until the application launches and then collect metrics
   • BDeploy the largest possible configuration to avoid any future scaling
   • CAssume the workload will remain constant and size for current needs
   • DUse the projected user base and expected transaction rates to model growth
   Reveal Solution Discussion Select an answer first