Skip to content

Deploy scalable and highly available databases in Google Cloud Questions

Practice questions for Deploy scalable and highly available databases in Google Cloud topic in Google Professional Cloud Database Engineer. 41 questions covering this domain.

41 questions10 easy21 medium10 hard
Q1
easy

When you create a new Cloud SQL instance with high availability enabled, what type of instance is created?

Q2
hard

A platform team wants a highly available multi-region Bigtable deployment. Which statement is correct?

Q3
easy

Which Spanner deployment option provides the highest availability among single-region, dual-region, and multi-region?

Q4
hard

A write-heavy Spanner workload now serves most writers from a new geographic area. What should architects do to reduce write latency?

Q5
easy

What action does Google recommend for seeing how an application responds to a Cloud SQL failover event?

Q6
medium

When specifying zones for a Cloud SQL high-availability instance, what must be true if both the primary and secondary zones are specified?

Q7
medium

Which AlloyDB component provides horizontal read scaling by adding multiple read nodes to a cluster?

Q8
medium

For Firestore, which choice directly determines data residence and the latency-resiliency tradeoff for the database?

Q9
medium

An application needs Cloud SQL read capacity close to users in another region and wants extra disaster recovery capability against a regional failure....

Q10
medium

An AlloyDB deployment needs disaster recovery and read distribution from another region. Which architecture best meets that requirement?

Q11
medium

A Spanner instance needs to be sized for a new workload. The team is unsure of the correct processing unit count. Which tool provides data-driven reco...

Q12
medium

An AlloyDB cluster must have its primary instance in a different zone than the read pool for zone-level fault tolerance. Which AlloyDB topology featur...

Q13
easy

Which Firestore mode is recommended for new mobile and web applications that benefit from real-time listeners and offline support?

Q14
medium

An application needs to scale Cloud SQL read capacity without increasing primary write load, and the read replicas must be in the same region as the p...

Q15
medium

A company wants AlloyDB to automatically increase instance vCPUs and memory when workload demands rise, without downtime. Which AlloyDB capability imp...

Q16
hard

A production Bigtable instance is experiencing p99 read latency increases despite low CPU. The team suspects a load imbalance across tablets. Which ac...

Q17
hard

A Cloud SQL for MySQL instance fails over to the standby. After failover, the team notices the former primary becomes the new standby. An engineer wan...

Q18
easy

Which action must be taken after enabling high availability on a Cloud SQL instance for the failover capability to be ready?

Q19
medium

Which Bigtable configuration change is required to enable cross-cluster replication?

Q20
medium

A Cloud SQL HA instance fails over from zone A (primary) to zone B (standby). After the failover, a DBA wants to return the primary to zone A. What ac...

Sign in to see all 41 questions

Create a free account to browse all questions — completely free during our launch phase.