Google Professional Cloud Database Engineer Exam Practice Test Instant Access

Question 1

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

Question 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

ASet up manual backups.

BCreate a PostgreSQL database on-premises as the HA option.

CConfigure single zone availability for automated backups.

DEnable point-in-time recovery.

ESchedule automated backups.

Answer : D, E

D . Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.

Question 3

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 4

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

AView Cloud SQL operations to view historical query information.

BWhite a Logs Explorer query to identify database queries with high execution times.

CReview application logs to identify database calls.

DUse the Query Insights dashboard to identify high execution times.

Answer : D

A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.

Question 5

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?

ACreate a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill 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 application to use the new instance.

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

CCreate 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 loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.

DUse the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
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 : B

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

Question 6

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

ACreate a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

BCreate a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

CUse the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

DShut down your existing Cloud SQL for MySQL instance, and enable HA.

Answer : C

Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

Question 7

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

AUse external server replication.

BUse Data Migration Service.

CUse Cloud SQL for MySQL external replica.

DUse the mysqldump utility and binary logs.

Answer : C

An external replica is a method that allows you to create a read-only copy of your Cloud SQL instance on an external server, such as a Compute Engine instance or an on-premises database server1. An external replica can help you scale reads and offload management operations from your data center to Google Cloud.You can also use an external replica for disaster recovery, migration, or reporting purposes1.

To create an external replica, you need to configure a Cloud SQL instance that replicates to one or more replicas external to Cloud SQL, and a source representation instance that represents the source database server in Cloud SQL1.You also need to enable access on the Cloud SQL instance for the IP address of the external replica, create a replication user, and export and import the data from the source database server to the external replica1.