Explore public data with BigQuery

1. Which method of getting a sample of rows from the table named "my_dataset.my_table" minimizes query and storage costs?

   Run a query to select all rows, such as "SELECT * FROM my_dataset.mytable;".

   Run a query to select only a few rows, such as "SELECT * FROM my_dataset.mytable LIMIT 10;".

   Expand the dataset named my_dataset from the resources section. Select the table named my_table. Navigate to the "Preview" tab.

   Expand the dataset named my_dataset from the resources section. Select the table named my_table. Export the table to a CSV file.

2. How does BigQuery determine the "bytes processed" by a query?

   Choose as many answers as you see fit.

   The size of the columns used in the query.

   The number of partitions that the query reads from.

   The number of JOIN operations used in the query.

   The number of rows in the final results.

3. Which BigQuery CLI command would you use to create a dataset named "my_quiz_answers"?

   mk my_quiz_answers

   load my_quiz_answers

   bq mk my_quiz_answers

   bq load my_quiz_answers

4. Fill-in-the-blanks

   Enter one or more words to complete the sentence.

   Use the ___ pseudo column to limit the tables read by a wildcard query.

5. Which option to the "bq load" command is used to ignore header rows?

   --ignore_header

   --skip_header_row=True

   --skip_leading_rows

   --ignore_header_rows=1

   --ignore_leading_rows

Submit answers