Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When designing a data model in BigQuery for retail transaction data with tables sales_transaction_header and sales_transaction_line that have a closely connected and unchangeable relationship, how can you structure these tables to optimize the efficiency of data analytics queries?
A
Store sales_transaction_header and sales_transaction_line data as a JSON data type in a single table.
B
Create separate sales_transaction_header and sales_transaction_line tables, and prioritize sales_transaction_line in the WHERE clause during queries.
C
Design a sales_transaction table with sales_transaction_header information as rows and sales_transaction_line rows as nested and repeated fields._
D
Combine sales_transaction_header and sales_transaction_line into a single table, duplicating header data for each line.