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

A is Correct

A is right answer! Get Up-to-date: https://www.pinterest.com/pin/937522847419093171

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.

I am preparing for the GCP Associate Engineer exam. If anyone has the entire questions set, please send them to [email protected]

I am preparing for the GCP Associate Engineer exam. If anyone has the entire questions set, please send them to [email protected]

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