Google Professional Data Engineer
Get started today
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?
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?
Exam-Like