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: Jul 14, 2024

Add To Cart

Question 1

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

A : Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream yourdatabase changes to Cloud SQL.Select the Backfill historical data check box on your stream configuration to initiate Datastream tobackfill any data that is out of sync between the source and destination.Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your applicationto use the new instance.

B : Create migration job using Database Migration Service.Set the migration job type to Continuous, and allow the databases to complete the full dump phase andstart sending data in change data capture (CDC) mode.Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, andwait for the migration job to complete.Update your application connections to the new instance.

C : Create migration job using Database Migration Service.Set the migration job type to One-time, and perform this migration during a maintenance window.Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loadedinto the Cloud SQL destination database and the destination database to be promoted to the primarydatabase.Update your application connections to the new instance.

D : Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenancewindow.Move the files to Cloud Storage, and import each database into your Cloud SQL instance.Continue to dump each database until all the databases are migrated.Update your application connections to the new instance.

Answer: C

Question 2

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 3

Your company is developing a global ecommerce website on Google Cloud. Your development team is

working on a shopping cart service that is durable and elastically scalable with live traffic. Business

disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the

application needs to have very low latency writes. You need a data storage solution that has high write

throughput and provides 99.99% uptime. What should you do?

A : Use Cloud SQL for data storage.

B : Use Cloud Spanner for data storage.

C : Use Memorystore for data storage.

D : Use Bigtable for data storage.

Answer: A

Question 4

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

Question 5

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This

application must be able to:

Work with transactions and offer strong consistency.

Work with structured and semi-structured (JSON) data.

Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application. What should you do?

A : Use Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Use Cloud Spanner in a multi-region configuration.

C : Use Firestore in Datastore mode.

D : Use a Bigtable instance with clusters in multiple regions.

Answer: A

Page: 1 / 25

Total 122 Questions | Updated On: Jul 14, 2024

Add To Cart