You are designing a real-time analytics dashboard for a global e-commerce website. The dashboard must update in real-time and should be capable of handling large query loads without impacting the underlying data storage. Which combination of GCP services and features would you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: BigQuery with BigQuery BI Engine and Global HTTP(S) Load Balancer.
Why this is the answer
BigQuery with BigQuery BI Engine and Global HTTP(S) Load Balancer is the best choice. BigQuery is a fully managed, serverless data warehouse ideal for real-time analytics on massive datasets, and BI Engine provides in-memory analysis for sub-second query response times, crucial for a real-time dashboard. The Global HTTP(S) Load Balancer distributes incoming dashboard query requests efficiently across regions, ensuring high availability and low latency for global users without impacting the BigQuery backend. Cloud Spanner is a relational database, not optimized for analytical queries. Firestore is a NoSQL document database, better suited for operational data than analytical workloads. Cloud Bigtable is a NoSQL wide-column database for large analytical and operational workloads, but BigQuery is generally preferred for ad-hoc analytical querying. Traffic Director and Cloud Armor are primarily for service mesh traffic management and security, respectively, not directly for optimizing analytical query performance or global distribution of dashboard requests.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed