Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are tasked with designing a data model in Google BigQuery to manage retail transaction data effectively. Specifically, you have two crucial tables, sales_transaction_header and sales_transaction_line, which are immutably and tightly coupled. These tables are seldom modified after initial loading but are often joined together during queries. To enhance the performance of data analytics queries, you need to decide how to structure the sales_transaction_header and sales_transaction_line tables. What approach should you take?
A
Create a sales_transaction table that holds the sales_transaction_header information as rows and the sales_transaction_line rows as nested and repeated fields._
B
Create a sales_transaction table that holds the sales_transaction_header and sales_transaction_line information as rows, duplicating the sales_transaction_header data for each line._
C
Create a sales_transaction table that stores the sales_transaction_header and sales_transaction_line data as a JSON data type._
D
Create separate sales_transaction_header and sales_transaction_line tables and, when querying, specify the sales_transaction_line first in the WHERE clause.