Official Bank
0/141
Page
1/4
Professional Cloud Database Engineer (Cloud Database Engineer Exam) - Google Cloud Exam Questions
Last updated on June 20, 2026
97%
Exam Compliance
141
Total Questions
1
Question
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
Select 2
Options
A
Create additional read replicas, and partition your analytics users to use different read replicas.
B
Disable replication on the read replica, and set the flag for parallel replication on the read replica.
Re-enable replication and optimize performance by setting flags on the primary instance.
Re-enable replication and optimize performance by setting flags on the primary instance.
C
Create secondary indexes on the replica.
D
Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and
update BigQuery.
update BigQuery.
E
Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
2
Question
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
Options
A
Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
B
Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM,
and deny maintenance periods between November 1 and January 15.
and deny maintenance periods between November 1 and January 15.
C
Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
D
Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
3
Question
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat
Options
A
Use Memorystore for Memcached.
B
Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
C
Use Firestore and ensure that the PersistenceEnabled option is set to true.
D
Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
4
Question
You are designing a database architecture for a global application that stores information about
public parks worldwide. The application uses the database for read-only purposes, and a centralized
batch job updates the database nightly. You want to select an open source, SQL-compliant database.
What should you do?
public parks worldwide. The application uses the database for read-only purposes, and a centralized
batch job updates the database nightly. You want to select an open source, SQL-compliant database.
What should you do?
Options
A
Use Memorystore for Redis with multi-zones within a region.
B
Use Cloud SQL for PostgreSQL with cross-region replicas.
C
Use Bigtable with multi-region clusters.
D
Use Cloud Spanner with multi-region configuration.
Discussion
(0 comments)
to join the discussion
Community Discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
5
Question
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the
discovery phase of your project, you notice that your on-premises server peaks at around 25,000
read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
discovery phase of your project, you notice that your on-premises server peaks at around 25,000
read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
Options
A
Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
B
Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM,
and 4 TB of SSD.
and 4 TB of SSD.
C
Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
D
Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Discussion
(0 comments)
to join the discussion
Community 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.