Analyze data with BigQuery quiz

1. You can use BigQuery for all of the following except...
   high-throughput reads of batch and streaming data.

   replacing a mySQL back end as a new transactional database.

   establishing a single source of truth for business-intelligence teams to create and share insights.

   quickly testing the feasibility of machine learning by creating models with SQL.
2. Which of the following is not an object you can create in BigQuery?
   Tables

   Images

   Datasets

   Machine-learning models
3. If you lack a dataset of your own in BigQuery, then you can do which of the following? Select all that apply.

   Choose as many answers as you see fit.

   Explore and use a BigQuery public dataset.
   Upload images and other unstructured datasets into a new BigQuery view.
   Add your IoT-device data in a new table.answer 2
   Upload your dataset from a spreadsheet.
4. Reorder the following SELECT statement clauses so that they make sense.

   Each answer only matches one item.

   1

     WHERE row_condition_met FROM tables SELECT columns ORDER BY sorting_column

   2

     WHERE row_condition_met FROM tables SELECT columns ORDER BY sorting_column

   3

     WHERE row_condition_met FROM tables SELECT columns ORDER BY sorting_column

   4

     WHERE row_condition_met FROM tables SELECT columns ORDER BY sorting_column
5. As a fully managed service, BigQuery eliminates the need to manage which of the following? Select all that apply.

   Choose as many answers as you see fit.

   Provisioning roles and permissions for teams to access your dataset.
   Scaling computation power to run large queries.
   Buying more hard drives for your cluster as storage needs grow.