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

2 hours, 59 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

A global equities trading platform must ingest more than one million trade order updates per second from users on three continents. Each order write must commit in under 10 ms with full ACID semantics and globally consistent reads. Analysts require ad-hoc SQL queries on the full history of trades with less than five-second freshness, but the engineering team wants to avoid managing infrastructure. Which GCP service combination best satisfies both workloads?

  • Ingest both transactional and analytical workloads directly into a partitioned BigQuery dataset using BigQuery Omni.

  • Persist orders in Cloud Spanner and stream Spanner change streams to BigQuery with Dataflow for analytics.

  • Use Cloud SQL with cross-region read replicas for orders and replicate to BigQuery with Datastream.

  • Store orders in Cloud Bigtable and expose the table as an external table for direct querying from BigQuery.

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