Working with JSON and Array data in BigQuery 2.5 Reviews

Alessandro C. · Reviewed מעל שנה אחת ago

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