Working with JSON and Array data in BigQuery 2.5 Ulasan

Jorge A. · Diulas 12 bulan lalu

Mauricio H. · Diulas 12 bulan lalu

Bien

Víctor C. · Diulas 12 bulan lalu

Nassim B. · Diulas 12 bulan lalu

Nicolas S. · Diulas 12 bulan lalu

Nassim B. · Diulas 12 bulan lalu

Marco Q. · Diulas 12 bulan lalu

Kalaiselvi S. · Diulas 12 bulan lalu

Damindu V. · Diulas 12 bulan lalu

good

Palak G. · Diulas 12 bulan lalu

Rohit R. · Diulas 12 bulan lalu

Too more tasks for an hour, so we cannot go deep for each task.

Katawut W. · Diulas 12 bulan lalu

Paula B. · Diulas 12 bulan lalu

Sumit P. · Diulas 12 bulan lalu

Alessandro C. · Diulas 12 bulan lalu

Albert X. · Diulas 12 bulan lalu

Romain B. · Diulas 12 bulan lalu

JONATHAN R. · Diulas 12 bulan lalu

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. · Diulas 12 bulan lalu

ERIC C. · Diulas 12 bulan lalu

JUAN JOSE M. · Diulas 12 bulan lalu

Romain M. · Diulas 12 bulan lalu

Adrianna R. · Diulas 12 bulan lalu

Manimalaimurugan C. · Diulas 12 bulan lalu

Gnana Prasanna K. · Diulas 12 bulan lalu