Professional Cloud Database Engineer (CLOUD-DATABASE-ENGINEER-EXAM) - Google Cloud Actual Exam Questions
Last updated on May 14, 2026
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
Develop a custom data replication service to send data into BigQuery.
Use Cloud SQL federated queries.
Use Database Migration Service to replicate tables into BigQuery.
Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
4XHVWLRQV�DQG�$QVZHUV�3') ����� You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?
Configure Firestore, and modify your application to offload queries.
Configure Bigtable, and modify your application to offload queries.
Configure Cloud SQL for PostgreSQL read replicas to offload queries.
Configure Memorystore, and modify your application to offload queries.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.) 4XHVWLRQV�DQG�$QVZHUV�3') �����
Identify whether the database has over 512 tables.
Identify all tables that do not have a primary key.
Identity all tables that do not have at least one foreign key.
Identify whether the source database is encrypted using pgcrypto extension.
Identify whether the source database uses customer-managed encryption keys (CMEK).
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
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? 4XHVWLRQV�DQG�$QVZHUV�3') �����
Use Query Insights to identify idle instances.
Remove inactive user accounts.
Run the Recommender API to identify overprovisioned instances.
Build indexes on heavily accessed tables.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.