PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #131
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #131: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #131. The question stem and answer options stay visible for context.
Question
Your 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.)
Options
- 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.
- DDisable replication on the primary instance, and set the flag for parallel replication on the primary
- EMove your analytics workloads to BigQuery, and set up a streaming pipeline to move data and
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.