Question

You are looking for a SQL system to integrate and query both historical and production data.
The data must be organized in complex structures. In particular, it is necessary to store orders and invoices in a denormalized and complete manner with the header and detail within the same structure.
Which of the following products do you choose?

A. Cloud Datastore
B. Cloud Spanner
C. Cloud Bigtable
D. BigQuery
E. Cloud SQL

Answer 1

Correct Answer: D
BigQuery is an OLAP engine. So, it is far better, even if it can manage normalised data and joins, to have denormalized information.
In addition BigQuery can manage nested and repeated columns and structures, as required.
BigQuery is not a Database but an enterprise, serverless, highly scalable, and cost-effective cloud data data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google’s infrastructure.
It can quickly analyze gigabytes to petabytes of data using ANSI SQL.