Google Professional Data Engineer
Get started today
Ultimate access to all questions.
NO.7 You are designing a system that requires an ACID-compliant database. You must ensure that the system requires minimal human intervention in case of a failure. What should you do?
Real Exam
Community
LLeetQuiz
Explanation:
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. Key reasons:
- Cloud SQL for PostgreSQL provides full ACID compliance, unlike Bigtable which provides only atomicity and consistency guarantees
- High availability enabled removes the need for manual failover as Cloud SQL will automatically failover to a standby replica if the leader instance goes down
- Automatic failover ensures availability and uptime without administrative effort
Other options have limitations:
- Option A: Point-in-time recovery in MySQL requires manual intervention to restore data if needed
- Option C: Bigtable does not provide full ACID compliance required for transactional systems
- Option D: BigQuery does not provide transactional guarantees required for an ACID database
Comments
Loading comments...