Exam Associate Data Practitioner topic 1 question 33 discussion

read the question, it says offloading read traffic from the primary database, meaning there would be a read-replica. The best solution for improving Cloud SQL read performance by offloading traffic while minimizing effort and cost is D. Enable automatic backups and create a read replica. Read replicas are specifically designed to offload read traffic with minimal effort in Cloud SQL. Option C (Larger Instance) scales up the primary, not offloading, and can be more expensive. Option B (Memorystore) requires more application code changes and cache management, increasing effort. Option A (Cloud CDN) is less directly applicable to database read offloading and requires significant application changes, making it higher effort and less effective for this purpose. Therefore, Option D provides the most direct, efficient, and cost-effective way to improve read performance by offloading read traffic from your Cloud SQL database.