A startup wants to run a PostgreSQL database on Google Cloud with the least possible operational overhead for patching, backups, and high availability. Which option best meets this requirement?

Use a partner-managed PostgreSQL offering that requires you to handle your own backups

Run PostgreSQL on a bare metal server in a colocation facility

Deploy PostgreSQL on a Compute Engine VM and manage the database yourself

An e-commerce company uses Cloud SQL for PostgreSQL for transactional order data and BigQuery for analytics. They need to generate daily reports that combine order details with product metadata. The product metadata is stored in a separate Cloud Storage bucket as JSON files. Which approach should they use to create the reports?

Export Cloud SQL data to Cloud Storage, then load it into BigQuery and join with the JSON data

Use Cloud SQL to query BigQuery and Cloud Storage directly

Use Dataflow to copy all data into a single Cloud SQL instance and run reports there

Use BigQuery to query Cloud SQL directly via federated queries and join with external tables on Cloud Storage

A government agency has a policy that all database services must be procured through a specific partner and must support data residency within the country. They are evaluating a new application that requires a relational database with strong consistency. Which database solution is the best choice?

Use Firestore in a region within the country

Use Cloud SQL for PostgreSQL in a region within the country, procured through the partner

Use BigQuery in a region within the country

Use Cloud Spanner in a multi-region configuration that includes the country

A startup is building a mobile app that needs a database for user profiles and settings. The data is semi-structured and the team expects rapid iteration on the data model. They have a small team and want to minimize operational overhead. Which database solution is the best fit?

Use Bigtable, which is a managed NoSQL database with automatic scaling

Use Cloud SQL for PostgreSQL with a flexible schema

Use Firestore, which is a managed NoSQL document database with automatic scaling

Use Cloud Spanner, which is a managed relational database with automatic scaling

An application needs to find documents that are semantically similar to a user's query. Which database technology is designed for this use case?

A relational database with full-text search

Google CloudProfessional Cloud Database Engineer

Domain 1Objective 4

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

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 16–20

16foundation · easy
A startup wants to run a PostgreSQL database on Google Cloud with the least possible operational overhead for patching, backups, and high availability. Which option best meets this requirement?
Select an answer first
17application · medium
An e-commerce company uses Cloud SQL for PostgreSQL for transactional order data and BigQuery for analytics. They need to generate daily reports that combine order details with product metadata. The product metadata is stored in a separate Cloud Storage bucket as JSON files. Which approach should they use to create the reports?
Select an answer first
18expert · hard
A government agency has a policy that all database services must be procured through a specific partner and must support data residency within the country. They are evaluating a new application that requires a relational database with strong consistency. Which database solution is the best choice?
Select an answer first
19application · medium
A startup is building a mobile app that needs a database for user profiles and settings. The data is semi-structured and the team expects rapid iteration on the data model. They have a small team and want to minimize operational overhead. Which database solution is the best fit?
Select an answer first
20foundation · easy
An application needs to find documents that are semantically similar to a user's query. Which database technology is designed for this use case?
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.