Google Professional Data Engineer

Get started today

Ultimate access to all questions.

Explanation:

The Excel xlsx file format is not supported for files stored in Cloud Storage when creating external tables in BigQuery. Supported formats include Avro, CSV, newline-delimited JSON, Datastore export files, Firestore export files, ORC, and Parquet files. For more details, refer to Google Cloud's documentation on external data sources.

Explanation:

The Excel xlsx file format is not supported for files stored in Cloud Storage when creating external tables in BigQuery. Supported formats include Avro, CSV, newline-delimited JSON, Datastore export files, Firestore export files, ORC, and Parquet files. For more details, refer to Google Cloud's documentation on external data sources.

Comments (0)

No comments yet.

Get started today

Ultimate access to all questions.

When setting up an external table in BigQuery to access data stored in Cloud Storage, which file format is not supported?

Real Exam

0

A

Avro

5.3%

B

ORC

21.1%

C

Firestore export files

21.1%

D

Excel xlsx format

52.6%

Powered ByGPT 5.4 powered

Comments (0)

No comments yet.