Associate Data Practitioner

By Google · Question Mode

QuestionQ27

Data Analysis and Presentation

Your organization stores a petabyte of application logs as Parquet files in Cloud Storage. You need to rapidly conduct a one-time SQL-based analysis of those files and join them with data already in BigQuery. What should you do?

Explanation

BigQuery external tables can reference Parquet files in Cloud Storage and be queried using GoogleSQL like standard BigQuery tables. They are appropriate for one-time, ad hoc queries and can be joined with existing BigQuery tables without first loading the petabyte of files into BigQuery storage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!