In cloud architectures, which statement correctly differentiates a data lake from a data warehouse?

In cloud architectures, which statement correctly differentiates a data lake from a data warehouse?

• A. A data warehouse stores raw data; a data lake stores structured data.
• B. A data lake stores operational data; a data warehouse stores archival data.
• C. A data lake stores raw, diverse data; a data warehouse stores structured, analytics-ready data.
• D. A data lake is a secure version of a data warehouse.

Answer: (C)

The main distinction is how the data is stored and prepared for use. A data lake keeps raw, diverse data in its native formats—structured, semi-structured, and unstructured—without enforcing a strict schema upfront. This makes it flexible for discovery and advanced analytics because you can apply schema later as you analyze the data. A data warehouse, on the other hand, stores structured, cleaned, and context-enriched data that’s ready for analytics and reporting, with a schema defined before loading to optimize performance and consistency. That’s why the statement that a data lake stores raw, diverse data while a data warehouse stores structured, analytics-ready data is the best description. The other options mischaracterize the roles: data warehouses aren’t repositories of raw data, data lakes aren’t defined by operational versus archival data, and a data lake isn’t simply a more secure version of a data warehouse—the difference is in data variety and preparation approach, not security.

The main distinction is how the data is stored and prepared for use. A data lake keeps raw, diverse data in its native formats—structured, semi-structured, and unstructured—without enforcing a strict schema upfront. This makes it flexible for discovery and advanced analytics because you can apply schema later as you analyze the data. A data warehouse, on the other hand, stores structured, cleaned, and context-enriched data that’s ready for analytics and reporting, with a schema defined before loading to optimize performance and consistency.

That’s why the statement that a data lake stores raw, diverse data while a data warehouse stores structured, analytics-ready data is the best description. The other options mischaracterize the roles: data warehouses aren’t repositories of raw data, data lakes aren’t defined by operational versus archival data, and a data lake isn’t simply a more secure version of a data warehouse—the difference is in data variety and preparation approach, not security.