Data Lake vs Data Warehouse — Concept Check
Questions on Data Lake vs Data Warehouse. A data warehouse stores structured, transformed data optimised for analytics queries. A data lake stores raw data in any format at massive scale. Modern lakehouses combine both approaches.
Questions in this quiz
7 questions on Data Lake vs Data Warehouse — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A company needs to store large volumes of raw data in various formats for future analytics. Which solution should they choose?
- AData Lake
- BData Warehouse
- CRelational Database
- DIn-memory Database
2.An analyst reports that queries on a new data storage system are slower than expected. The system uses schema-on-read. What might be the cause?
- AData is stored in a columnar format
- BData is not pre-optimized for queries
- CData transformation occurs before storage
- DData is structured and cleansed
3.A company wants to ensure ACID transactions and time-travel capabilities in their data storage. Which architecture should they adopt?
- AData Warehouse
- BLakehouse
- CTraditional Data Lake
- DNoSQL Database
4.A business needs fast analytics on structured data with high storage costs. Which solution aligns with their needs?
- AData Warehouse
- BLakehouse
- CData Lake
- DDocument Store
5.A team is using a data lake and notices data quality issues. What might be contributing to this problem?
- AColumnar storage format
- BHigh storage costs
- CLack of schema enforcement
- DACID transaction support
6.Which feature is unique to lakehouses compared to traditional data lakes?
- ALow storage cost
- BSchema-on-read
- CACID transactions
- DSupport for any data format
7.A company wants to store data in a format that allows for both structured and unstructured data with moderate cost. Which architecture should they consider?
- ALakehouse
- BIn-memory Database
- CGraph Database
- DData Warehouse