Ultimate access to all questions.
Upgrade Now š
Sign in to unlock AI tutor
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.