Exam Associate Cloud Engineer topic 1 question 3 discussion

A is Correct. 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

A is correct, as Binary Logging enables Point in Recovery in Cloud SQL

https://cloud.google.com/sql/docs/mysql/backup-recovery/restore#tips-pitr

**Best Choice: A** Cloud SQL (MySQL) with binary logging enabled will provide point-in-time recovery capabilities, which meet your requirement for relational data in a single geographic location. It is also cost-effective for smaller datasets compared to Cloud Spanner.

I agree with A

A is Correct

A is right answer!

No need of Cloud Spanner in this scenario. A is correct.

The answer is A

A is correct

A is Correct

Correct answer is A. Cloud SQL is a fully-managed relational database service that supports MySQL, PostgreSQL, and SQL Server. It offers high availability, automatic backups, and point-in-time recovery. By enabling binary logging, you can restore your database to a specific point in time. Cloud SQL is a cost-effective solution for small sets of operational data in one geographic location. It is also a good choice for developers who are familiar with MySQL.

for point in recovery - binary logging a is the correct answer

Answe A

A is the correct answer Answer A: small set of operational data in one geographic location - CloudSQL (Cloud Spanner generally to hold large data and global)

Option A: https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr Perform the point-in-time recovery using binary log positions While we recommend you perform point-in-time recovery using timestamps as described in the previous procedure, you can also perform point-in-time recovery by providing a specific binary log position in a binary log file.

Binary logging and Cloud SQL is correct fit