Working with JSON and Array data in BigQuery 2.5 Reviews

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

ERIC C. · Reviewed 1 yıldan fazla ago

JUAN JOSE M. · Reviewed 1 yıldan fazla ago

Romain M. · Reviewed 1 yıldan fazla ago

Adrianna R. · Reviewed 1 yıldan fazla ago

Manimalaimurugan C. · Reviewed 1 yıldan fazla ago

Gnana Prasanna K. · Reviewed 1 yıldan fazla ago

good

Palak G. · Reviewed 1 yıldan fazla ago

Sasikiran R. · Reviewed 1 yıldan fazla ago

Srinivasa Rao V. · Reviewed 1 yıldan fazla ago

Priyadarshini I. · Reviewed 1 yıldan fazla ago

n

Palak G. · Reviewed 1 yıldan fazla ago

Amita J. · Reviewed 1 yıldan fazla ago

Santanu G. · Reviewed 1 yıldan fazla ago

Manish P. · Reviewed 1 yıldan fazla ago

MOISES ALFONSO G. · Reviewed 1 yıldan fazla ago

Pradeep S. · Reviewed 1 yıldan fazla ago

poco tiempo

Rafael N. · Reviewed 1 yıldan fazla ago

Douglas Tassio Henrique D. · Reviewed 1 yıldan fazla ago

Nicolas L. · Reviewed 1 yıldan fazla ago

Elmar G. · Reviewed 1 yıldan fazla ago

Shincy J. · Reviewed 1 yıldan fazla ago