Answer-first summary for fast verification
Answer: Utilize Cloud SQL (MySQL) and activate the binary logging feature.
**A is correct** because enabling binary logging in Cloud SQL (MySQL) is essential for point-in-time recovery. This feature logs all changes to the database, enabling restoration to any specific moment before data loss or corruption occurred. **B is incorrect** as failover replicas enhance availability but do not support point-in-time recovery. **C and D are incorrect** because Cloud Spanner, while offering scalability and global distribution, is not cost-effective for small, single-region datasets. For more details, refer to [Cloud SQL PITR](https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr) and [Cloud Spanner pricing](https://cloud.google.com/spanner/pricing).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your logistics company aims to reduce Google Cloud Platform (GCP) expenses and seeks a budget-friendly solution for managing relational data. The company's daily operations involve a small dataset for package tracking, all located within a single geographic area. A critical requirement is the ability to perform point-in-time recovery. What is the best course of action?
A
Utilize Cloud SQL (MySQL) and activate the binary logging feature.
B
Opt for Cloud SQL (MySQL) and enable the creation of failover replicas.
C
Deploy a Cloud Spanner instance configured with 2 nodes.
D
Choose Cloud Spanner and configure your instance to be multi-regional.
No comments yet.