A company wants to keep its on-premises database as the system of record but also use a cloud database for analytics. Which approach supports this hybrid deployment?

Use database sharding to split data between on-premises and cloud

Export data from the on-premises database to the cloud database on a scheduled basis

Use only the cloud database and decommission the on-premises database

Use database federation to query both databases in real time

A financial services company is evaluating database options for a new application. The workload is predictable with steady usage during business hours and low usage at night. The company has a strict procurement policy that favors minimizing operational overhead and capital expenditure. They expect the application to run for at least 5 years. Which database solution is most cost-effective among the listed options?

Provision a large Compute Engine VM with a self-managed PostgreSQL instance running 24/7

Use BigQuery as the primary database for all transactions

Use Cloud SQL for PostgreSQL with a small instance and enable automatic storage scaling

Use Cloud Spanner with a multi-region configuration for maximum availability

A large enterprise has an organizational policy that all database services must be procured through a specific partner marketplace and must support customer-managed encryption keys (CMEK). The team is evaluating a new application that requires a NoSQL document database. Which database solution should they choose?

Use Bigtable, which is a NoSQL database and supports CMEK

Use Cloud SQL for PostgreSQL, which supports CMEK

Deploy MongoDB on Compute Engine with self-managed encryption

Use Firestore, which is available in the marketplace and supports CMEK

When comparing the total cost of running a self-managed database on Compute Engine versus a fully managed database service, which cost factor is often underestimated?

The cost of egress networking between the database and application

The cost of the VM instance and attached persistent disks

The cost of the database software license

The operational cost of patching, backups, and monitoring

A database workload has predictable, steady-state usage. Which pricing model is likely to provide the lowest cost among the listed options?

On-demand pricing with no commitments

Committed use discounts with a 1-year or 3-year commitment

Serverless pricing with per-request billing

Google CloudProfessional Cloud Database Engineer

Domain 1Objective 4

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

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 26–30

26foundation · easy
A company wants to keep its on-premises database as the system of record but also use a cloud database for analytics. Which approach supports this hybrid deployment?
Select an answer first
27application · medium
A financial services company is evaluating database options for a new application. The workload is predictable with steady usage during business hours and low usage at night. The company has a strict procurement policy that favors minimizing operational overhead and capital expenditure. They expect the application to run for at least 5 years. Which database solution is most cost-effective among the listed options?
Select an answer first
28application · medium
A large enterprise has an organizational policy that all database services must be procured through a specific partner marketplace and must support customer-managed encryption keys (CMEK). The team is evaluating a new application that requires a NoSQL document database. Which database solution should they choose?
Select an answer first
29foundation · easy
When comparing the total cost of running a self-managed database on Compute Engine versus a fully managed database service, which cost factor is often underestimated?
Select an answer first
30foundation · easy
A database workload has predictable, steady-state usage. Which pricing model is likely to provide the lowest cost among the listed options?
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 6)

Questions 26–30

A company wants to keep its on-premises database as the system of record but also use a cloud database for analytics. Which approach supports this hybrid deployment?

When comparing the total cost of running a self-managed database on Compute Engine versus a fully managed database service, which cost factor is often underestimated?

A database workload has predictable, steady-state usage. Which pricing model is likely to provide the lowest cost among the listed options?

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