Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

• A.Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
• B.Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
• C.Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
• D.Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Comment: *

Name: *

Email: *

Verification: *

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

• A.Watch Query Insights for long running queries.
• B.Watch the Cloud SQL instance monitor for CPU utilization metrics.
• C.Watch the Cloud SQL recommenders for overprovisioned instances.
• D.Watch Cloud Trace for application requests that are failing.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
• B.Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
• C.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.
• D.Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

Comment: *

Name: *

Email: *

Verification: *

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

• A.Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
• B.Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
• C.Create a clone database from a read replica database, and restore the clone in the same region.
• D.Create a clone database from a read replica database, and restore the clone into a different zone.

Comment: *

Name: *

Email: *

Verification: *

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

• A.Develop a custom data replication service to send data into BigQuery.
• B.Use Cloud SQL federated queries.
• C.Use Database Migration Service to replicate tables into BigQuery.
• D.Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

Comment: *

Name: *

Email: *

Verification: *