Google Professional Cloud Database Engineer Exam Practice Test Instant Access

Question 1

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

AShut down and restart each application.

BWrite a utility to scan database query logs.

CWrite a utility to scan application logs.

DUse query tags to add application-centric database monitoring.

Answer : D

https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

Question 2

Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:

Person A is a database administrator.

Person B is an analyst who generates metric reports.

Application C is responsible for automatic backups.

You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

Aroles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C

Broles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C

Croles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C

Droles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C

Answer : A

https://cloud.google.com/spanner/docs/iam#spanner.backupWriter

Question 3

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

ACreate a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

BUse the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

CCreate a Compute Engine VM, install MySQL on the VM, and then import the dump file.

DCreate an external replica, and use Cloud SQL to synchronize the data to the replica.

Answer : D

https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external

Question 4

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 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?

ABring DB-1 back online.

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

CDelete DB-2 so that DB-1 automatically reverts to the primary instance.

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

Answer : B

If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback

Question 6

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 7

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:

configure where data is stored

control where the encryption keys are stored

govern the access to data

What should you do?

AReplicate Cloud SQL databases across different zones.

BCreate a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.

CAllow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.

DUse features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

Answer : D

https://cloud.google.com/blog/products/identity-security/meet-data-residency-requirements-with-google-cloud