Explanation:
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 and Cloud Spanner pricing.
Ultimate access to all questions.
No comments yet.
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.