Build a Data Warehouse with BigQuery: Challenge Lab Reviews

Task 1 should explicitly say that the expiration date relates to the partition and not to the table. The current wording is confussing.

José S. · Reviewed 2 yıldan fazla ago

Oluwaseyi O. · Reviewed 2 yıldan fazla ago

John M. · Reviewed 2 yıldan fazla ago

Indrajit A. · Reviewed 2 yıldan fazla ago

Adrian C. · Reviewed 2 yıldan fazla ago

Pawel K. · Reviewed 2 yıldan fazla ago

Christodoulos S. · Reviewed 2 yıldan fazla ago

Pawel K. · Reviewed 2 yıldan fazla ago

This lab is INCORRECT. Task 4 says "Delete data from the oxford_policy_tracker_by_countries table in the covid_data BigQuery dataset where the population and country_area value is null." DELETE FROM covid_data.oxford_policy_tracker_by_countries WHERE population is Null AND country_area is null; should be the solution. But it is incorrect. The lab requires using an OR instead of AND. Therefore the question is WRONG. DELETE FROM covid_data.oxford_policy_tracker_by_countries WHERE population is Null OR country_area is null; It should say "Delete data from the oxford_policy_tracker_by_countries table in the covid_data BigQuery dataset where the population OR country_area value is null.

Scott C. · Reviewed 2 yıldan fazla ago

xalid O. · Reviewed 2 yıldan fazla ago

Ahmad T. · Reviewed 2 yıldan fazla ago

Arif T. · Reviewed 2 yıldan fazla ago

Hannah M. · Reviewed 2 yıldan fazla ago

Marcin F. · Reviewed 2 yıldan fazla ago

Ahmed S. · Reviewed 2 yıldan fazla ago

Michele C. · Reviewed 2 yıldan fazla ago

Gabriel A. · Reviewed 2 yıldan fazla ago

Juan Manuel S. · Reviewed 2 yıldan fazla ago

Utku K. · Reviewed 2 yıldan fazla ago

Minenhle N. · Reviewed 2 yıldan fazla ago

Joao L. · Reviewed 2 yıldan fazla ago

Franco Javier M. · Reviewed 2 yıldan fazla ago

Jan B. · Reviewed 2 yıldan fazla ago

Phew, got it done

Barry M. · Reviewed 2 yıldan fazla ago

xalid O. · Reviewed 2 yıldan fazla ago