Question 249 of 307
Single answerYou are designing a data warehouse in BigQuery to analyze sales data for a telecommunication service provider. You need to create a data model for customers, products, and subscriptions. All customers, products, and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan to use the visualization layer for current and historical reporting. You need to ensure that the data model is simple, easy-to-use, and cost-effective. What should you do?
ACreate a normalized model with tables for each entity. Use snapshots before updates to track historical data.
BCreate a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data.
CCreate a denormalized model with nested and repeated fields. Update the table and use snapshots to track historical data.
✓DCreate a denormalized, append-only model with nested and repeated fields. Use the ingestion timestamp to track historical data.
✓
Correct Answer: D
Create a denormalized, append-only model with nested and repeated fields. Use the ingestion timestamp to track historical data.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.