Google Professional Cloud Database Engineer Question 5
Select 2Google Cloud PlatformYour company is planning to migrate its on-premises transactional database to Google Cloud. To ensure optimal performance and cost-efficiency, you need to analyze relevant variables for database capacity and usage planning. Which two factors should you prioritize during this analysis?
- A
Expected read and write throughput for peak usage periods
- B
The geographic location of end-users accessing the database
- C
The number of tables and their column names in the database schema
- D
Projected database growth over time based on historical trends
- E
The number of indexes currently defined on the tables
Show answer and explanation
Correct answers: A, D
Explanation
Capacity and usage planning requires a focus on measurable factors that impact the database's ability to handle current and future workloads. Expected read/write throughput helps ensure the database can meet performance demands, while projected growth ensures the database can scale appropriately over time without over-provisioning resources.
- A. Correct.
Expected read and write throughput for peak usage periods is a critical factor in capacity planning as it directly affects the database's ability to handle workload spikes and maintain performance.
- B. Incorrect.
While the geographic location of end-users accessing the database is important for reducing latency, it is not directly related to capacity and usage planning for the database itself.
- C. Incorrect.
The number of tables and their column names in the schema are not directly relevant to capacity and usage planning unless they impact storage or performance.
- D. Correct.
Projected database growth over time based on historical trends is crucial for capacity planning to ensure the system can handle future data increases.
- E. Incorrect.
The number of indexes defined on tables is more relevant to query performance optimization rather than overall capacity and usage planning.