Free Online Google Professional-Cloud-Database-Engineer Practice Test

Prepare Your Google Professional-Cloud-Database-Engineer Exam Questions with Free online Professional-Cloud-Database-Engineer Practice Test. Get Brilliant Professional Cloud Database Engineer Exam Results with Valid Professional Cloud Database Engineer Exam Dumps.

Page: 1 / 25

Total 122 Questions | Updated On: Apr 24, 2024

Question 1

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

A : Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B : Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C : Use Database Migration Service to migrate your database.

D : Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Answer: B

Question 2

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.

Answer: C

Question 3

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.

Answer: C

Question 4

Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?

A : Use Cloud Spanner instead of Cloud SQL.

B : Increase the number of CPUs for your instance.

C : Increase the storage size for the instance

D : Use many smaller Cloud SQL instances.

Answer: A

Question 5

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

A : Bring DB-1 back online.

B : Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C : Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D : Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer: C

Page: 1 / 25

Total 122 Questions | Updated On: Apr 24, 2024