Professional-Cloud-Database-Engineer Google Exam Questions and Free Practice Test

Question 25

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

A. Restore the Cloud SQL instance from the automatic backups in region 3.

B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instanc

D. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

E. Check your instance operational log for the automatic failover statu

F. Look for time, type, and status of the operation

G. If the failover operation is successful, no action is necessar

H. Otherwise, manually perform gcloud sql instances failover .

Correct Answer:C
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery

Question 26

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

A. Use Cloud Spanner in a regional configuration.

B. Use Cloud Spanner in a multi-region configuration.

C. Use Cloud SQL with cross-region replicas.

D. Use highly available Cloud SQL with multiple zones.

Correct Answer:A
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

Question 27

You plan to use Database Migration Service to migrate data from a PostgreSQL on- premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

A. Drop or disable all users except database administration users.

B. Disable all foreign key constraints on the source PostgreSQL database.

C. Ensure that all PostgreSQL tables have a primary key.

D. Shut down the database before the Data Migration Service task is started.

E. Ensure that pglogical is installed on the source PostgreSQL database.

Correct Answer:CE
https://cloud.google.com/database-migration/docs/postgres/faq

Question 28

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

A. Use Query Insights to identify idle instances.

B. Remove inactive user accounts.

C. Run the Recommender API to identify overprovisioned instances.

D. Build indexes on heavily accessed tables.

Correct Answer:C
The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it. https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned#:~:text=The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendation s on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it.

Question 29

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

A. Enable serializable isolation in the Firebase app.

B. Deploy a US multi-region Firestore location.

C. Build a Firestore bundle, and deploy bundles to Cloud CDN.

D. Create a Firestore index on the news story date.

Correct Answer:C
A global audience strongly suggests serving content via Google’s Content Delivery Network. Changing the isolation level won’t decrease cost or latency

Question 30

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

A. Use Identity and Access Management (IAM) authentication.

B. Use Managed Active Directory authentication.

C. Use Cloud SQL federated queries.

D. Use PostgreSQL database's built-in authentication.

Correct Answer:A
https://cloud.google.com/sql/docs/postgres/authentication

START Professional-Cloud-Database-Engineer EXAM