Snowpro Advanced Architect · Free Practice Question Medium
Question 39
- A Staging -> Landing -> Raw -> Mart -> Conformed
- B Landing -> Raw -> Staging -> Conformed -> Mart
- C Raw -> Mart -> Landing -> Staging -> Conformed
- D Mart -> Raw -> Staging -> Conformed
Reveal correct answer
Correct answer: B
Explanation
✅ Landing -> Raw -> Staging -> Conformed -> Mart
Explanation:
A modern Snowflake data lake architecture typically follows a structured zone-based approach to efficiently manage data ingestion, transformation, and consumption. The most common sequence is:
Landing Zone → Initial storage for raw, unprocessed data from various sources.
Raw Zone → Stores data in its original format, ensuring data integrity before transformations.
Staging Zone → Intermediate processing area where data cleaning, validation, and enrichment occur.
Conformed Zone → Standardized, structured data ready for analytics and reporting.
Mart Zone → Optimized for business intelligence and end-user consumption, often structured for specific use cases.
For more details, check the official Snowflake documentation on data lake architecture.
❌ Why the other options are incorrect?
Mart -> Raw -> Staging -> Conformed
→ Incorrect, because Mart should be the final layer, not the starting point.
Staging -> Landing -> Raw -> Mart -> Conformed
→ Incorrect, because Landing should come before Raw, and Mart should be the last step.
Raw -> Mart -> Landing -> Staging -> Conformed
→ Incorrect, because Mart should be the final layer, and Landing should precede Raw.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
