Get to know BigQuery quiz

  1. Which method of getting a sample of rows from my_dataset.my_table minimizes query and storage costs?
  2. How does BigQuery determine the bytes processed by a query? Select all that apply.

    Choose as many answers as you see fit.

  3. Fill-in-the-blanks

    Enter one or more words to complete the sentence.

    Use the command ___ to create a dataset named my_quiz_answers.

  4. Which option to the bq load command is used to ignore header rows? Hint- Refer to the bq command-line tool reference.
  5. Fill-in-the-blanks

    Enter one or more words to complete the sentence.

    Query the public dataset with the fully qualified ID ___ (such as some-project.dataset_id.table_id) to supplement your data with two-letter U.S. state codes.

  6. 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.