Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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...