Working with JSON and Array data in BigQuery 2.5 Reviews

Albert X. · Reviewed أكثر من سنة ago

Romain B. · Reviewed أكثر من سنة ago

JONATHAN R. · Reviewed أكثر من سنة 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 أكثر من سنة ago

ERIC C. · Reviewed أكثر من سنة ago

JUAN JOSE M. · Reviewed أكثر من سنة ago

Romain M. · Reviewed أكثر من سنة ago

Adrianna R. · Reviewed أكثر من سنة ago

Manimalaimurugan C. · Reviewed أكثر من سنة ago

Gnana Prasanna K. · Reviewed أكثر من سنة ago

good

Palak G. · Reviewed أكثر من سنة ago

Sasikiran R. · Reviewed أكثر من سنة ago

Srinivasa Rao V. · Reviewed أكثر من سنة ago

Priyadarshini I. · Reviewed أكثر من سنة ago

n

Palak G. · Reviewed أكثر من سنة ago

Amita J. · Reviewed أكثر من سنة ago

Santanu G. · Reviewed أكثر من سنة ago

Manish P. · Reviewed أكثر من سنة ago

MOISES ALFONSO G. · Reviewed أكثر من سنة ago

Pradeep S. · Reviewed أكثر من سنة ago

poco tiempo

Rafael N. · Reviewed أكثر من سنة ago

Douglas Tassio Henrique D. · Reviewed أكثر من سنة ago

Nicolas L. · Reviewed أكثر من سنة ago

Elmar G. · Reviewed أكثر من سنة ago

Shincy J. · Reviewed أكثر من سنة ago