Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
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?
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.