Google Professional Cloud Database Engineer Question 2
Select 4Google Cloud PlatformYou are designing a database solution on Google Cloud for an e-commerce platform that expects traffic spikes during sales events. The platform requires low-latency responses, predictable scaling during high-traffic periods, and efficient use of resources during normal traffic levels. Which factors should you analyze to perform proper capacity and usage planning for the database?
- A
The expected read and write throughput during peak traffic periods
- B
The database version and patch-level updates
- C
The expected size of the dataset, including future growth projections
- D
The availability requirements and acceptable recovery time objective (RTO)
- E
The network bandwidth and connectivity between the application and the database
Show answer and explanation
Correct answers: A, C, D, E
Explanation
Proper capacity and usage planning for a database on Google Cloud involves analyzing several key factors, including expected throughput, dataset size, availability requirements, and network considerations. These factors help ensure the database can meet performance and scalability requirements while staying cost-efficient. Database versioning and patch updates, while important, are more related to maintenance rather than capacity planning.
- A. Correct.
Correct. Understanding the expected read and write throughput is critical to ensure the database can handle peak traffic without performance degradation.
- B. Incorrect.
Incorrect. While keeping the database version updated is important for security and features, it is not directly related to capacity and usage planning.
- C. Correct.
Correct. Estimating the size of the dataset and accounting for future growth helps in selecting the appropriate database storage and scaling options.
- D. Correct.
Correct. Availability requirements and the acceptable recovery time objective (RTO) are key factors in planning database capacity and redundancy.
- E. Correct.
Correct. Network bandwidth and connectivity are essential to ensure low-latency communication between the application and the database, particularly during high-traffic periods.