You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

• A.Specify an authorized network with the CIDR range of the VM.
• B.Disable and remove the external IP address assignment.
• C.Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
• D.Disable and remove the internal IP address assignment.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Set up all read replicas in a different region using asynchronous replication.
• B.Set up all read replicas in the same region as the primary instance with synchronous replication.
• C.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.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

• A.Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
• B.Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
• C.Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
• D.Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.

Comment: *

Name: *

Email: *

Verification: *

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

• A.Use Cloud SQL instance monitoring in the Google Cloud Console.
• B.Use log messages produced by Cloud SQL.
• C.Use Query Insights for Cloud SQL.
• D.Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Comment: *

Name: *

Email: *

Verification: *

Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

• A.Migrate applications to Cloud SQL.
• B.Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
• C.Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
• D.Migrate applications and Oracle databases to Compute Engine.

Comment: *

Name: *

Email: *

Verification: *