nerdexam
GoogleGoogle

PROFESSIONAL-DATA-ENGINEER · Question #316

PROFESSIONAL-DATA-ENGINEER Question #316: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #316. The question stem and answer options stay visible for context.

Submitted by mike_84· Mar 30, 2026Designing data processing systems

Question

You migrated a data backend for an application that serves 10 PB of historical product data for analytics. Only the last known state for a product, which is about 10 GB of data, needs to be served through an API to the other applications. You need to choose a cost-effective persistent storage solution that can accommodate the analytics requirements and the API performance of up to 1000 queries per second (QPS) with less than 1 second latency. What should you do?

Options

  • A1. Store the historical data in BigQuery for analytics.
  • B1. Store the products as a collection in Firestore with each product having a set of historical changes.
  • C1. Store the historical data in Cloud SQL for analytics.
  • D1. Store the historical data in BigQuery for analytics.

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

#BigQuery#Data warehousing#Large-scale data storage#Database selection
Full PROFESSIONAL-DATA-ENGINEER PracticeBrowse All PROFESSIONAL-DATA-ENGINEER Questions