Answer-first summary for fast verification
Answer: Exports are limited to JSON and Avro formats only., GZIP is the exclusive compression option available.
The incorrect statement is **C. Data can only be exported in JSON or Avro format.** BigQuery supports multiple export formats including CSV, JSON, Avro, Parquet, and ORC, making C false. - **A** is true because BigQuery requires a wildcard for large exports to facilitate sharding. - **B** holds true as Google Cloud Storage is indeed the only supported export destination. - **D** is partially incorrect; while GZIP is a common compression option, BigQuery also supports SNAPPY and DEFLATE, making D a false statement as well. However, C is the most clearly false among the options provided.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which statement regarding data export from BigQuery is incorrect?
A
Exporting over 1 GB of data requires a wildcard in the destination filename for sharding.
B
Google Cloud Storage is the sole supported destination for exports.
C
Exports are limited to JSON and Avro formats only.
D
GZIP is the exclusive compression option available.
No comments yet.