You have 20 TB of CSV text files and multiple users will run aggregate queries using various engines; which storage service and schema minimizes query cost?
Choose an answer
Tap an option to check your answer.
Correct answer: Store in Cloud Storage and expose as permanent external tables in BigQuery for querying..
Why this is the answer
Storing the 20 TB of CSV files in Cloud Storage is cost-effective for large datasets and allows direct access by various engines. Exposing them as permanent external tables in BigQuery enables powerful, serverless SQL querying without data ingestion, minimizing query costs as BigQuery only scans the necessary data. This approach also centralizes metadata for easy management and sharing among multiple users. Cloud Bigtable is a NoSQL wide-column store, not optimized for aggregate queries on CSV text files, making it an unsuitable choice. Using temporary tables in BigQuery would require re-creating the table definition for each session, increasing overhead and management complexity, especially for multiple users and frequent queries.
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