关于“透過 BigQuery 建構資料倉儲：挑戰實驗室”的评价

Amir Z. · 评论about 2 years之前

Marko C. · 评论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. · 评论about 2 years之前

Oluwaseyi O. · 评论about 2 years之前

John M. · 评论about 2 years之前

Indrajit A. · 评论about 2 years之前

Adrian C. · 评论about 2 years之前

Pawel K. · 评论about 2 years之前

Christodoulos S. · 评论about 2 years之前

Pawel K. · 评论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. · 评论about 2 years之前

xalid O. · 评论about 2 years之前

Ahmad T. · 评论about 2 years之前

Arif T. · 评论about 2 years之前

Hannah M. · 评论about 2 years之前

Marcin F. · 评论about 2 years之前

Ahmed S. · 评论about 2 years之前

Michele C. · 评论about 2 years之前

Gabriel A. · 评论about 2 years之前

Juan Manuel S. · 评论about 2 years之前

Utku K. · 评论about 2 years之前

Minenhle N. · 评论about 2 years之前

Joao L. · 评论about 2 years之前

Franco Javier M. · 评论about 2 years之前

Jan B. · 评论about 2 years之前