hiexam
google · Professional-Cloud-Database-Engineer · Q425 · multiple_choice · topic_1

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shor…

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
  • A.Identify and optimize slow running queries, or set parallel replication flags.
  • B.Stop all running queries, and re-create the replicas.
  • C.Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
  • D.Edit the primary instance to add additional memory.
Explanation
Selected Answer: A A. Optimize query for resolve replication lag. Docs: https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.