Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You are tasked with designing a robust information system that demands an ACID-compliant database to maintain data integrity and support transactions. Ensuring high availability and reliability, your system should also minimize the need for human intervention in the event of any failures. What approach should you take to achieve this goal?
You are tasked with designing a robust information system that demands an ACID-compliant database to maintain data integrity and support transactions. Ensuring high availability and reliability, your system should also minimize the need for human intervention in the event of any failures. What approach should you take to achieve this goal?
Explanation:
The best option to meet the ACID compliance and minimal human intervention requirements is to configure a Cloud SQL for PostgreSQL instance with high availability enabled. Cloud SQL for PostgreSQL provides full ACID compliance, unlike Bigtable which provides only atomicity and consistency guarantees. Enabling high availability removes the need for manual failover as Cloud SQL will automatically failover to a standby replica if the leader instance goes down. Point-in-time recovery in MySQL requires manual intervention to restore data if needed. BigQuery does not provide transactional guarantees required for an ACID database. Therefore, a Cloud SQL for PostgreSQL instance with high availability meets the ACID and minimal intervention requirements best. The automatic failover will ensure availability and uptime without administrative effort.