Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
You are tasked with choosing and setting up an economically efficient solution for managing relational data on Google Cloud Platform. The scope of your project involves a limited amount of operational data localized to a single geographic area. Additionally, it is critical to implement a system that supports point-in-time recovery for data protection. What approach should you take?
Exam-Like
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.
Explanation:
The 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, which is crucial for point-in-time recovery. This makes Cloud SQL a cost-effective solution for small sets of operational data in one geographic location.
Comments
Loading comments...