Google
PROFESSIONAL-DATA-ENGINEER · Question #273
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?
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #273. The question stem and answer options stay visible for context.
Submitted by renata2k· Mar 30, 2026Designing data processing systems
Question
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?
Exhibit
Options
- APartition table data by create_date, location_id and device_version
- BPartition table data by create_date cluster table data by tocation_id and device_version
- CCluster table data by create_date location_id and device_version
- DCluster table data by create_date, partition by location and device_version
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ACID compliance#BigQuery partitioning#clustering#fault tolerance