Google Professional Cloud Database Engineer Exam Questions Instant Access

Question 1

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

ACreate one regional Cloud SQL instance with a read replica in another region.

BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.

DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Answer : B

This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover.According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure.If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

Question 2

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat

a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

AConfigure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

BCreate your database with one primary node and one read replica in the region.

CEnable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

DConfigure your Cloud SQL instance with high availability enabled.

Answer : A

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

Question 3

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

ATake no backups, and turn off transaction log retention.

BTake one manual backup per day, and turn off transaction log retention.

CTurn on automated backup, and turn off transaction log retention.

DTurn on automated backup, and turn on transaction log retention.

Answer : C

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

Question 4

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

AOpen the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

BReload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

CPerform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

DFail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

Answer : C

Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions

Question 5

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

AConfigure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

BConfigure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

CConfigure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

DConfigure the primary, standby, and read replica instances in zone A, all in the same region.

Answer : A

https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview

Question 6

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?

ASet up all read replicas in a different region using asynchronous replication.

BSet up all read replicas in the same region as the primary instance with synchronous replication.

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

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

Answer : C

This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1.This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.

This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2.This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.

Question 7

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

AReuse the existing service account that populates this database.

BCreate a new service account, and grant it the Cloud Spanner Database Admin role.

CCreate a new service account, and grant it the Cloud Spanner Database Reader role.

DCreate a new service account, and grant it the spanner.databases.select permission.

Answer : C

https://cloud.google.com/iam/docs/overview