Free Google Professional-Cloud-Database-Engineer Exam Dumps Questions & Answers

You are deploying a Cloud SOL for MySQL database to serve a non-critical application. The database size is
10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read- only traffic from the application during the day. The data locally requirement of This application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?

• A.  Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.
• B.  Create a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance and use the default backup location.
• C.  Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.
• D.  Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance and use a custom backup location to store backups in a Cloud Storage bucket in the same region.

Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

• A.  roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseReader for Person B
  roles/spanner.backupWriter for Application C
• B.  roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseReader for Person B
  roles/spanner.backupAdmin for Application C
• C.  roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseUser for Person B
  roles/spanner.backupWriter for Application C
• D.  roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseUser for Person B
  roles/spanner databaseReader for Application C

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. Youwant to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

• A.  Apply a table data management pattern.
• B.  Apply a database data management pattern.
• C.  Apply a schema data management pattern.
• D.  Apply an instance data management pattern.

Your company is developing a new global transactional application that must be ACID-compliant and have
99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

• A.  Use Bigtable.
• B.  Use Cloud Spanner.
• C.  Use Firestore.
• D.  Use Cloud SQL.

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?

• A.  Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.
• B.  Connect by using the private IP address of the AlloyDB cluster directly from the application.
• C.  Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
• D.  Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.