Working with JSON and Array data in BigQuery 2.5 Reviews

Alessandro C. · Reviewed over 1 year ago

Albert X. · Reviewed over 1 year ago

Romain B. · Reviewed over 1 year ago

JONATHAN R. · Reviewed over 1 year 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 over 1 year ago

ERIC C. · Reviewed over 1 year ago

JUAN JOSE M. · Reviewed over 1 year ago

Romain M. · Reviewed over 1 year ago

Adrianna R. · Reviewed over 1 year ago

Manimalaimurugan C. · Reviewed over 1 year ago

Gnana Prasanna K. · Reviewed over 1 year ago

good

Palak G. · Reviewed over 1 year ago

Sasikiran R. · Reviewed over 1 year ago

Srinivasa Rao V. · Reviewed over 1 year ago

Priyadarshini I. · Reviewed over 1 year ago

n

Palak G. · Reviewed over 1 year ago

Amita J. · Reviewed over 1 year ago

Santanu G. · Reviewed over 1 year ago

Manish P. · Reviewed over 1 year ago

MOISES ALFONSO G. · Reviewed over 1 year ago

Pradeep S. · Reviewed over 1 year ago

poco tiempo

Rafael N. · Reviewed over 1 year ago

Douglas Tassio Henrique D. · Reviewed over 1 year ago

Nicolas L. · Reviewed over 1 year ago

Elmar G. · Reviewed over 1 year ago