PROFESSIONAL-DATA-ENGINEER · Question #334
PROFESSIONAL-DATA-ENGINEER Question #334: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #334. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.