Question 1

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

Options :

A : Issue a gcloud sql instances patch command to increase the number of vCPUs.

B : Update a MySQL database flag to increase the number of vCPUs.

C : Issue a gcloud compute instances update command to increase the number of vCPUs.

D : Back up the database, create an instance with additional vCPUs, and restore the database.

Answer: A

Question 2

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

Options :

A : Use replication to roll out changes to higher environments.

B : Use backup and restore to roll out changes to higher environments.

C : Use Liquibase to roll out changes to higher environments.

D : Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Answer: C

Question 3

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.)

Options :

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

Question 4

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Options :

A : Export the data from the existing database, and load the data into a new Cloud SQL database.

B : Use Migrate for Compute Engine to complete the migration.

C : Use Datastream to complete the migration.

D : Use Database Migration Service to complete the migration.

Answer: D

Question 5

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

Options :

A : Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in useast1 and us-west1.

B : Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and uswest1.

C : Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in uscentral1, us-east1, and us-west1.

D : Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, useast1 and us-west1.

Answer: A

Free Professional-Cloud-Database-Engineer Mock Exam – Practice Online Confidently

Buying Options: