Skip to content

Manage a solution that can span multiple database technologies Questions

Practice questions for Manage a solution that can span multiple database technologies topic in Google Professional Cloud Database Engineer. 51 questions covering this domain.

51 questions13 easy26 medium12 hard
Q1
medium

A team already connects to Cloud SQL through private IP and wants the lowest-latency connection path. According to Google guidance, which approach is ...

Q2
medium

A DBA wants to manage Cloud SQL access with IAM users and service accounts using short-lived access tokens instead of database passwords. Which authen...

Q3
medium

A platform team manages AlloyDB, Cloud SQL, Firestore, Bigtable, and Spanner across many projects and wants one place to see fleet health issues and r...

Q4
medium

A Cloud SQL deployment stores regulated data and must stay off the public internet for application connectivity. Which IP configuration should the tea...

Q5
easy

Which Google Cloud service should operators use to monitor metrics such as CPU, memory, connections, and replication lag for database instances?

Q6
hard

A DBA manually triggers failover on a Cloud SQL high-availability instance and then cannot find failover metrics for that event. What is the most like...

Q7
hard

A retail platform needs one database for a globally consistent order ledger, one for massive low-latency event ingestion, and one for real-time mobile...

Q8
medium

A security team wants backups that are protected from modification and early deletion so they can recover after ransomware or accidental deletion. Whi...

Q9
medium

An application connects to Cloud SQL over public IP from ephemeral client IP addresses and wants automatic traffic encryption and IAM token refresh. W...

Q10
medium

For audit trails and database error investigation, which service should engineers inspect?

Q11
easy

Which cost option is intended to lower the price of predictable long-term AlloyDB or Spanner usage in exchange for a one- to three-year commitment?

Q12
easy

Which Cloud SQL connection option provides secure access without needing authorized networks or manual SSL configuration in a test environment?

Q13
hard

An enterprise needs centralized backup governance for multiple workloads and the ability to recover a protected workload into a different project duri...

Q14
easy

Which Google Cloud service is the recommended connector for securely connecting to Cloud SQL instances using IAM authentication without whitelisting I...

Q15
hard

An operations team wants to use a Spanner change stream to propagate data changes to downstream systems in near real time. Which Google Cloud service ...

Q16
easy

Which Cloud SQL backup type captures only data changed since the last backup and reduces backup time?

Q17
medium

A security team wants Cloud SQL database connections to use only encrypted TLS connections and reject clients that present a certificate that does not...

Q18
medium

A team wants to receive alerts when Cloud SQL CPU utilization exceeds 80% for more than 5 minutes. Which service should they configure?

Q19
medium

A DBA wants to rotate the password for a Cloud SQL user without restarting the instance. Which Cloud SQL capability allows changing a database user pa...

Q20
hard

A DBA finds that a Cloud SQL for PostgreSQL instance serving high concurrent short queries has frequent `too many connections` errors. The application...

Sign in to see all 51 questions

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