Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Google
  5. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam
Professional Cloud Database Engineer (Page 11 )

Updated On: 1-Feb-2026
Page 5 of 28
PDF with 182 Questions

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead.
What should you do?

  1. Create a VM in Compute Engine, and run a cron job.
  2. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
  3. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
  4. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

Answer(s): C

Explanation:

Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured.


Reference:

https://cloud.google.com/tasks/docs/comp-tasks-sched



You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.

What should you do?

  1. Use gcloud sql instances failover <PrimaryInstanceName>.
  2. Use gcloud sql instances failover <ReplicaInstanceName>.
  3. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
  4. Use gcloud sql instances promote-replica <ReplicaInstanceName>.

Answer(s): A



Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible.
What should you do?

  1. Migrate all the databases to Cloud SQL.
  2. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
  3. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
  4. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Answer(s): D



Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration.
What should you do?

  1. Migrate the Oracle databases to Cloud Spanner.
  2. Migrate the Oracle databases to Compute Engine.
  3. Migrate the Oracle databases to Cloud SQL.
  4. Migrate the Oracle databases to Bare Metal Solution for Oracle.

Answer(s): D

Explanation:

This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.



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?

  1. Use Cloud Spanner in a regional configuration.
  2. Use Cloud Spanner in a multi-region configuration.
  3. Use Cloud SQL with cross-region replicas.
  4. Use highly available Cloud SQL with multiple zones.

Answer(s): A

Explanation:

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



Viewing page 11 of 28
Viewing questions 51 - 55 out of 182 questions



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam prep with other Community members:

Join the PROFESSIONAL-CLOUD-DATABASE-ENGINEER Discussion