Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Dumps

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 synchronous replication, and set up read replicas in different regions with asynchronous replication.

D. 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.

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

A. 1. Create your instance with a specified external (public) IP address.

2.

Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.

3.

Use Cloud SQL Auth proxy to connect to the instance.

B. 1. Create your instance with a specified external (public) IP address.

2.

Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.

3.

Connect to the instance using a connection pool to best manage connections to the instance.

C. 1. Create your instance with a specified internal (private) IP address.

2.

Choose the VPC with private service connection configured.

3.

Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.

4.

Use Cloud SQL Auth proxy to connect to the instance.

D. 1. Create your instance with a specified internal (private) IP address.

2.

Choose the VPC with private service connection configured.

3.

Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.

4.

Connect to the instance using a connection pool to best manage connections to the instance.

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

A. Apply a schema data management pattern.

B. Apply an instance data management pattern.

C. Apply a table data management pattern.

D. Apply a database data management pattern.