A retail company is comparing the cost of running a self-managed PostgreSQL database on Compute Engine versus using Cloud SQL for PostgreSQL. The workload is steady with predictable usage. The company has a policy that requires minimizing total cost of ownership (TCO) over a 3-year period, including operational expenses. Which factor is most important in this cost comparison?

The cost of the Compute Engine VM and attached persistent disks

The cost of network egress for both solutions

The cost of licensing for PostgreSQL in both solutions

The cost of Cloud SQL instances and storage, plus the operational overhead of self-management

An application currently uses a relational database with a complex schema and many stored procedures. When evaluating a new database solution, which dependency is most critical to assess?

The application's use of vector embeddings

The application's compatibility with the existing schema and stored procedures

The application's ability to handle eventual consistency

The application's ability to scale horizontally

A media streaming company uses Cloud SQL for PostgreSQL for user account data and Bigtable for viewing history. They need to generate personalized recommendations that combine user preferences with viewing history. The recommendations must be generated in real-time. Which approach is the best?

Use BigQuery to store all data and run real-time queries

Use Cloud SQL to query Bigtable directly for viewing history

Use a microservice that queries Cloud SQL for user preferences and Bigtable for viewing history, then combines the results in the application

Use Dataflow to continuously stream data from Cloud SQL and Bigtable into BigQuery for analysis

A legal research company is building a chatbot that answers questions based on a large corpus of legal documents. The documents are stored as text files in Cloud Storage. The chatbot needs to retrieve relevant passages and generate answers. Which database solution should they use to support retrieval-augmented generation (RAG)?

Use Firestore to store the documents and perform keyword search

Use AlloyDB with the vector extension to store embeddings and perform similarity search

Use BigQuery to store the documents and run SQL queries for retrieval

Use Cloud SQL for PostgreSQL and store the documents as text columns

Google CloudProfessional Cloud Database Engineer

Domain 1Objective 4

1.4 Evaluate Appropriate Database Solutions on Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Part of the Design innovative, scalable, and highly available cloud database solutions domain, which accounts for ~32% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

31questions here

7free pages

8concepts

~32%of the exam

8 Concepts in This Objective

Managed vs. Unmanaged Database Services
SQL vs. NoSQL Business Requirements
Cost Analysis of Database Solutions
Application and Database Dependencies
Regulatory and Compliance Requirements
Organizational Policies Impact on Database Strategy
Multi-Database Technology Solutions
Database Support for Generative AI and LLMs

Questions 11–15

11expert · hard
A retail company is comparing the cost of running a self-managed PostgreSQL database on Compute Engine versus using Cloud SQL for PostgreSQL. The workload is steady with predictable usage. The company has a policy that requires minimizing total cost of ownership (TCO) over a 3-year period, including operational expenses. Which factor is most important in this cost comparison?
Select an answer first
12foundation · easy
An application currently uses a relational database with a complex schema and many stored procedures. When evaluating a new database solution, which dependency is most critical to assess?
Select an answer first
13expert · hard
A media streaming company uses Cloud SQL for PostgreSQL for user account data and Bigtable for viewing history. They need to generate personalized recommendations that combine user preferences with viewing history. The recommendations must be generated in real-time. Which approach is the best?
Select an answer first
14application · medium
A legal research company is building a chatbot that answers questions based on a large corpus of legal documents. The documents are stored as text files in Cloud Storage. The chatbot needs to retrieve relevant passages and generate answers. Which database solution should they use to support retrieval-augmented generation (RAG)?
Select an answer first
15foundation · easy
A team is designing a database for an application that stores user profiles with a fixed set of attributes (name, email, date of birth) and requires complex SQL queries with joins and transactions. Which type of database is most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.

1.4 Evaluate Appropriate Database Solutions on Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Questions 11–15

An application currently uses a relational database with a complex schema and many stored procedures. When evaluating a new database solution, which dependency is most critical to assess?

A media streaming company uses Cloud SQL for PostgreSQL for user account data and Bigtable for viewing history. They need to generate personalized recommendations that combine user preferences with viewing history. The recommendations must be generated in real-time. Which approach is the best?

A team is designing a database for an application that stores user profiles with a fixed set of attributes (name, email, date of birth) and requires complex SQL queries with joins and transactions. Which type of database is most appropriate?

Keep studying — Design innovative, scalable, and highly available cloud database solutions