Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You have several large tables in your transaction databases. You need to move all the data to BigQuery for the business analysts to explore and analyze the data.
A
Retain the data on BigQuery with the same schema as the source.
B
Combine all the transactional database tables into a single table using outer joins.
C
Redesign the schema to normalize the data by removing all redundancies.
D
Redesign the schema to denormalize the data with nested and repeated data.