Data Lake vs Data Warehouse

Problem

Your company is storing petabytes of raw, unstructured server logs alongside clean business spreadsheets. You need to choose the storage solution. Write a query that outputs comparison with the value: "A data warehouse stores structured, processed data optimized for SQL queries, whereas a data lake stores raw, unstructured, or semi-structured data at scale."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution