🔥 40% Off Crucial Exams Memberships — Deal ends today!

1 hour, 53 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

Your team is re-architecting the core reservation system for a global airline running on Google Cloud. The application must store highly structured booking data and let microservices in multiple regions perform thousands of multi-row updates per second while guaranteeing ACID transactions and strong global consistency. Schema evolution must be online, and the database has to scale horizontally with minimal operational overhead. Which managed storage service best meets these requirements?

  • Store bookings in BigQuery partitioned tables with streaming inserts.

  • Use a multi-region deployment of Cloud Spanner.

  • Deploy Cloud SQL for PostgreSQL with cross-region read replicas.

  • Use Cloud Bigtable with multi-cluster routing and export data to BigQuery for analytics.

GCP Professional Data Engineer
Storing the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot