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?
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.
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
In this link below, the docs explains clearly that point-in-time recovery requires binary logging.
https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#disk-usage
A. binary logging is uaed to setup point in time recovery. This basically records every single action to the db (crud) and stores on a binary log. So can be used to replicate. Logging like this means you can recover to any point in time rather than just eg 1 months agao when you last backed up - this way you can choose the day instead - ie before the issue occurred. MOre finer grained recovery. add a little latency to to sql response though.
A is correct .................
you need to enable binary logging. Cloud SQL for MySQL supports binary logging, which allows you to perform point-in-time recovery of the database.
**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.
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.
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)
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
YashBindlish
Highly Voted 9 months agoryumada
9 months agoBharathy
Highly Voted 5 years, 2 months agokewgard
Most Recent 2 weeks, 4 days agoAkp965
2 months, 2 weeks agodenno22
8 months, 3 weeks agodenno22
8 months, 1 week agoharsh5kalsait
9 months agoMUNHU
1 year agoEle24
1 year, 4 months agoMiscoMove
1 year, 6 months agothewalker
1 year, 7 months agoBAofBK
1 year, 7 months agoguicane
1 year, 8 months agoEvan7557
1 year, 8 months agoYourCloudGuru
1 year, 9 months agoCaptain1212
1 year, 9 months agoMogamat
1 year, 11 months agoTSEMSOUS
2 years ago