menu
arrow_back

Build and Optimize Data Warehouses with BigQuery: Challenge Lab

—/100

Checkpoints

arrow_forward

Create a table partitioned by date

Correctly add appropriate columns to table

Populate the population column

Populate the country_area column

Populate the mobility STRUCT

Query missing data in population & country_area columns

Build and Optimize Data Warehouses with BigQuery: Challenge Lab

1 hour 30 minutes 9 积分

GSP340

Google Cloud Self-Paced Labs

Overview

In a challenge lab you’re given a scenario and a set of tasks. Instead of following step-by-step instructions, you will use the skills learned from the labs in the quest to figure out how to complete the tasks on your own! An automated scoring system (shown on this page) will provide feedback on whether you have completed your tasks correctly.

When you take a challenge lab, you will not be taught new Google Cloud concepts. You are expected to extend your learned skills, like changing default values and reading and researching error messages to fix your own mistakes.

To score 100% you must successfully complete all tasks within the time period!

This lab is recommended for students enrolled in the Build and Optimize Data Warehouses with BigQuery Quest.

Topics tested

  • Use BigQuery to access public COVID and other demographic datasets.
  • Create a new BigQuery dataset which will store your tables.
  • Add a new date partitioned table to your dataset.
  • Add new columns to this table with appropriate data types.
  • Run a series of JOINS to populate these new columns with data drawn from other tables.

Setup

Before you click the Start Lab button

Read these instructions. Labs are timed and you cannot pause them. The timer, which starts when you click Start Lab, shows how long Google Cloud resources will be made available to you.

This Qwiklabs hands-on lab lets you do the lab activities yourself in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials that you use to sign in and access Google Cloud for the duration of the lab.

What you need

To complete this lab, you need:

  • Access to a standard internet browser (Chrome browser recommended).
  • Time to complete the lab.

Note: If you already have your own personal Google Cloud account or project, do not use it for this lab.

Note: If you are using a Chrome OS device, open an Incognito window to run this lab.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Google Cloud Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab