Study with Google : Professional-Cloud-Database-Engineer Exam Torrent as your best preparation materials

You have a Cloud SQL for MySQL Enterprise instance with four read replicas. Your next scheduled maintenance event is scheduled tomorrow at 6-PM. Your security team identifies an important security vulnerability. You are notified by your management at 8-PM today to update your primary instance and all four read replicas during approved business downtime today at 11- PM. What should you do-

• A. Reschedule the upcoming scheduled maintenance of the primary instance to apply updates immediately.
• B. Reschedule the upcoming scheduled maintenance to happen today at 11-PM.
• C. Perform self-service maintenance on the selected read replicas.
• D. Perform self-service maintenance on the primary instance during scheduled business downtime.

You are migrating your critical production database from Amazon RDS for MySQL to Cloud SQL for MySQL by using Google Cloud's Database Migration Service. You want to keep disruption to your production database to a minimum and, at the same time, optimize migration performance.
What should you do-

• A. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.
• B. Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.
• C. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.
• D. Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do-

• A. Implement Bigtable with replication across multiple regions and configure to prioritize data accuracy.
• B. Create an AlloyDB instance in HA mode with a cross-region read replica.
• C. Create a Spanner instance across regions for optimal performance.
• D. Create a Cloud SQL instance in HA mode with a cross-region read replica.

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than
5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

• A. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
• B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
• C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
• D. Set your production instance's maintenance window to non-business hours.

You run a toy sales ecommerce application on Spanner. The application contains details about the various product listings such as name, category, description, and review(s). Your leadership wants to enable customers to ask free-form questions about the product catalog. You want to implement this functionality in the easiest, quickest, and least expensive way possible.
What should you do?

• A. Create, train and deploy a custom ML model(s). Fetch toy details from Spanner and invoke ML predictions from the application layer to return the response.
• B. Register an existing Generative AI Vertex model in Spanner. Use the ML.PREDICTfunction to supply the model with a user query along with the product information in a SQL query. Return the response back to the application.
• C. Generate vector embeddings for product information in Spanner. Find the vector with the smallest distance between the users' query and existing product information or review by using the EUCLIDEAN_DISTANCE()function in Spanner. Return the closest product information or review.
• D. Create a Spanner full-text search index. Find the product information or review against the user's question in a SQL query. Return the response back to the application.