Criar um data warehouse com o BigQuery: laboratório com desafio avaliações

Amir Z. · Revisado há about 2 years

Marko C. · Revisado há about 2 years

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. · Revisado há about 2 years

Oluwaseyi O. · Revisado há about 2 years

John M. · Revisado há about 2 years

Indrajit A. · Revisado há about 2 years

Adrian C. · Revisado há about 2 years

Pawel K. · Revisado há about 2 years

Christodoulos S. · Revisado há about 2 years

Pawel K. · Revisado há about 2 years

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. · Revisado há about 2 years

xalid O. · Revisado há about 2 years

Ahmad T. · Revisado há about 2 years

Arif T. · Revisado há about 2 years

Hannah M. · Revisado há about 2 years

Marcin F. · Revisado há about 2 years

Ahmed S. · Revisado há about 2 years

Michele C. · Revisado há about 2 years

Gabriel A. · Revisado há about 2 years

Juan Manuel S. · Revisado há about 2 years

Utku K. · Revisado há about 2 years

Minenhle N. · Revisado há about 2 years

Joao L. · Revisado há about 2 years

Franco Javier M. · Revisado há about 2 years

Jan B. · Revisado há about 2 years