Question 17 of 139
Choose 2Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however,
the additional analytics caused excessive load on the primary database. You created a read replica for the
analytics workloads, but now your users are complaining about the lag in data changes and that their reports are
still slow. You need to improve the report performance and shorten the lag in data replication without making
changes to the current reports. Which two approaches should you implement? (Choose two.)
ACreate secondary indexes on the replica.
✓BCreate additional read replicas, and partition your analytics users to use different read replicas.
✓CDisable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable
replication and optimize performance by setting flags on the primary instance.
DDisable replication on the primary instance, and set the flag for parallel replication on the primary instance.
Re-enable replication and optimize performance by setting flags on the read replica.
EMove your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update
BigQuery.
✓
Correct Answer: B, C
Create additional read replicas, and partition your analytics users to use different read replicas.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.