Google Professional Data 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.
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
A
Configure a Cloud SQL for MySQL instance with point-in-time recovery enabled.
B
Configure a Cloud SQL for PostgreSQL instance with high availability enabled.
C
Configure a Bigtable instance with more than one cluster.
D
Configure a BigQuery table with a multi-region configuration.
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...