Working with JSON and Array data in BigQuery 2.5 Reviews

Pravin S. · Reviewed 1 yıldan fazla ago

NANCY PAOLA P. · Reviewed 1 yıldan fazla ago

Syed Ghayur Abbas N. · Reviewed 1 yıldan fazla ago

Some parts might be checked because of old Bigquery Interface (grey area not longer grey for nested fields). But really helpful and good for own thinking :)

Luise W. · Reviewed 1 yıldan fazla ago

Cristobal V. · Reviewed 1 yıldan fazla ago

Renato R. · Reviewed 1 yıldan fazla ago

Jorge A. · Reviewed 1 yıldan fazla ago

Mauricio H. · Reviewed 1 yıldan fazla ago

Bien

Víctor C. · Reviewed 1 yıldan fazla ago

Nassim B. · Reviewed 1 yıldan fazla ago

Nicolas S. · Reviewed 1 yıldan fazla ago

Nassim B. · Reviewed 1 yıldan fazla ago

Marco Q. · Reviewed 1 yıldan fazla ago

Kalaiselvi S. · Reviewed 1 yıldan fazla ago

Damindu V. · Reviewed 1 yıldan fazla ago

good

Palak G. · Reviewed 1 yıldan fazla ago

Rohit R. · Reviewed 1 yıldan fazla ago

Too more tasks for an hour, so we cannot go deep for each task.

Katawut W. · Reviewed 1 yıldan fazla ago

Paula B. · Reviewed 1 yıldan fazla ago

Sumit P. · Reviewed 1 yıldan fazla ago

Alessandro C. · Reviewed 1 yıldan fazla ago

Albert X. · Reviewed 1 yıldan fazla ago

Romain B. · Reviewed 1 yıldan fazla ago

JONATHAN R. · Reviewed 1 yıldan fazla ago

This lab should be reviewed. The first question is misleading, as the best answer is "all of the above". If you have a big table, a change in the email address of the customer would need to be reflected in the whole table. If it's an order table, maybe the customer bought a lot of stuff and thus has a lot of lines. We would need to change all those lines. So second answer is good. The third answer is quite valid too. There could be different granularities. Let's say we store "order lines", we could have data related to the "order header". So this would need to be taken into account in the reporting. The correct answer is then "All of the above". + Implicit join on arrays should be considered a bad practice.

SIMON R. · Reviewed 1 yıldan fazla ago