Google Cloud Associate Cloud Engineer — Question 19

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?

Answer options

• A. Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
• B. Select Cloud SQL (MySQL). Select the create failover replicas option.
• C. Select Cloud Spanner. Set up your instance with 2 nodes.
• D. Select Cloud Spanner. Set up your instance as multi-regional.

Correct answer: A

Explanation

The correct answer is A because enabling binary logging in Cloud SQL (MySQL) allows for point-in-time recovery, which is essential for your requirements. Option B does not address point-in-time recovery directly. Options C and D involve Cloud Spanner, which is more complex and costly than necessary for a small set of operational data in one location.