Google Professional Cloud Database Engineer Exam Questions Instant Access

Question 1

You are setting up a new AlloyDB instance and want users to be able to use their existing identity and Access Managemen (IAM) identities to connect to AlloyDB. You have performed the following steps:

Manually enabled IAM authentication on the AlloyDB instance

Granted the allowdb-databaseUser and serviceusage.serviceusageConsumer IAM roles to the users

Created new AllowDB database users based on corresponding IAM identities

Users are able to connect but are reporting that they are not able to SELECT from application tables. What should you do?

AGrant the alloydb.client IAM role to each user.

BGrant the alloydb.viewer IAM role to each user.

CGrant the new database users access privileges to the appropriate tables.

DGrant the alloydb.alloydbreplica IAM role to each user.

Answer : C

Question 2

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

AOpen a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

BUse Cloud SQL maintenance settings to prevent any maintenance during the month of December.

CCreate MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

DCreate a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Answer : B

https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr

Question 3

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

ANormalize the database to the third normal form.

BCompress the data using a different compression algorithm.

CManually or automatically increase the storage capacity.

DCreate another schema to load older data.

Answer : C

https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen

Question 4

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.

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

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 7

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat

a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

AUse Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

BUse sharded Cloud SQL instances with one or more stores per database instance.

CUse a Biglable cluster with autoscaling.

DUse Cloud Spanner with a custom autoscaling solution.

Answer : D

https://cloud.google.com/spanner/docs/autoscaling-overview

1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud