Topic 1 Question 252
You 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?
Create a normalized model with tables for each entity. Use snapshots before updates to track historical data.
Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data.
Create a denormalized model with nested and repeated fields. Update the table and use snapshots to track historical data.
Create a denormalized, append-only model with nested and repeated fields. Use the ingestion timestamp to track historical data.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: D
D. Create a denormalized, append-only model with nested and repeated fields. Use the ingestion timestamp to track historical data.
👍 2scaenruy2024/01/03 - A denormalized, append-only model simplifies query complexity by eliminating the need for joins.
- Adding data with an ingestion timestamp allows for easy retrieval of both current and historical states.
- Instead of updating records, new records are appended, which maintains historical information without the need to create separate snapshots.
👍 2raaad2024/01/04- 正解だと思う選択肢: D
Easy, cost effective and no cpmpexity
👍 1GCP0012024/01/08
シャッフルモード