Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B : Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C : Create a read replica in another region, and promote the read replica if a failure occurs.

D : Enable high availability (HA) for the database to make it regional.

Answer: D

Question 2

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 3

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A : Migrate the databases to Cloud Spanner.

B : Migrate the databases to Cloud SQL, and enable a standby database.

C : Migrate the databases to Compute Engine using regional persistent disks.

D : Migrate the databases to Bare Metal Solution for Oracle.

Answer: B

Question 4

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

A : Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

B : Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

C : Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

D : Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team

Answer: B

Question 5

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Googlerecommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A : Manually scale down the number of nodes after the peak period has passed.

B : Use interleaving to co-locate parent and child rows.

C : Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

D : Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer: D