You want to select and configure a cost-effective solution for relational data on Google Cloud Platform. You are working with a small set of operational data in one geographic location. You need to su

The correct answer is A. Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.. You must enable binary logging to use point-in-time recovery. Enabling binary logging causes a slight reduction in write performance. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

Submitted by kavita_s· Mar 30, 2026Planning and configuring a cloud solution

Question

You want to select and configure a cost-effective solution for relational data on Google Cloud Platform. You are working with a small set of operational data in one geographic location. You need to support point- in-time recovery. What should you do?

Options

ASelect Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
BSelect Cloud SQL (MySQL). Select the create failover replicas option.
CSelect Cloud Spanner. Set up your instance with 2 nodes.
DSelect Cloud Spanner. Set up your instance as multi-regional.

How the community answered

(30 responses)

A
80% (24)
B
10% (3)
C
3% (1)
D
7% (2)

Explanation

You must enable binary logging to use point-in-time recovery. Enabling binary logging causes a slight reduction in write performance. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

Topics

#Cloud SQL#point-in-time recovery#binary logging#relational database

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice