
Ultimate access to all questions.
You are tasked with designing a BigQuery data warehouse aimed at analyzing sales data for a telecommunication service provider. The primary requirement is to create an effective data model encompassing customers, products, and subscriptions. Each of these entities can be updated monthly, and it is crucial to maintain a comprehensive historical record of all changes. The designed data model would serve both current and historical reporting needs through a visualization layer. Your goal is to ensure that the data model remains simple, user-friendly, and cost-efficient. What approach should you take?
A
Create a normalized model with tables for each entity. Use snapshots before updates to track historical data.
B
Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data.
C
Create a denormalized model with nested and repeated fields. Update the table and use snapshots to track historical data.
D
Create a denormalized, append-only model with nested and repeated fields. Use the ingestion timestamp to track historical data.