Working with JSON and Array data in BigQuery 2.5 Reviews

Alessandro C. · Reviewed больше 1 года ago

Albert X. · Reviewed больше 1 года ago

Romain B. · Reviewed больше 1 года ago

JONATHAN R. · Reviewed больше 1 года 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 года ago

ERIC C. · Reviewed больше 1 года ago

JUAN JOSE M. · Reviewed больше 1 года ago

Romain M. · Reviewed больше 1 года ago

Adrianna R. · Reviewed больше 1 года ago

Manimalaimurugan C. · Reviewed больше 1 года ago

Gnana Prasanna K. · Reviewed больше 1 года ago

good

Palak G. · Reviewed больше 1 года ago

Sasikiran R. · Reviewed больше 1 года ago

Srinivasa Rao V. · Reviewed больше 1 года ago

Priyadarshini I. · Reviewed больше 1 года ago

n

Palak G. · Reviewed больше 1 года ago

Amita J. · Reviewed больше 1 года ago

Santanu G. · Reviewed больше 1 года ago

Manish P. · Reviewed больше 1 года ago

MOISES ALFONSO G. · Reviewed больше 1 года ago

Pradeep S. · Reviewed больше 1 года ago

poco tiempo

Rafael N. · Reviewed больше 1 года ago

Douglas Tassio Henrique D. · Reviewed больше 1 года ago

Nicolas L. · Reviewed больше 1 года ago

Elmar G. · Reviewed больше 1 года ago