The correct answers are:
- B. Load data with nested and repeated fields: The BigQuery Web UI supports loading data with nested and repeated fields directly from CSV or JSON files.
- D. Upload a 20 MB file: The BigQuery Web UI permits uploading files up to 20 MB in size.
Here’s why the other options are incorrect:
- A. Upload multiple files using a wildcard: This functionality is not supported in the BigQuery Web UI. Instead, you can use the
bq load
command-line tool or the BigQuery API for this purpose.
- C. Upload a file in SQL format: The BigQuery Web UI does not support uploading files in SQL format. However, you can create tables and load data using SQL queries directly in the BigQuery console.
In summary, the BigQuery Web UI allows for loading data with nested and repeated fields and uploading files up to 20 MB in size.