UUS Practice Tests⌕ Search
IT Certifications

Google Cloud Cloud Database Engineer Certification Exam Practice Test

The Google Cloud Cloud Database Engineer Certification Exam concerns the design and operation of database systems on Google Cloud. Relevant work includes selecting relational or document-oriented storage, managing connections and private network access, planning migrations, and handling database changes, replicas, and encryption keys in application environments.

Exam overview

Exam providerGoogle Cloud
Exam codeNot listed
CategoryIT Certifications

About the Google Cloud Cloud Database Engineer Certification Exam

Database engineering decisions include matching data models and transaction needs to services such as Cloud SQL, Cloud Spanner, and managed document databases. Operational scenarios can involve using change streams to capture Spanner updates, pooling Cloud SQL connections for short-lived requests, and accounting for replication lag when applications read from replicas. Security considerations include replacing repository-stored passwords with managed secret handling and understanding how customer-managed encryption key availability affects database access. Migration planning also involves balancing compatibility and application changes against modernization goals. Practice with these scenarios by identifying the workload constraint first, then comparing service capabilities, consistency behavior, connectivity, and operational tradeoffs.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

An application needs to read changes from a Cloud Spanner database and send them to downstream processing without repeatedly querying entire tables. Which Spanner capability is intended for tracking data changes?

  1. AChange streams
  2. BSecondary indexes
  3. CPoint-in-time recovery
  4. DSchema introspection
Show answerCorrect answer: A

Cloud Spanner change streams record changes to database data over time and can be consumed by downstream processing systems. Indexes support query access, while recovery and schema inspection serve different purposes.

Question 2

A Cloud SQL application has many short-lived requests and needs to reuse database connections efficiently. Which option is designed to provide connection pooling for supported Cloud SQL engines?

  1. ACloud SQL Auth Proxy
  2. BCloud SQL managed connection pooling
  3. CCloud Audit Logs
  4. DDatabase Migration Service
Show answerCorrect answer: B

Cloud SQL managed connection pooling can reuse backend connections and reduce connection setup overhead for supported configurations. The Auth Proxy provides secure connectivity, but it is not itself a connection pool.

Question 3

An application authenticates to a database using a long-lived password stored directly in its source repository. What is the best general improvement?

  1. AMove credentials to a managed secret store and restrict access through IAM
  2. BCommit the password to a private repository instead
  3. CReuse the same password across all environments
  4. DDisable database authentication
Show answerCorrect answer: A

Keeping credentials in a managed secret store and granting access only to authorized identities reduces exposure and supports controlled rotation. A private repository does not make embedded credentials safe, and reusing passwords increases the impact of compromise.

Question 4

An application stores flexible documents and needs a managed NoSQL database with document-oriented data modeling and automatic scaling options. Which service is a suitable choice?

  1. AFirestore
  2. BCloud SQL
  3. CCloud Spanner
  4. DBigQuery
Show answerCorrect answer: A

Firestore is a managed document database suited to flexible document data models and can scale to application demand. Cloud SQL and Spanner are relational databases, while BigQuery is primarily an analytical data warehouse.

Question 5

An application running on Google Cloud must connect to a database in a private network in another environment. Which general networking capability can provide private connectivity between the networks?

  1. ACloud VPN or Cloud Interconnect, depending on connectivity requirements
  2. BA public DNS record alone
  3. CA database index
  4. DA Cloud Storage lifecycle rule
Show answerCorrect answer: A

Cloud VPN and Cloud Interconnect are options for private network connectivity between environments. The choice depends on factors such as bandwidth, availability, latency, and whether an encrypted tunnel or dedicated connectivity is required.

Question 6

A team is choosing between a relational database and a document database for records whose fields vary substantially between entities and are commonly retrieved as whole documents by identifier. Which design consideration favors a document database?

  1. AThe data is naturally represented as flexible, self-contained documents
  2. BEvery record must participate in multi-table joins
  3. CThe workload requires fixed relational constraints across many tables
  4. DThe data must be processed only as SQL analytical scans
Show answerCorrect answer: A

A document database is often a natural fit when records are self-contained, have variable fields, and are commonly accessed as whole documents. Strong relational constraints and join-centered models may favor a relational system, while large analytical scans may favor an analytics platform.

Question 7

A team wants to use a read replica for queries that can tolerate some delay behind the primary database. What should the team account for when designing the application?

  1. AReplica reads may be stale because replication is asynchronous
  2. BReplica reads always include uncommitted primary transactions
  3. CA read replica automatically replaces the primary for every write
  4. DQueries sent to a replica cannot use SQL
Show answerCorrect answer: A

With asynchronous replication, a read replica can lag behind the primary, so recent writes may not yet be visible. Applications should route only reads that can tolerate this behavior and continue sending writes to the appropriate primary endpoint.

How to use this practice test

The free practice bank contains 50 questions; each session presents up to 20 randomly selected questions. Submit a session to see results, then revisit scenarios where service selection, replication behavior, connectivity, or key management decisions were uncertain.

Preparation tips

  • Compare Cloud SQL, Cloud Spanner, and document databases by data model, transaction needs, scaling approach, and application compatibility.
  • For change-tracking scenarios, distinguish Spanner change streams from repeated full-table reads and consider how downstream consumers process updates.
  • Work through connection scenarios involving Cloud SQL pooling, short-lived application requests, and private connectivity between networks.
  • When evaluating replicas, account for replication lag and decide which reads can tolerate stale data.
  • Trace the operational consequences of database migrations, repository-stored credentials, and disabled customer-managed encryption keys.
Official sourceOfficial exam page ↗