SnowPro Advanced: Architect — Question 131
A company needs to adopt a data modeling technique that fits this business model:
1. A virtual data warehouse is needed to support data analytics
2. Data comes from diverse sources
3. Data has frequent structural changes
4. Need the ability to audit each structural change as it happens at the source
Which modeling technique will meet the company’s requirements?
Answer options
- A. Data Vault modeling
- B. Dimensional data modeling
- C. Star schema modeling
- D. Snowflake schema modeling
Correct answer: A
Explanation
Data Vault modeling is designed to handle diverse data sources and frequent structural changes, making it ideal for the company's needs. Unlike Dimensional data modeling, Star schema modeling, and Snowflake schema modeling, Data Vault provides the necessary flexibility and audit capabilities for tracking structural changes at the source.