Professional Cloud Database Engineer MYSQL Practice Questions

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

• AA. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
• BB. Edit the instance to change the storage type from HDD to SSD.
• CC. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
• DD. Create a read replica of the instance with SSDs, and perform a failover to the new instance

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

• AA. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
• BB. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
• CC. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
• DD. Create a Cloud Scheduler job to start maintenance at 12 AM on Sunday
• EE. Pause the Cloud Scheduler job between November 1 and January 15.

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

• AA. Set up all read replicas in a different region using asynchronous replication.
• BB. Set up all read replicas in the same region as the primary instance with synchronous replication.
• CC. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
• DD. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.