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 company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?
Options
A
roles/spanner.databaseUser
B
roles/spanner.viewer
C
roles/spanner.databaseReader
D
roles/spanner.backupWriter
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
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
Options
A
Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
B
Use Memorystore to handle your low-latency requirements and for real-time analytics.
C
Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
D
Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
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
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.
4
Question
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that
has high write throughput and provides 99.99% uptime. What should you do?
has high write throughput and provides 99.99% uptime. What should you do?
Options
A
Use Cloud Spanner for data storage.
B
Use Memorystore for data storage.
C
Use Cloud SQL for data storage.
D
Use Bigtable for data storage.
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 are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
Options
A
Use Cloud SQL with an external (public) IP address.
B
Use an in-app embedded database.
C
Use Firestore.
D
Use 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.
Finish Practice?
Are you sure you want to finish? This will end your practice session.