SnowPro Advanced: Architect — Question 160

Why does a conditional multi-table INSERT option support the Data Vault data model?

Answer options

• A. Data can be inserted in parallel to hubs and satellites using surrogate keys.
• B. Data can be inserted in parallel to dimensions and facts using surrogate keys.
• C. Data can be inserted in sequence to hubs and satellites using surrogate keys.
• D. Data can be inserted in sequence to dimensions and facts using surrogate keys.

Correct answer: A

Explanation

The correct answer, A, highlights that Data Vault allows data to be inserted simultaneously into hubs and satellites, which is essential for maintaining data integrity and performance. Options B, C, and D incorrectly refer to dimensions and facts or imply sequential insertion, which does not align with the principles of the Data Vault methodology.