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?
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?
To select a cost-effective solution for relational data on Google Cloud Platform, especially for a small set of operational data in one geographic location, Cloud SQL (MySQL) is appropriate. Cloud SQL supports point-in-time recovery, which requires enabling binary logging. This feature allows you to restore your database to a specific moment in time, which satisfies the need for point-in-time recovery.
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 is correct, as Binary Logging enables Point in Recovery in Cloud SQL
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)
I am preparing for the GCP Associate Engineer exam. If anyone has the entire questions set, please send them to <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="1f7b7673766f317c727e6a6d667e5f78727e7673317c7072">[email protected]</a>
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.
Answe A
for point in recovery - binary logging a is the correct answer
I am preparing for the GCP Associate Engineer exam. If anyone has the entire questions set, please send them to <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="cda6a6aba4a3a8bf8daaa0aca4a1e3aea2a0">[email protected]</a>
Hi, did you receive the entire question set?
A is Correct
A is correct
The answer is A
No need of Cloud Spanner in this scenario. A is correct.
A is right answer!
A is right answer! Get Up-to-date: https://www.pinterest.com/pin/937522847419093171
A is Correct
I agree with A